Post reply

Running .NET components from SSIS

  • September 25, 2009 at 12:25 pm

    #139011

    Can I run a custom C# .NET component from SSIS such as you can do in BizTalk?

  • September 25, 2009 at 12:44 pm

    #1058626

    I'm not that familiar with BizTalk, but SSIS does support the use of custom code and/or components. You can build a custom data flow component using VB.NET or C# and integrate it within your package. Alternatively, you can reference custom objects or methods within external DLLs from the Script Task or Script Component.

    Check out Wrox publishing "Professional SQL Server Integration Services" (one book for 2005, another specific to 2008); both include good basic overview of using custom code in SSIS.

    hth,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • September 30, 2009 at 11:13 am

    #1060095

    roundel1900 (9/25/2009)

    Can I run a custom C# .NET component from SSIS such as you can do in BizTalk?

    I would also recommend you get the book Tim recommends. Also you have to make sure the .NET component you want to use can be installed in the Global Assembly Cache (GAC) because the SSIS framework requires it.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply