blogs.conchango.com

Many people like to use stored procedures as the source of data for the SSIS pipeline. In theory there is nothing wrong with that however it does have its complications. Depending on the way the stored procedure is written, it may or may not be suitable to be used in this way. Namely, it is possible to preview the data being returned from a stored ...

There have been a few posts on the SSIS MSDN Forum asking how one can create and use SQL Server temporary tables within SSIS packages.   Temporary tables are tables that are created within a session and live for the life of that session or until all sessions using it have ended. They are denoted by either having a hash (e.g. ...

Anyone who has used a software tool will tell you that its impossible to know that tool inside out after just a few dys of using it and of course SSIS is no different. As you get to use SSIS then your knowledge improves and achieving your SSIS goals becomes alot easier. However, attaining that level of knowledge is not ...

Just a short note to tell you about a webcast that is coming up on 25th October 2006. "How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services" The subject matter will be (it says 'ere): This Support WebCast provides an overview of how to effectively configure data flow sources such ...

The OLE DB Source component allows a number of methods for extracting data from an OLE DB Source. The two most obvious are: 1) Write a SQL statement to extract data 2) Select a required table from a drop down box. I have previously recommended that using a SQL statement is the preferred option because selecting from the drop down box of tables ...

Peter (sorry, don't know your surname) made a very good comment here: http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2895.aspx#2903 that data-flows in a ForEach loop carry out repeated SELECTs against a data source and it would be good to be able to cache that data rather than executing the same query over and over. Its a great ...

I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis ...

I reckon that one of the most commonly used components in SSIS is the OLE DB Source component. This is the one that you use to pick up data from an OLE DB compliant data source (e.g. a database) in order to use that data in your pipeline. This is done with a SQL statement. One of the more common usage scenarios is to dynamically ...

Most of the stuff I put up here is to share knowledge around a bit but every so often I use it as a dumping ground for little titbits that I don't want to forget in the future. This is one such occasion. I've been trying to access data in Oracle from SSIS via OLE DB and was getting the following warning: ''Cannot retrieve the column code page ...