FSO needs a datatype in the Dim statement ...

matthew_charron (9/2/2009)

---

If you are using an execute sql task to dynamically create the source table then you could use that same statement in an execute sql task to create a...

I just had a thought about this - why not set up an Excel spreadsheet (or CSV file) and redirect any missing departments to that?

Then include the spreadsheet as an...

Just follow the link provided by CozyRoc and you will see what the trash destination is and how you use it.

I deliberately avoided that question, because I don't know the answer!

The necessary 'machinery' for dataflow failure is obviously in place (FailPackage..., FailParent, ForceExecution...) and maybe you can get at these...

Maybe you could do it this way - though it does require (in the case of no missing departments) two reads of the source data:

1) Data flow task 1 retrieves...

Erik Kutzler (9/1/2009)

---

A Derived Column or a Script Component would work fine.

You could also create a table in your database that stores these text values with a numeric id and...

Great, thanks for posting back.

It sounds like you are trying to create the output file meta data (ie, the column names and data types) dynamically, is that correct?

This isn't really how SSIS works -...

I imagine that this would evoke a better response if it were posted in the BI forum, as it's not really SSIS-related.

You have a sub called Button303_Click with no obvious means by which it will ever be executed - where did this code come from, a Windows Forms VB.NET project, perhaps?

You...

Based on the sample data and code, I cannot see why it would not work for you, as you appear to be doing the right things.

Or, as you are in...

John meant can't, not 'can'!

The Input0_ProcessInputRow sub is called for every row in the input data.

As long as the input data is in the required order, this allows the LastColA variable to be populated...

What is "@SSIS" supposed to represent in this expression?