Identifying all destination components within a package
Hello Guys, Is it possible to identify all the destination components within an SSIS package? I wanted to write a custom UI to populate all the available destination components within an SSIS package. Please let me know. thanks
November 16th, 2010 10:07pm

Hi, Its possible, yes. You're going to have to do some XML shredding/parsing. Although the following link isn't a direct answer to your problem it does explain how you can examine the innards of a package using XQuery/T-SQL: Collecting information about your SSIS packages (http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx) -Jamiehttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2010 5:53am

Thanks Jamie. What I am looking for is to get this information from the SSIS package at design time. I have created a custom component with an UI. This UI has a combo box. I want when the Development team uses my custom component, i want my component to identify all the Destination components within my package at design time. When they select one of the destination components, i will want to identify the Destination table and populate the table information from that component in the textbox. I want the user to be able to set the target at design time, without the developer typing that information. Please let me know how this can be done. thanks
November 17th, 2010 9:07am

You can't. The only way you can do something like this is by using the method Jamie pointed out - which means you're examining a previously-saved version of the package. There is no way for a task or component to examine the "current" contents of the package beyond itself. Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 11:55am

Thanks Todd and Jamie.
November 18th, 2010 2:10pm

Thanks Todd and Jamie. I think you can do it by creating a table and put the destination name and the connection string in the table. Then create an Object Variable and assing the connection string to the variable from your drop down list(you can do it with a SQL script or a SP). last step is to assign the variable to the connection property. It should work. Cheers, Ben Mansouri Business Intelligence Architect
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 3:22pm

Thanks Todd and Jamie. I think you can do it by creating a table and put the destination name and the connection string in the table. Then create an Object Variable and assing the connection string to the variable from your drop down list(you can do it with a SQL script or a SP). last step is to assign the variable to the connection property. It should work. Cheers, Ben Mansouri Business Intelligence Architect
November 18th, 2010 3:22pm

Hello Guys, Is it possible to identify all the destination components within an SSIS package? I wanted to write a custom UI to populate all the available destination components within an SSIS package. Please let me know. thanks It is impossible with the regular SSIS api. If you can use third-party solutions check the commercial CozyRoc Package Connection Manager. It allows access to the package object and you can iterate over and extract all destination components from the package.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 4:29pm

Hello Guys, Is it possible to identify all the destination components within an SSIS package? I wanted to write a custom UI to populate all the available destination components within an SSIS package. Please let me know. thanks It is impossible with the regular SSIS api. If you can use third-party solutions check the commercial CozyRoc Package Connection Manager. It allows access to the package object and you can iterate over and extract all destination components from the package.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
November 18th, 2010 4:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics