Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » Script   (RSS)

Calculating a Running Total Part 2

To finish up the topic that I started in my previous post , I wanted to post a more complex example of running total calculations. This is based off a request on the MSDN forums, for a running total calculation that would “slide” along as additional rows Read More...
Posted Thursday, June 12, 2008 1:18 AM by jwelch | 0 Comments
Filed under: , ,

Calculating a Running Total In SSIS

Running totals are a common calculation for reporting, and are occasionally needed in ETL processes to populate aggregate tables. One way to accomplish this in SSIS, if you are retrieving data from a relational database, is to do the running total in Read More...
Posted Monday, June 09, 2008 4:33 AM by jwelch | 1 Comments
Filed under: , ,

See if a File is Locked

A question that comes up occasionally on the forums is how to determine if a file is being written to by another process. It can cause issues if a file is partially written when a source component starts extracting data from it. There is a way to check Read More...
Posted Tuesday, May 13, 2008 2:41 AM by jwelch | 0 Comments
Filed under: ,

Renaming the Script Project in SSIS 2008

I found something interesting in SSIS 2008 today, and thought I'd share it. I was working with David Darden on a package that included a script task. In 2008, the Visual Studio Tools for Applications (VSTA) environment is used to edit script tasks. It Read More...
Posted Wednesday, April 30, 2008 11:51 PM by jwelch | 0 Comments
Filed under: ,

Sending an Alert if a Package Runs Too Long

A question that has come up in a few different situations recently is how to send someone an alert if your package is taking too long to execute. For example, you might have a package that loads a large number rows from a source system to a destination Read More...
Posted Sunday, April 20, 2008 11:54 PM by jwelch | 0 Comments
Filed under: ,

Importing Files Using SSIS

A topic that has come up a few times recently is the idea of loading a set of files into a database using SSIS. One of the data flow components in SSIS is the Import Column transform, which allows you to load files into a binary column. There is a great Read More...
Posted Saturday, February 02, 2008 8:27 PM by jwelch | 0 Comments
Filed under: ,

Checking for the Existence of a File

The File System Task in SSIS doesn't support checking to see if a file exists. You can work around this easily with a script task. Create a new script task and add a Imports statement referencing the System.IO namespace to the top of the script. Imports Read More...
Posted Thursday, November 01, 2007 4:32 AM by jwelch | 1 Comments
Filed under: ,

Address Columns Generically In a Script Component

When writing script components in SSIS, it's often useful to be able to process the columns without knowing exactly what they are. For example, you may want to loop through all the columns to check for a conditional, like NULL values in the columns. Or Read More...
Posted Sunday, October 21, 2007 4:59 AM by jwelch | 0 Comments
Filed under: , ,

Dynamically Pivoting Rows to Columns

Previously, I posted about dynamically un-pivoting columns to rows . In this post, we'll look at the reverse scenario. Suppose that you have a list of sales orders, in this format: Sales Order Number Product SO-001 Hammer SO-001 Table Saw SO-001 Cordless Read More...
Posted Friday, September 14, 2007 4:41 AM by jwelch | 3 Comments
Filed under: , ,

Using the WMI Data Reader in SSIS

A recent post on the MSDN forums was asking about using the WMI Data Reader Task to retrieve information and send it to a SQL Server destination. I wasn't very familiar with the task, so I decided to try it out. I wasn't expecting much, given some of Read More...
Posted Wednesday, September 05, 2007 3:42 AM by jwelch | 0 Comments
Filed under: , , ,