April 17, 2008 at 10:35 am
Hi, a 3rd party are about to commence design for a dot net assembly which will be used to 'pseudonymise' data that is subject to privacy restrictions. I need to know if it is possible to create a custom c# (or any CLR compliant language) from within SSIS. Data will be loaded into the component, 1 row at a time, and will be modified by the component before continuing its path through the data flow. Any help on this would be hugely appreciated.
David
April 17, 2008 at 10:36 am
CORRECTION TO PREVIOUS POSTING
Hi, a 3rd party are about to commence design for a dot net assembly which will be used to 'pseudonymise' data that is subject to privacy restrictions. I need to know if it is possible to call a custom c# (or any CLR compliant language) from within SSIS ? Data will be loaded into the component, 1 row at a time, and will be modified/transformed by the component before continuing its path through the data flow. Any help on this would be hugely appreciated.
David
April 17, 2008 at 11:02 am
You are able to create custom data flow transformations in SSIS using any .Net language. MS has published the necessary documentation on the MSDN website, there is sample code on the web (www.sqlbi.com comes to mind), and I believe there is also sample code included in the SQL 2005 install for this.
You could use a script component (VB.Net only in SQL 2005, but you can use C# in SQL 2008) as a transformation component and write the code in the script component.
April 17, 2008 at 11:03 am
Just to add to this, it is fairly easy to do. MS designed the platform with the intention of having developers create custom components.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply