blogs.conchango.com

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

Very short blog post this one. A guy on the SSIS Forum recently wanted to add a new GUID into the pipeline and was pertubed that there was no equivalent of T-SQL's NEWID() function in the SSIS Expression Language with which to do it. I agree that there SHOULD be a function to do it and I hope that one will one day appear. In ...

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

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