Editing A Query In A SQL Server DTS Package

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
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

Calendar

Sun Mon Tue Wed Thu Fri Sat
    123
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Subscribe

Enter your email address to subscribe to this blog.

Tags

actionscript ajax blogging cfsnippets coldfusion flash forms flex funny stuff misc model-glue off topic personal project learn slidesix sql

Recent Comments

Managing Sessions In CF Ajax Applications
jlomoglio said: I tried adding this code into my application and when I run it I get the following error: The THENA... [More]

ColdFusion/Sharepoint Integration - Part 1 - Authenticating
share point said: Hi Great Article, I'm new to Sharepoint and this is a great reference to have for our implementation... [More]

TechCrunch/CrunchGear Meetup - The Aftermath
Sam Farmer said: Very cool. [More]

Eclipse - You're Killing Me
Jane Carter said: Eclipse is a nightmare. I have been trying to use CFEclipse - I had to hunt for hours for a hack ju... [More]

Using Flash Forms Inside Of CF 8 Ajax Containers
Howard Ross said: @Gavy I am currently using a work around similar to one you suggest. I use a png type cfchart in a... [More]

RSS


coldfusionbloggers

FullAsAGoog MXNA

Consumed By Feed-Squirrel.com