Editing A Query In A SQL Server DTS Package
Posted By : todd sharp Posted At : December 20, 2006 8:17 AM Posted In: SQL
2
For some reason I always struggle with remembering how to do this, so for my own greedy personal reasons I'm blogging it so that I always know where to go to jog my memory.
I (unfortunately) work with a lot of DTS packages in SQL Server 2000 and I can never remember how to modify an existing query on a task. It's really not that hard to do - I just never remember - it's one of those things...
So to edit an existing query, open the package, and go to Package - Disconnected Edit. In the Edit All Package Properties window expand Tasks and select the task that contains the query you're trying to edit. Scroll down if necessary to SourceSQLStatement, double click and voila. Edit the query and you're done.
Not brain surgery, but now I'll never forget how to do it. You may now return to your regularly scheduled blog reading or go watch Christmas In Hollis again.
Why the heck would they put it under "Disconnected Edit" is beyond me. :( Figures, the one menu I didn't want to drill into.