September 14, 2009 at 7:20 am
Would like to query thru SQL on how many tasks, variables inside a SSIS Package? How to get it ?
September 14, 2009 at 7:40 am
sureshrajan (9/14/2009)
Would like to query thru SQL on how many tasks, variables inside a SSIS Package? How to get it ?
You cannot via T-SQL, you would need to write a script in one of the .net tools and open the SSIS package that way and iterate through the package, listing the properties that way. unless someone wants to educate you and me together 🙂
--------------------------------------------------------------------------------------
[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]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply