Two more solutions, again, neither of which I understand. If, in the CASE statement, I change the line: "WHEN ColumnValue IS NOT NULL THEN ColumnValue" to, lets say, "WHEN ColumnValue...

A bit of an ugly solution maybe, but would it be possible for you to use some sort of script task to open the SpreadsheetML file and then export it...

You have a few options:

Option 1: As Koen mentioned, use the Merge Join transform with multiple data sources, and make sure they are ordered correctly. Advantage: Simple to set up,...

This isn't really an SSIS question. But here's a solution for you anyway:

CREATE TABLE #TestTable1

(

ID INT,

ID1 VARCHAR(10),

State CHAR(2)

)

CREATE TABLE #TestTable2

(

ID1 VARCHAR(10),

[Name] VARCHAR(20),

State CHAR(2),

Address VARCHAR(20)

)

INSERT INTO #TestTable1 (ID, ID1, State)

VALUES (1,...

Ahh okay, that's what you meant. Alright, yeah I've done that before as well. Though interesting to see the performance gains that are mentioned in the thread on Jamie's site.

yeah definitely agreed Craig. Just posted that incase he's looking for something quick.

What's this synchronous script component you speak of? Is that something new in 2008?

Yeah putting in a script component and just using .NET's regex libraries would be pretty simple

A bit of an uglier solution, but if you want to avoid using a script component and writing a .NET script to do it, you could do something like:

FINDSTRING([string], "0",...

By new excel workbook, are you referring to a new tab in an existing excel file, or are you referring to a new excel file?

If it's the former, I don't...

It's pretty self-explanatory. The Script Transformation is attempting to access a variable which doesn't exist. Again, remember that it is case-sensitive. Look in your .NET code and make sure that...

My bad. The LEFT function doesn't exist in SSIS. Use SUBSTRING instead:

ISNULL(column) ? "NULL" : SUBSTRING((DT_WSTR, 30) column, 1, 11)

As for the first one, it should work. I tried it...

your source column is SMALLDATETIME, so you can't write the string "NULL" to it.

This expression:

ISNULL(column) ? "NULL" : column

has two data types it is attempting to evaluate to - a...

You don't need VB installed. Script components come with the built-in VB environment to program with.

As for your code, you have two problems.

First, in your Script Task, you're attempting to...

alright then, as a final suggestion from me, why not just get all the data and then do the WHERE clause as conditional transformations in your SSIS package?

Does the batch file require any sort of interaction? Maybe it doesn't close at the end of it, and you manually close it?

Make sure the batch file is not ending...