CLR and SSIS - Using .NET Assemblies In Your SSIS Packages - Video Series Video Category: Scripting and Using .NET Assemblies in SSIS Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 , Visual Studio 2005 , C# , Visual Basic This series of videos walks you through how to use a custom or third party assembly in SSIS. Highlights from this video series: Writing Script Tasks that use custom-made and third-party assemblies Writing Data Flow Tasks that use the Script Component Task Setting up Visual C# Express Edition (or Visual Basic Express Edition) Writing assemblies (class libraries) using C# and Visual Basic Configuring the host environment for using SSIS packages that contain custom assemblies Troubleshooting and problems updating assemblies Discussions of the Global Assembly Cache (the GAC) and it integrates with SSIS Calling .NET/CLR methods and assigning/retrieving properties and property values Datatyping and common type conversion errors and much more

Videos in this Series:

Title Skill Length Download Pt. 1 - Installing Visual Studio 2005 Express Editions   200 8 mins. Download Pt. 2 - Writing .NET Assemblies and an Overview of Assembly Use   300 13 mins. Download Pt. 3 - An Overview of Importing .NET Assemblies into SSIS   400 11 mins. Download Pt. 4 - Adding Custom Assemblies Correctly   400 16 mins. Download Pt. 5 - Adding Custom Assemblies to the GAC   400 12 mins. Download Pt. 6 - Using Custom Assemblies in the Script Component Task   400 14 mins. Download Pt. 7 - Versioning Assemblies and Redeploying For Use in SSIS Packages   500 19 mins. Download

< Return to list of all videos