Just use a lookup from your source 'Item' data to retrieve the ID of the newly created Item and then use that to populate your ItemComments. No need for the...

If it's numeric, cast to integer, otherwise leave as is:

declare @value varchar(10)

Set @Value = '0000006708'

if IsNumeric(@value) = 1

select cast(@value as integer)

else

select @value

Phil

Not hard with a script component. Here's a snippet - assumes variables declared and strFilepath, strFilename have been set:

'Connect to the CSV file and...

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...