|
|
-
|
|
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.
Input:
Col1......
|
|
-
|
|
While doing ETL performance is of utmost importance. Keeping this is mind how do we load data to Oracle server using SSIS in the most optimum way? We can follow the conventional method of using OLEDB Destination in a Data Flow Task. This is what is used most often. I too used this to perform ETL. Bu......
|
|
-
|
|
Coming back to Script Component.
Scenario:
We have a text file and we need to read each row and the output would have multiple rows per row in the input file.
Input File:
"201001","1;3"
"201002","1;2;3;4"
Expected output:
2010-01-01 01
2010-01-03 03
2010-02-01 01
2010-02-02 02
2010-02-0......
|
|
-
|
|
Scenario: How to extract the file name from a file path where the number of sub folders or name of folder is not fixed. In simple terms you do not know the position where the file name starts.
Typical example: You have a foreach loop set to traverse sub folders and you set the retrieve file name to......
|
|
-
|
|
How do we use Script Component as the source making use of ADO.NET connection that has been added to the package.
Below is the code which can be used for the same.
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
using Microsoft.SqlServer.Dts.Runtime.Wrapper;
us......
|
|
-
|
|
In the SSIS Forum I came across the following query and thought of writing a post on the same.
“Can anyone give guidance on how to set the mask for a Foreach File Enumerator programmatically? I have a DB that has a list of masks. I am retrieving that into an ADO recordset. For each record I r......
|
|
-
|
|
In most ETL we use Foreach loop to iterate through each file in a folder or records fetched from a table. Now the question arises how do we use Foreach loop based on each record in a text file.
Scenario: We have a text file having 2 columns, one containing source file relative path and 2nd column h......
|
|
-
|
|
So keeping my focus on SSIS Script Component as Source I show another example. Mostly Script component is needed when source is Flat file and we need to retain the previous record value(s) to be used in the next record(s). Keeping this in mind I present the scenario:
<p align="justify" class="Ms......
|
|
-
|
|
This is an old debate and yet not resolved. To use Script Component or Derived Column Transformation?? Yes Derived Column Transformation can NOT do all that can be done in Script Component. Advantages of Script Component: Code is more readable Easy to maintain and debug. Can achieve a l......
|
|
-
|
|
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 Script task pretty often but avoid Script Component because of various reasons. Earlier I had shown how to set up user v......
|
|