Browse by Tags

• converting DTS
• DTS conversion
• DTS to SSIS conversion
• Running DTS in SSIS
• script component variable
• SQL Server 2008 Integration Services
• SQL Server Integration Services
• SSIS
• SSIS conversion
• SSIS transactions
• ssis variable in script component
• ssis variables

• SSIS variables in Data Flow Script Component in Milwaukee

  While at a client in Milwaukee, I came upon an interesting problem on how to access a user-defined variable in a Script Component in the Data Flow. There are actually two ways to solve this problem. One technique is to place a Derived Column before the... Posted Sep 13 2008, 08:03 AM by Darren Herbold with | with no comments Filed under: SQL Server Integration Services, SSIS, SSIS transactions, SQL Server 2008 Integration Services, SSIS business rules, script component variable, ssis variable in script component, ssis variables

• Why SSIS over DTS?

  Why SSIS over DTS? · Running DTS in SQL 05 (using SSIS) only provides a “wrapper” to the DTS package. The package will not take advantage of the performance gains that SSIS has to offer. · Clients that are using DTS to move data into a data warehouse... Posted May 14 2008, 03:39 PM by Darren Herbold with | with no comments Filed under: DTS conversion, converting DTS, DTS to SSIS conversion, SSIS conversion, SSIS business rules, Running DTS in SSIS