Can't you use the Nothing keyword from VBA to set the column value to null?

Or, why don't you use a derived column to set the column values to null?

90% of the time that a SSIS package works in BIDS but it doesn't in a SQL Server job, it has something to do with permissions. So make sure that...

I was thinking about event handlers to solve your problem, but these darn things also just go to the depth of a single task.

Well, in your original question, you asked for the name of...

I think the easiest way to do this is in the DSV. Create a new column with a simple CASE statement.

On a first guess I would say ... No.

But why don't you process the cube to find out?

Try the following variable in your expression:

@[System::TaskName]

What is the data type of the output column in SSIS? When I look at your query, it should be DT_STR or DT_WSTR with a length of at least 10...

You can write a SQL query to read from the Excel source, but it doesn't support all the language syntax.

So, I would just read the contents of the file and...

Nice article. Although I would have used a temp/staging table to store my updates, instead of using the OLE DB Command. That way you can use a set based update...

You can start from your current format and with the use of string functions you can manipulate the string until it becomes your desired format.

But I think converting the datetime...

jvanderberg (6/4/2010)

---

The Kimball method is great (and it's probably what most of us use), but it's general purpose and system independant. SQL Server has been optimized to the point...

:ermm:

Nice question. Learned something about HAVING.

I think the problem lies in the fact that you can't configure an Excel Source dynamically.

Each time that you change the sheet name, the metadata changes and SSIS can't handle...