Read on to know when you need to use Script Task or Script Component.
Sep 25, 2011
Jun 9, 2011
Jun 3, 2011
Test your SSIS knowledge by solving this scenario. Gain a chance to win goodies and know SSIS..
May 10, 2011
I got a very interesting scenario in Ask Sudeep section of BeyondRelational.com. Let me share the scenario first and then will explain how to go about it.
There is a folder which contains a number of files. The file name follows the following naming convention
List of files in the folder:
There can be 2 sets of files based on the alphanumeric part once with a and the other with b. From the above list we need to process just the following files:
As there is a break in the sequence for the file group “a” as a.3 is missing and similarly b.12 is missing so no files with larger numeric part will be processed.
Mar 9, 2011
Today I got a query asking me if we can have a script component which reads data from a text file which is supposed to have 5 input columns. However the data that they receive has at time extra columns or less columns for certain records. So the question arises how do we go about this.
There are 3 ways that come to my mind straight away.
- Script Component
- Flat file source which reads all data into one column and then splits them based on index of the comma in a derived column
- Flat file source with delimited settings to read just 5 columns.