Welcome to Agile BI Community Sign in | Join | Help

November 2007 - Posts

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

BIDSHelper 1.2 Is Out

BIDSHelper 1.2 is now available at CodePlex . The new version has a number of SSIS specific features, like expression and configuration highlighting, a tool window that lists all the expressions in the package, and a Package Smart Diff tool. Darren (one Read More...
Posted Sunday, November 18, 2007 9:25 PM by jwelch | 0 Comments
Filed under: , ,

Changing Destination Tables With the OLE DB Destination

The OLE DB Destination supports using a variable to get the name of the target table. This allows you to switch the destination table dynamically, but there is a caveat. The columns in each table that you will use must match, or the OLE DB Destination Read More...
Posted Sunday, November 18, 2007 9:10 PM by jwelch | 0 Comments
Filed under: ,

Running Password Protected Packages

A recent post on the forums was asking about running packages programmatically. The poster's package was password protected, and when running the package, they were receiving a message that one of the connection managers was failing to connect. The code Read More...
Posted Friday, November 16, 2007 4:13 AM by jwelch | 0 Comments
Filed under: ,

SSIS Performance Webcast for the Charlotte SQL Server User Group

I'll be doing a web cast for the Charlotte SQL Server User Group , our local PASS chapter, on SSIS Performance Tuning on Nov. 28, 2007 at 12:00 EST. From the abstract: "This presentation will cover the various aspects of performance tuning in SQL Server Read More...
Posted Wednesday, November 14, 2007 7:36 PM by jwelch | 0 Comments
Filed under: ,

Dealing with Unicode and ASCII Text Files

A recent post on the MSDN forums brought up an interesting problem. The poster was attempting to process a folder of files, all of which had the same format, but some were encoded as ASCII (ANSI, DT_STR, or varchar, if you like the SQL Server data types) Read More...
Posted Thursday, November 08, 2007 10:06 PM by jwelch | 1 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: ,