 |
|
|
|
Next: Finding Acute-e
|
| Author |
Message |
External
Since: Sep 18, 2006
Posts: 24
|
(Msg. 1) Posted: Mon Aug 27, 2007 7:58 pm
Post subject: Configure Execute Package Task
Archived from groups: microsoft>public>sqlserver>dts (more info?)
|
|
|
|
|
| Back to top |
|
 | |
| Related Topics: | execute package of a number of execute package tasks - In a project I have created 6 dtsx packages, all doing about the same thing: sql task defines highest date in database and store in variable script task to create an oracle sql statement based on the above date dataflow task to 1.select from oracle...
DTS "Execute SQL Task" - I have a Execute SQL Task that copy/transfer a big SQL table by executing: insert into .... select ... from .... Is there any benefit to run the sql in DTS (batch/lock handling)? Or it's the same to run it use Job schedule or just isqlw?
DTS Parameter on Execute SQL Task - First I am trying to use DTS for purging data. The first thing I want to do is export the data to be purged to a csv file. I am using parameters to hold variables such as dates. The export routines work using transform data task using the following....
can i create dynamic execute SQL task ? - Hi All, i have a existing DTS package, however the execute SQL task keep changing, instead, i will create one table to store those execute SP name and using query to run for it. do you think the idea is possible?
Execute DTS package in SP - How would I execute DTS package in the SP? Thank you. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
