This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below. The code creates the package, configures the task, and components, then saves the… Continue reading Creating packages in code – OLE-DB Source to Flat File File Destination
Author: Darren Green
Creating packages in code – OLE-DB Source to Raw File Destination
This code sample programmatically creates a package with an OLE-DB Source and a Raw File Destination, and the resulting package exports data from SQL Server to a raw file. The finished package just has the one Data Flow Task shown below. The code creates the package, configures the task, and components, then saves the… Continue reading Creating packages in code – OLE-DB Source to Raw File Destination
CreationName for SSIS 2005 and adding components programmatically
If you are building SSIS 2005 packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post. See also CreationName for SSS 2008. We start with a very simple… Continue reading CreationName for SSIS 2005 and adding components programmatically
More Value From Data Using Data Mining Presentation
Here is a presentation I gave at the SQLBits conference in September which was recorded by Microsoft. Usually I speak about SSIS but on this particular event I thought people would like to hear something different from me. Microsoft are making a big play for making Data Mining more accessible to everyone and not just… Continue reading More Value From Data Using Data Mining Presentation
Escaping In Expressions
The expressions language is a C style syntax, so you may need to escape certain characters, for example: "C:\FolderPath\" + @VariableName Should be "C:\\FolderPath\\" + @VariableName Another use of the escape sequence allows you to specify character codes, like this \xNNNN, where NNNN is the Unicode character code that you want. For example the following… Continue reading Escaping In Expressions
Redistribute SSIS
The DTS component of SQL Server 2000 was a redistributable client component. This mean anyone with a SQL Server Client Access Licence (CAL) could not only connect to SQL Server in the normal manner, but that could also run DTS packages on their machine. Since DTS and SSIS have no client server, or remote execution… Continue reading Redistribute SSIS
Disabling tasks through Expressions
All Containers include a Disable property. This is what is used for the right-click Disable/Enable functionality you may have used when developing packages in the designer. Expressions are evaluated at run-time and can be used to set properties, so it follows that you could use an expression on the Disable property to control execution of… Continue reading Disabling tasks through Expressions
Expressions
Data Flow Property Expressions Property expressions within the data flow are not immediately obvious. Whilst most pipeline or data flow components do support them for their properties, the expression is not generally exposed through the component user interface, neither is the Expressions property shown properties grid for the component. Property expressions are only available at… Continue reading Expressions
Expression Date Functions
Date Parts Expressions support a range of date related functions such as DATEADD, with the same basic syntax to that found in T-SQL. Whilst the familiarity is very helpful, the difference that catches me out is the format of date part which must be quoted. T-SQL allows this: DATEADD(n, -10, GETDATE()) DATEADD(mi, -10, GETDATE()) DATEADD(minute,… Continue reading Expression Date Functions
Extending SSIS with custom Data Flow components (Presentation)
Download the slides and sample code from my Extending SSIS with custom Data Flow components presentation, first presented at the SQLBits II (The SQL) Community Conference. Abstract Get some real-world insights into developing data flow components for SSIS. This starts with an introduction to the data flow pipeline engine, and explains the real differences between… Continue reading Extending SSIS with custom Data Flow components (Presentation)