|
|
-
|
|
Many times during ETL we have a requirement where based on the file name we have to perform certain operations. Normally within a For Each Loop with File enumerator in Control Flow Task there is no direct way of doing this. If the file mask matches, well and good but nothing beyond that. I demonstra......
|
|
-
|
|
At times I have seen in SSIS forums people ask about the way they can know the number of records updated by a query or deleted by a query in an Execute SQL Task in control flow. Even I replied at times that its not possible(in a direct manner), until I read about the property ExecValueVariable. MSD......
|
|
-
|
|
Check out BIDS Helper.
A Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio (BIDS).
BIDS Helper.
......
|
|
-
|
|
In SSIS Data Flow Task (DFT) is the most used task as almost all the ETL is done in DFTs. Situation do arise when we need to use data between two or more DFTs. So how can this be achieved? Well there are a number of ways you can save you data in one DFT to so that you access the same data in another......
|
|
-
|
|
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.......
|
|
-
|
|
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......
|
|
-
|
|
In the SSIS Forum I often find people asking if it’s possible to send mail in HTML format or Fetch data from Table and use it in the mail body. In the Send Mail Task we can only send the mails in text format or send the query result as an attachment.
Today I will explain the way this can be......
|
|
-
|
|
I am uploading a few sample packages that you could use and modify as per your requirement. Let me know if you need any specific sample or any change in these packages.
SSIS - Script Component, Split single row to multiple rows
Scenario: We have a text file and we need to read each row and the......
|
|
-
|
|
One of the sore points of using Script component is assigning value to variables. Read Write variables can only be altered in Post Execute phase. Script Component runs the code for each record and this would affect performance adversely. For details check "Coding and Debugging the Script Compone......
|
|
-
|
|
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 ......
|
|