DTS "Execute SQL Task"

FAQ

Profile

DTS "Execute SQL Task"

Database Forums (Home) -> DTS

Next: Passive node starting the SQL Server services - s..

Author

Message

nick

External

Since: Mar 17, 2006
Posts: 4

(Msg. 1) Posted: Sun Mar 26, 2006 2:46 pm
Post subject: DTS "Execute SQL Task"
Archived from groups: microsoft>public>sqlserver>dts (more info?)

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?

>> Stay informed about: DTS ""Execute SQL Task""

Display posts from previous:

Related Topics:

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....

Configure Execute Package Task - Hi, Any one can provide information about configuring a execute package task? Thanks,

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 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...

SSIS FTP Task -

	Database Forums (Home) -> DTS	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

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