blogs.conchango.com

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

It is a very common scenario to be able to load two tables in the same data-flow that have a foreign key relationship between them. The question of how to do this gets raised very often on the SSIS forum so I figured I'd try and address it here. Basically, its not possible to do this without using a workaround. There are two possible workarounds ...

Did you know.... ...that you can run regular SQL Server transactions in SSIS over multiple tasks without requiring the use of Distributed Transaction Coordinator (DTC)? Well I didn't but thanks to that man again, Kirk Haselden, I do now. The default behaviour of a Connection Manager is that every task has its own connection which is why they ...

I got some smashing advice from a guy called Steve Kass today that I wanted to make sure I kept and remembered. I thought about the best place to store it and I thought, well why not right here on my blog. That way I won't forget it and maybe other people can benefit too. Thanks for your help ...