Welcome to EMC Consulting Blogs

Browse by Tags

• configurations
• connection manager
• Dataflow Task
• Expressions
• Nugget
• RetainSameConnection
• SQL
• SQL Server
• SQL Server 2005
• SQL Server Integration Services
• SSIS

• SSIS: Checking for IsNumeric()

  Many ex-DTS users are miffed that the SSIS expression language does not have an equivalent of the VB Script IsNumeric() function that is used so extensively in DTS and to be honest, its a fair shout. The following code is very typical in DTS packages: Read More... Posted 03 May 2007 23:39 by jamie.thomson | 11 Comments Filed under: SQL Server Integration Services, SSIS, DTS, Nugget Attachment(s): Package.zip

• SSIS: But it used to work in DTS (11) - Skipping insertion of a row

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Skipping insertion of a row DTS allowed us to skip processing of a row by use of 'DTSTransformStat--SkipInsert' in an ActiveX Script. This Read More... Posted 15 January 2007 16:22 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, DTS, Dataflow Task

• SSIS: But it used to work in DTS (10) - Use multiple connection objects in order to maintain seperate connections to databases

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Use multiple connection objects in order to maintain seperate connections to a database It was commonly recommended in DTS that a package should Read More... Posted 21 December 2006 19:11 by jamie.thomson | 1 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server, SQL, SSIS, connection manager, RetainSameConnection, DTS

• SSIS: But it used to work in DTS (9) - Add a timestamp to the data in the data pump

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Add a timestamp to the data in the data pump This is a common requirement for auditing purposes. people need to know when a row was processed. There Read More... Posted 07 August 2006 08:26 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: But it used to work in DTS (8) - Get a reference, within a script, to the package using DTSGlobalVariables.Parent

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Get a reference, within a script, to the package using DTSGlobalVariables.Parent In DTS ActiveX scripting it was common to get a reference to the Read More... Posted 26 July 2006 15:53 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: But it used to work in DTS (7) - Capture a value from inside the data pump into a variable

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Capture a value from inside the data pump into a variable SSIS enables us to write a value to a variable using the script component. Often when people Read More... Posted 18 July 2006 12:30 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: But it used to work in DTS (6) - Capture number of rows with RowsComplete

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Capture number of rows with RowsComplete Easy one this. In DTS it was possible to capture the number of rows processed using the RowsComplete property Read More... Posted 11 July 2006 08:37 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: But it used to work in DTS (5) - Changing values in the pipeline

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Changing values in the pipeline Data transformation in DTS is done using ActiveX Script. Although being notoriously slow (ActiveX Script is uncompiled Read More... Posted 03 July 2006 18:37 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: But it used to work in DTS (4) - Implicitly Converting Between Data Types

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Implicitly converting between data types In DTS it was possible to implicitly cast values from one type to another. While this seemed like a useful Read More... Posted 30 June 2006 12:06 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, DTS

• SSIS: But it used to work in DTS (3) - Passing a parameter from a parent package to a child package

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Passing a parameter from a parent package to a child package In DTS, packages could execute other packages by use of the Execute Package Task. Values Read More... Posted 29 June 2006 13:14 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, DTS, configurations