blogs.conchango.com

I was looking over a package today that a colleague had built and it contained the following code in a Script Task that was being used to return today’s day name: Public Sub Main() ' Dim sWeekday As String sWeekday = Now().DayOfWeek.ToString Dts.Variables( Read More...

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

Its possible that at some point when building SSIS packages that you will want to initialise a variable with some value at execution time and the most obvious way of doing this is to use a script task. That code would look something like the following: Read More...

I just received an email from Michael Groh who had a warning about using SQL Server configurations in SSIS and he suggested I post about it on my blog which I'm more than happy to do. Here's what Michael had to say:   We finally tracked down a really Read More...

Whilst reading SQL Tip, Compiling Your SQL Without Running It to See If It Would Run (which, I believe, is written by Denis Gobo) I was reminded of an oft forgotten feature within SSIS. It is possible to validate that your package will execute without Read More...

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

That’s what I twittered recently upon first opening up Release Candidate 0 of SQL Server 2008 . You may remember that back in March of this year I told you about a new feature that would be appearing in a future CTP; namely that a container would provide Read More...