Browse by Tags

All Tags » programming (RSS)
Installing a new version of an SSIS custom component
Published 18 May 10 12:54 PM | dougbert
Recently a friend asked for help with the, uh, challenges of cleanly installing a new version or build of a custom component for SQL Server Integration Services (SSIS). Here are the steps: Close BIDS or Visual Studio. Uninstall the old version of the...
Filed under: , , ,
HTML Table Destination: An (incomplete) SSIS custom data flow component
Published 28 April 9 3:33 PM | dougbert
I had fun recently creating a custom data flow destination for Integration Services - an HTML Table Destination that writes out the data from the data flow to an HTML file as an HTML table. No applause, please - I copied SSIS developer Matt Masson's...
Filed under: ,
Setting the DataType of IDTSParameterBinding objects (Execute SQL Task)
Published 7 April 9 11:18 AM | dougbert
If you're writing Integration Services code that uses the Execute SQL task, you also have to create parameters programmatically. The ParameterBindings property of the ExecuteSQLTask returns an IDTSParameterBindings collection of IDTSParameterBinding...
Filed under: ,
Get looped, with your own custom Foreach Enumerator for SSIS
Published 27 March 9 1:35 PM | dougbert
The lack of control flow structures such as looping was one of the main shortcomings of Data Transformation Services (DTS). If you're nostalgic, just look at the scripting hoops that you had to jump through to loop, by disabling and re-enabling steps...
Filed under: ,
Adding a VSTA Script task programmatically (revised)
Published 24 May 8 8:55 AM | dougbert
[UPDATED WITH A BETTER CODE SAMPLE FOR THE 2ND SCENARIO TUE 6/10/08] The move in SQL Server 2008 Integration Services from VSA to VSTA for scripting doesn't just give us C# and a better IDE and Add Reference dialog. It has also made programmatic manipulation...
Filed under: , ,