View/Edit DTS Query - 03-04-2005 , 09:19 AM
I'm trying to find out how to edit/View my query that I created when I
created my DTS package. When I go to Enterprise Manager and click on Data
Transformation Services, Local Packages and then click on my DTS Package it
takes me to the DTS Gui interface I can see my package when I click on the
properties of the package it only shows me the connection parameters of the
My DTS is scheduled to run a query every 5 minutes and save the output to a
I also checked the Jobs under the service agent to see if I could see the
query in the job steps, All I see id the:
/~Z0xF1E94E88E1DDA0BD9F5AD007C7A2C8C6713BBF7BFD73CC 904947E8831609B4CD61298138B32019913A2A61C696B82498 EFE96E75AE1C7C8CA37A849259296E75C2A878F876BBED2DFD 183624A86A32B1E456587D7EFE95FF3F0B75A07BAD8BB951A3 BE1F0EC1C3775B5C49A0D778D530B795C4
How I can see/edit the query from a DTS package already created.
Thanks in Advance.
Re: View/Edit DTS Query - 03-04-2005 , 09:29 AM
You need to open the data pump task that the query is in, not the connection
object or if it's in an execute sql task, open that.
"Carlos Santos" <CarlosSantos (AT) discussions (DOT) microsoft.com> wrote