September 9, 2009 at 8:07 am
I am looking for the means to list out the tables in the SSIS packages I have. I can find the tables on the system but do not know which, if one exists, table to use that would have the objects in the package
September 9, 2009 at 8:11 am
jfn (9/9/2009)
I am looking for the means to list out the tables in the SSIS packages I have. I can find the tables on the system but do not know which, if one exists, table to use that would have the objects in the package
Not sure what you are looking for, do you mean the tables that are used by your SSIS packages.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 8:58 am
Yes. I am hoping to be able to build some kind of table so I can track tables in each package I have.
September 9, 2009 at 9:05 am
jfn (9/9/2009)
Yes. I am hoping to be able to build some kind of table so I can track tables in each package I have.
hmm, it might be possible to do it, but I think you would have to script it. I dont think that information is kept in any sql server tables. you would have to interrogate the SSIS packages directly using a script. I am assuming that you want to do this automatically. otherwise you could just update a table manually.
I could be wrong, if so I would be interested to know how you could do it.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 9:10 am
Ouch. Would think there would be a way besides manually keeping track.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply