Job steps - Data sources

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

You mean for documentation purposes?

You'll need to parse the SSIS package to get that information (a .dtsx file is just a XML file).

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Kills Hall of Fame Points: 3154 More actions · Answer 2

Hi,

Basically I need to know which of these jobs are connecting to which servers when the job step runs a T-SQL script or when running a ssis package?

Is this possible and how?

Thanks

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

As I said, for SSIS package you'll need to parse the XML file to get the connection manager info.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Kills Hall of Fame Points: 3154 More actions · Answer 4

How do you do this?

Would you physcially have to open each ssis package in Visual Studio and then right click on the dtsx and then select "View Code"

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

No. If your SSIS packages are stored in the MSDB database, you can query them using XML functions.

Here's a starting point:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

SQL_Kills Hall of Fame Points: 3154 More actions · Answer 6

Hall of Fame

Points: 3154

September 17, 2013 at 6:52 am

Thanks I'll have a look into this