<cfsilence>

Editing A Query In A SQL Server DTS Package

Posted At : December 20, 2006 9:17 AM | Posted By : todd sharp
Related Categories: SQL

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.

Comments (2) |

Print |

Send |

del.icio.us |

Linking Blogs | 2176 Views

Comments

[Add Comment]

Thanks for this little reminder. I'm not that familiar with SQL2k, and I just spent 30 minutes trying to figure out how to view/edit the query behind a DTS package.

Why the heck would they put it under "Disconnected Edit" is beyond me. :( Figures, the one menu I didn't want to drill into.

# Posted By IC | 2/21/07 5:46 PM

Thanks for your post. Never unlike Microsoft to hide stuff in the hardest part time find.

# Posted By JD | 11/18/08 4:51 PM

[Add Comment]