Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SSIS 2008   (RSS)

Passing an Object from a Parent Package To a Child

Occasionally, you may run into the need to pass values between packages. In most cases, you can use a Parent Package Variable configuration to pass the value of a variable in the calling (or parent) package to the called (or child) package. However, Parent Read More...
Posted Saturday, October 03, 2009 9:19 PM by jwelch | 4 Comments

SSIS and SQL Azure – Getting Started

Since SQL Azure is currently in a Community Technology Preview, the technology and this information provided below is subject to change. This post is based on the August 18th CTP. Now that I’ve been working with SSIS against Azure for a few days, I thought Read More...
Posted Tuesday, August 25, 2009 10:44 PM by jwelch | 2 Comments
Filed under: ,

Warning about Using String Variables in Derived Column Expressions

I ran across an interesting behavior in SSIS this week, and thought it was worth sharing. Occasionally, I’ll have the need to use the value of a variable (set in the control flow) in the data flow. The typical way to accomplish this is to use a Derived Read More...
Posted Sunday, June 28, 2009 11:14 PM by jwelch | 0 Comments
Filed under: , ,

Creating Multiple Rows in a Text File from a Single Row

A recent post on the SSIS forums was asking about creating multiple rows in a text output file from a single row in the data flow. Given a set of rows like this: John Smith 1/1/1900 Value A Jane Smith 12/1/1900 Value B the poster wanted this output in Read More...
Posted Wednesday, May 20, 2009 4:45 AM by jwelch | 0 Comments
Filed under: ,

Code Snippets for SSIS 2008

If you develop in Visual Studio using C# or VB, then you are probably familiar with code snippets. They are little chunks of code that you can insert into your application and save you some typing. For example, if you are writing a C# application, and Read More...
Posted Tuesday, February 03, 2009 12:47 AM by jwelch | 3 Comments
Filed under: ,

What’s Happening on SQL Server When My Package Fails?

We encountered an issue recently in an ETL process during the extract portion. When extracting from one very large table, using a NOLOCK hint, we were encountering errors indicating that the data was changing while we were extracting it. Since no other Read More...
Posted Friday, January 30, 2009 3:32 AM by jwelch | 2 Comments

Batch Destination and the Merge Destination

After I created the Batch Destination for my presentation at the MS BI Conference, I was talking with Matt Masson, who let me know that they’d been working on a MERGE Destination sample component, and would hopefully be releasing it soon. It’s out now Read More...
Posted Friday, November 07, 2008 10:14 PM by jwelch | 1 Comments

Error Redirection with the OLE DB Destination

A question that comes up occasionally is how to handle errors that occur on the OLE DB Destination in the data flow. Errors that occur when using the OLE DB Destination to insert into a table are usually caused by primary key, foreign key, or check constraints Read More...
Posted Friday, September 05, 2008 8:43 AM by jwelch | 2 Comments

Configuration Changes in SSIS 2008

In a previous post, I detailed some of the challenges that I had encountered when trying to modify the connection string used for SQL Server configurations from the command line. In SSIS 2005, command line options were applied after the configurations Read More...
Posted Friday, June 20, 2008 10:36 PM by jwelch | 0 Comments

SSIS 2008 - Incrementally Updating the Lookup Cache File

There are a number of new features in the 2008 Lookup Transform. Jamie Thomson posted a good overview of the features , and I recommend reading it prior to this article. One of the new features in SSIS 2008 is the ability to cache the data from the Lookup Read More...
Posted Tuesday, May 06, 2008 11:53 PM by jwelch | 3 Comments
Filed under: ,

Setting the Lookup Query With an Expression

In SSIS 2005, one of the challenges with the Lookup transform was that the SQL used to populate the cache was fixed at design time. You could dynamically pass in parameters to the SQL, but only if you turned on the advanced caching options, which puts Read More...
Posted Monday, May 05, 2008 11:12 PM by jwelch | 1 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: ,

RetainSameConnection and Expressions

I ran across a forum post today that highlighted a limitation with connection managers that I wasn't aware of, so I thought I'd post it here. If you have RetainSameConnection set to TRUE, and you are also trying to update the connection string through Read More...
Posted Friday, March 28, 2008 1:20 AM by jwelch | 0 Comments
Filed under: , ,

Using the Data Profiling Task To Profile All the Tables in a Database

SQL Server 2008 introduces a new task that allows you to profile the data in a table. Jamie Thomson has a great series of posts about the different profiling options available on the task. If you are not already familiar with the task, I highly recommend Read More...
Posted Tuesday, March 11, 2008 5:01 AM by jwelch | 10 Comments

The November CTP for SQL Server 2008 Is Out!

The download link is here: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en Evidently there have been some issues getting it on the Connect site, so they are hosting it in Microsoft's Download Read More...
Posted Monday, November 19, 2007 6:45 PM by jwelch | 0 Comments
More Posts Next page »