blogs.conchango.com

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. ...

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 ...