Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SSIS 2008   (RSS)

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 | 0 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 | 1 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 | 5 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

Changes Coming for SSIS 2008

At the PASS Summit this week, I heard a few interesting bits about SSIS 2008 that should be in the next CTP. One, ADO.NET will be fully supported, with a ADO.NET Data Source (renamed from the Data Reader Data Source) and a ADO.NET Destination. Since ADO.NET Read More...
Posted Monday, September 24, 2007 1:06 AM by jwelch | 3 Comments
Filed under:

SQL Server 2008 - Using Merge From SSIS

In my last post, I talked about using the new MERGE statement in SQL Server 2008. It allows you to merge the data in a result set with a table, based on a join condition that you specify. This is a common scenario in data warehousing, where you often Read More...
Posted Thursday, July 05, 2007 4:18 AM by jwelch | 1 Comments