Welcome to EMC Consulting Blogs

I have been having an email back-and-forth with Jon Jaques which began with us discussing various limitations regarding BLOB support within the OLE DB Command and ended with Jon’s blog entry SSIS and the Perils of Embedded SQL where he discusses the drawbacks of the Execute SQL Task – namely that the Execute SQL Task has no understanding of the ...

Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing has completed: A) Check to see whether there has been any data that could not be ...

An interesting problem has been posed on the SSIS forum at SQL Server Central. The user wants to download a file containing stock information from Yahoo finance and import the data into a database table.   That sounded like an interesting problem so I took up the challenge. The basis of my solution uses the code that Ashvini ...

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