Thursday, February 9, 2012

3rd party components/API support in SISS

Greetings,

I was just getting through the features of SSIS, i wanted to confirm a few things

    can i make my own dll in .net (version 2.0 or earlier) and use them im SISS via Execute Script? thers is one thing i saw on msn that i can make my ssis packages reusable by adding them on mt tool box and drag drop use them on other ssis packages. correct? can i use any other 3rd party components like APIs, or some other ETL tool's package in SISS ?

regards,

adnan shamim

1. Yes, you can use the Script task or component to reference external .NET assemblies.

2. You can't add a package to your toolbar. You can call packages from other packages. And you can create custom tasks and components to reuse across multiple packages.

3. You can call outside APIs from the script task or component. You can also use Execute Process to run external executables.

|||Thank you very much for the timely response welch! . i really appreciate it.

No comments:

Post a Comment