blogs.conchango.com

SSIS uses absolute paths to point to objects on the file system. What does that mean? In short it means that in order to point to a file I would have to use the full absolute path, I couldn't give a path that is relative to where the packages resides. A common complaint about SSIS is that it does not allow the use of relative paths. The most ...

There's some good news filtering into my inbox today about SQL Server bugs that have been fixed in the upcoming CTP (i.e. CTP6).Title: SSIS: Raw files throw an error at 4GB Description: It is not possible to load more than 4GB of data into a raw file. Status: Resolved (Fixed) Link: ...

Just like Andrea Merkel, Tottenham Hotspur and Britney Spears' career, the Lookup task in SSIS 2005 is in serious need of a makeover. Whilst it is one of the more useful components in the SSIS toolbox it has a number of shortcomings including: Inability to dynamically build the SQL statement that populates the cache when in 'Full Cache' mode ...

''Why the <insert your favourite expletive here> doesn't SSIS support C# for the script task and script component?''   I've heard the above complaint, in various different ways, many many times over the past 18 months since SQL Server 2005 was released. Its a valid complaint to which there is a valid answer (which I'm not going ...

Here's a useful page to keep an eye on: http://msdn2.microsoft.com/en-us/library/ms403408.aspx. It lists the current features within SSIS that will be disappearing in future versions and the strongest message I take from it is that you should upgrade your existing DTS packages from SSIS sooner rather than later. Currently it also makes ...

Since Kirk Haselden left the SSIS team his former colleagues have been conspicuous by their absence from the blogosphere. So good news, Matt Masson has joined the SSIS team and is blogging. His rss feed is here: http://blogs.msdn.com/mattm/rss.xml for those that like subscribing to these things. -Jamie  

A common question on the SSIS forum is "I'm a beginner to SSIS, where can I go to learn more". Alternatively, many people ask very specific questions about how to accomplish their objectives in SSIS and in many ways they are trying to run before they walk. Its important to grasp the basics before trying anything too demanding ...

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

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

For all you data integration pros out there, its worth bringing your attention toa site I've just come across - Connectionstrings.com. In short, it shows you how to build connection strings for many heterogeneous data sources when accessed using one of a multitude of middleware technologies. OK, so its not the most thrilling subject in the world ...