Similar articles
DotNetShoutout - Latest published stories
Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script Task to read contents of a flat file into a variable.
DotNetShoutout - Latest published stories
SSIS 2008 Flat File Source Issue
Ok, this might be my last post for this year, 2009. This is more of a note to myself than a blog post. Anyway, I want to document the issue that I have encountered and the solution that I have found t...
DotNetShoutout - Latest published stories
Script Component–Source Part1 - Sudeep's Domain
SSIS scenarios... One of the most advance feature of SSIS is Script design capability provided be it Script Task in Control Flow or Script Component in Data Flow Task. I have seen people use the Scrip...
DotNetShoutout - Latest published stories
SQL to XML with SSIS
Have you ever had a vendor ask for XML instead of a quick CSV file? Well, if you’re using MSSQL 2005 or 2008, I’m sure you realized just how awesome they are when this request came through. I’m going ...