How i change a SQLStatement of a DTS??

[jnokia]

hello,

i have a package thats copy some rows to a file, using ActiveX transform, that ok. But i need to change some times this SQL, but not doing at Enterprise manager design.

Anybody have a script? or know how i change it??

thanks, Jose

 

[foxdev]

I don't know of any way to change an existing DTS job outside of the DTS editor (perhaps there's a way through DMO). You might consider pulling the code out of the DTS job and have the job call a stored procedure instead; you could then change the stored procedure outside of the DTS/EM environment whenever you needed to. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com