|
|
-
|
|
In SSIS Transactions, Not Supported does not always work the way we expect it to. Let us see what is the case and how do we overcome the scenario....
|
|
-
|
|
How to Split a single row coming in input file to multiple rows when number of columns are not fixed in the input file....
|
|
-
|
|
Just thought of sharing the actual results to show is it better to use Lookup or Merge Join....
|
|
-
|
|
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,
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......
|
|
-
|
|
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......
|
|
-
|
|
This post gives a brief description about each Enumerator available in SSIS. Will be explaining them in details one by one, taking examples to make it more clear....
|
|
-
|
|
Before answering this question let me tell you that whatever you do in SSIS or SQL server can be done in Script task.
So the question arises, why not do everything in Script task why learn so many tasks and transformations. If you are a developer you might like to do everything in a code for ......
|
|
-
|
|
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 ......
|
|
-
|
|
Scenario: You need to select files based on the uniqueness of a part of the file name. Lets say the format of the file is: XXXX_MMDDYYYY_garbage.csv Where XXXX is of 4 characters, MMDDYYYY is the date in the format MMDDYYYY, is any set of legal characters. In the INPUT folder we have files lik......
|
|