| Author |
Source of DTS-packages
|
|
| Zekske 2005-10-27, 7:57 am |
| 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:
> 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
| |
| Zekske 2005-10-27, 7:57 am |
| 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:
[color=darkred]
> In Data Transformation Services/Local Packages (if you have permissions)
>
> http://sqlservercode.blogspot.com/
>
>
>
> "Zekske" wrote:
>
| |
| partha 2005-10-27, 7:57 am |
| 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@discussions.microsoft.com> wrote in message
news:ACA9FFEE-0DB3-453D-B80F- E353A6FD09FF@microso
ft.com...[color=darkred]
> 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:
>
find the[color=darkred]
letters.[color=darkred]
edit them?[color=darkred]
| |
| Zekske 2005-10-27, 7:57 am |
| 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:
> 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@discussions.microsoft.com> wrote in message
> news:ACA9FFEE-0DB3-453D-B80F- E353A6FD09FF@microso
ft.com...
> find the
> letters.
> edit them?
>
>
>
| |
| Allan Mitchell 2005-10-27, 7:57 am |
| 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
[color=darkred]
> 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:
>
| |
| Zekske 2005-10-27, 7:57 am |
| 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,
>
> 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
>
>
>
>
>
| |
| Allan Mitchell 2005-10-27, 7:57 am |
| 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
[color=darkred]
> 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:
>
|
|
|
|