May 27, 2004 at 5:26 pm
This one should be simple.
I have created a SQL file to add an index to a rather large table...over 1 million records.
I created a new dts script, created a connection to the database and used the ExecSQl task to create the index rebuild. I also scheduled it to run tonight. I noticed I was not able to link the connection to the exec sql function using the workflow arrows. Is that normal?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
May 28, 2004 at 12:03 am
Yes it is normal. In the properties of the ExecSQL task you can set your connection , if there are more than one in the DTS.
You sometimes do link a task to a connection for eg. Importing a Text file.....
Andy.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply