One of our former DBA's made some jobs with DTS-packages but I can't find the
source for the packages.
When I open the jobs I see DTS Run /~Z and a bunch of numbers and letters.
But where can I find the actual source of the DTS-packages so I can edit them?

Regards

In Data Transformation Services/Local Packages (if you have permissions)

http://sqlservercode.blogspot.com/



"Zekske" wrote:

Nope, can't see them while I'm using the sa account.
When I look in msdb.sysdtspackages I see the packages but also there is no
sourcecode.
and I don't know wich ID to use to find the source in sycomments.

"SQL" wrote:

Double click the job to open the properties. In the Description field you
will see the package name.
Then go to Data Transformation Services/Local Packages and double click on
the package to see the contents.

"Zekske" <Zekske (AT) discussions (DOT) microsoft.com> wrote

That's my problem, I can't see any packages in the Local Packages. So I need
to know where the DTS commands are kept in the SQL-database itself.


"partha" wrote:

Hello Zekske,

The packages are stored in the packagedata column in msdd.dbo.sysdtspackages.
There are a number of ways you can retrieve them

Execution
(http://www.sqldts.com/default.aspx?104)

Can you see them from any other PC?


Allan

Nope can't see them from another PC.

When I look at the packagedata column I see the binary data but I can't see
what the package actually does.
It seems like the link between the local packages and the msdb table is
gone...


"Allan Mitchell" wrote:

Hello Zekske,


Strange that you cannot see these packages on this server even from a different
PC. As a temprary fix you can write a piece of code that uses the object
model and grabs the package from the SQL Server and "Save As" a structured
Storage file. You should then be able to open these up in EM.

Have they ever been visible?

Allan