Wouldn't this fail at the import stage, because SSIS would validate the number of fields...

Please show an actual example of the data in your flat file which shows how 'blank' and 'null' differ.

Can you use a T-SQL query for your source data? COALESCE would do the work for you very nicely.

I do not have the experience to argue either way - just thought I'd raise it as a point to be considered.

You would not use the Script Task to do...

wschampheleer (2/1/2010)

---

To find the min/max value(s) you can use a Multicast transform and feed one flow to an Aggregate Task.

Write the output to a temporary file (eg RAW).

Add a second...

Do you work for this company?

That was fun! 🙂

Use this as your derived column definition:

SUBSTRING([OpenDate],FINDSTRING([OpenDate],"/",2) + 1,4) + "-" + SUBSTRING([OpenDate],1,FINDSTRING([OpenDate],"/",1) - 1) + "-" + SUBSTRING([OpenDate],FINDSTRING([OpenDate],"/",1) + 1,FINDSTRING([OpenDate],"/",2) - FINDSTRING([OpenDate],"/",1) - 1) + SUBSTRING([OpenDate],LEN([OpenDate])...

It does feel like it is permissions related, but ...

..if it were, why would the Script Task work and the File System Task have problems?

I've also had problems doing this sort of thing in the past and ended up scripting it ... I know others have too (I've seen the forum posts) - this...

I think Lynn is correct: export the package out into the file system and then open it in BIDS to see what the steps are doing ...

By the way, I...

Yes

Is there a delimiter (eg "") around company name? Or is it just

Field1, co, name, here, field2

Field1, another company name here, field3

?

If there is no field delimiter, you are...

Provide some sample data please.

You could have a look here and see where the links take you.

Correct,