MS SQL Server DTS - Ability to see DTS code outside of the IDE?

Author

Ability to see DTS code outside of the IDE?

Stephen

2005-07-22, 11:23 am

I just got a new gig and they are yelling that one job isn't running.
I see that I'm suposed to pass data to a SERVER that nobody here knows
about? It's listed as our #1 client by name. They, being a bank,
wouldn't open themselfs up for me to pass data, now would they?

So if I can extract out of the DTS job what was going on with respect
to passing to that other server, I'd know more if I get on the phone
with them.

I'm hoping to find an IP address for the listed server. That would
define if the server was really in house or at theirs.

TIA

__Stephen

Allan Mitchell

2005-07-23, 3:23 am

Do you have control over the job?
Why do they think it's you?

If you have control over the job then you can get the package name. I
presume you have the package also.

What does the job step look like. Let me guess
DTSRUN ~/Z27459723697265976...

If this is the case and your question is what's the name of the package then
there is a non MS utility out there that cracks this string but you can also
fire up profiler and see which package gets called if it is stored in MSDB.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"Stephen" < srussell@transaction
graphics.com> wrote in message
news:1122049090.538778.17770@g44g2000cwa.googlegroups.com...
>I just got a new gig and they are yelling that one job isn't running.
> I see that I'm suposed to pass data to a SERVER that nobody here knows
> about? It's listed as our #1 client by name. They, being a bank,
> wouldn't open themselfs up for me to pass data, now would they?
>
> So if I can extract out of the DTS job what was going on with respect
> to passing to that other server, I'd know more if I get on the phone
> with them.
>
> I'm hoping to find an IP address for the listed server. That would
> define if the server was really in house or at theirs.
>
> TIA
>
> __Stephen
>

Stephen Russell

2005-07-25, 9:29 am

I am the replacement Developer/DBA and this package is know. I can open
it up in EM just fine.

I run it and step 2 fails. I know that step 2 is the passing of my
result set to another SERVER.

That server is not know by anyone here. I am not sure if it's our
clients or ours. Because of this I'd love to see the IP address for
that server.

*** Sent via Developersdex http://www.droptable.com ***

Allan Mitchell

2005-07-25, 8:29 pm

Look in the connection properties for the DataPump task (both) then as this
will tell you what the Source server is and to where it is going

What is the error?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"Stephen Russell" < srussell@transaction
graphics.com> wrote in message
news:uCEeP1RkFHA.1048@tk2msftngp13.phx.gbl...
>I am the replacement Developer/DBA and this package is know. I can open
> it up in EM just fine.
>
> I run it and step 2 fails. I know that step 2 is the passing of my
> result set to another SERVER.
>
> That server is not know by anyone here. I am not sure if it's our
> clients or ours. Because of this I'd love to see the IP address for
> that server.
>
>
>
>
>
> *** Sent via Developersdex http://www.droptable.com ***

Sponsored Links