Another option (if you're concerned with the length), save the query as a stored procedure, and call the stored procedure in the dts- one line of code. Also, if you want to archive the doc/rename it/ whatever, you can add a step to the dts package to execute program. For the program, write a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.