blogs.conchango.com

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: If IsNumeric(RetailPrice) = False Then     DTSDestination(''RetailPrice'') ...

Well it isn't likely to cause quite the same stir as Y2K but I thought it was a significant date for everyone's diaries... On the 8th April 2008 Microsoft withdraws mainstream support for SQL Server 2000. Look here if you don't believe me.  That's not very far away at all.  This gives everyone who is currently ...

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 would mean that the row would not get inserted into the destination. In SSIS, we talk of ...

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 contain multiple connection objects pointing to the same database if you had multiple ...

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 are a number of options for achieving this in SSIS. Namely: A derived column ...

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 package itself using the following line of code: Dim pkg = ...

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 do this they attempt it in the main data processing method of the component. ...

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 of a task. In SSIS it is possible to capture the number of rows ...

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 code), limited in its capabilities (it can really only operate on a row at a ...

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 ''feature'' it was actually fraught with complications as all DTS would do was ...