|
|
-
|
|
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....
|
|
-
|
|
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 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....
|
|
-
|
|
Just thought of sharing the actual results to show is it better to use Lookup or Merge Join....
|
|
-
|
|
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......
|
|
-
|
|
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. Scenario: There is a folder which contains a number of files. The file name follows the following naming convention . Alphanumeric could be an......
|
|
-
|
|
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 :......
|
|
-
|
|
Does this question ring some bells? Well you could win yourself an iPAD by taking the TSQL Quiz on Beyondrelational.com. So check how good are you in TSQL. Test yourself and get an opportunity to learn new stuff.
All the Best......
|
|