What do you want to do in those cases where the date is invalid? Error? Import the record with a null date?

You want to execute a query that returns a resultset and iterate around that? Can you provide more detail about what you are trying to achieve?

Excellent! Good to hear.

Phil

Now I see what you're asking.

Well - you could create pack3.dtsx and in it create two linked 'Execute Package' tasks which execute Pack1 and then Pack2.

Or ... you could go...

I think people misunderstood your first post a little - you suggested that there could be varying numbers of fields on each record. To accommodate that scenario, scripting would be...

SSIS will eat that up, no problem - that is standard CSV format. The fact that many of the source fields are NULL just needs to be accommodated as part...

Michael gave you the answer. Change your destination component to be SQL Server, not OLEDB, and the option is there.

Phil

If you do not know what created the DBF files, try using the built-in DBase driver.

If that does not work, try using FoxPro. As Greg said, you might have to...

Set DelayValidation = True on the bit that does the import.

Surely your error is 'Source Not Found' rather than 'Destination Not Found'?

Phil

Yuk - so how do you know what the data is in each field? Or is it just that there may be some missing fields at the end of the...

CSV files are, by nature, not fixed length. Do you mean CSV files which have varying numbers of records on each line?

Phil

Jack's idea is a good one and can, of course, be accomplished in a single package using an initial script task to check the number of columns with a conditional...

Sounds like the SQL Agent service may be running with credentials which do not allow it to access the file. Is it on a network folder somewhere?

No - this error was driving me so mental with irritation that I had to give up before I snapped!

I now use traditional copy/paste methods to get the job done...

Create a Boolean variable IsWeds.

Create a script task containing some code like this.

Public Sub Main()

Try

Dts.Variables("IsWeds").Value = False

...