Hi,

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

My DTS is scheduled to run a query every 5 minutes and save the output to a
..csv file.

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:
DTSRun
/~Z0xF1E94E88E1DDA0BD9F5AD007C7A2C8C6713BBF7BFD73CC 904947E8831609B4CD61298138B32019913A2A61C696B82498 EFE96E75AE1C7C8CA37A849259296E75C2A878F876BBED2DFD 183624A86A32B1E456587D7EFE95FF3F0B75A07BAD8BB951A3 BE1F0EC1C3775B5C49A0D778D530B795C4

How I can see/edit the query from a DTS package already created.

Thanks in Advance.
Carlos

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.

--
Simon Worth


"Carlos Santos" <CarlosSantos (AT) discussions (DOT) microsoft.com> wrote

8B32019913A2A61C696B82498EFE96E75AE1C7C8CA37A84925 9296E75C2A878F876BBED2DFD1
83624A86A32B1E456587D7EFE95FF3F0B75A07BAD8BB951A3B E1F0EC1C3775B5C49A0D778D53
0B795C4