Yes. But I don't see anything written to error output file. I see only date time stamp modified with 1 KB size.

The SSIS package status is Successful but when I check the table no rows are inserted.

Thanks Phill.

Any suggestion what I should try now to resole this issue?

All.

Apologies for delay response.

Into SSIS the data type for these column is

text stream [DT_TEXT]

The below string I am retrieving sand inserting to database table.

AA1;20110809;AA55;1009.0000;C15;20110809;AA4;1010.0000;

Is this Unicode string? Please advise...

Did anybody have a solution for this?

Yes using CSV file can be a better.

Thanks for replying.

I used the below code into derived column expression but it says invalid expression, invlaid token. i replaced the getdate() with the column name i need to...

Actually that is the issue,i am not able to open package through Visial studio version.

I am getting mscoree.dll error. As you stated earlier looks like all the packages got corrupted.

Thanks for reply. I got similar to this but still not able to find how to find

Project Properties, Debugging and setting Run64BitRuntime to false

The below url explain the same...

Yes this is the only error.

Thank uou very much. I see that it was created in 2008.

One more issue i have that there are some packages which were running fine earlier but now i am...

could you tell me where to find Project Properties, Debugging and setting Run64BitRuntime to false.

I am getting the same error and also not able to open the SSIS package thruogh...

Yes i am running in 2005 environment.

But i need to confirm whether the package i am running is build using BIDS 2008, how i can find this?

That is great. It worked.

Thanks Nick for reply. The sql.ini file details helped me to create Sybase oledb connection.