|
|
-
|
|
A lot of time people ask me if there is a way to read object variable in Script task. It comes in handy when you wish to work on the results of an Execute SQL query. Generally object variables are used along with Foreach Loop. However cases arise where you would like to read them separately. So how ......
|
|
-
|
|
Hi,
In the SSIS forum very often there are questions on dynamic name for a flat file connection manager
I have split it in two parts:
A single file name needs to be set up dynamically
Multiple file names need to be set up dynamically per execution.
<p class="M......
|
|
-
|
|
For a long time I was planning to write on this topic. So here I am. I take a example of reading XML file in Script component as source. I am using XML Document to read the XML file in my case. In case your file size is huge I would recommend you use XML Reader. I find XML Document simpler to code :......
|
|
-
|
|
Hi, Lets talks about EXPRESSIONS. It is one of the most interesting and used feature available in SSIS. At times we tend to over do in out attempt to work using Expressions. One needs to decide when it is best to use an expression. A few po......
|
|
-
|
|
Scenario: How to delete files created a number of days before today. The files will have the date appended to the file name and we will not check the file properties to decide the file age. The file name would follow the naming convention: File_mmddyyyy.txt
This can be achieved very easily in SSIS.......
|
|
-
|
|
How to set the file name dynamically for multiple files
kept in a folder or different folder.
Point to note that all the files have the
same metadata.
Scenario:
For simplicity sake I will be using ......
|
|
-
|
|
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......
|
|
-
|
|
How to Split a single row coming in input file to multiple rows when number of columns are not fixed in the input file....
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|