Hi,

you could use a scripttask which checks the state of your input file, and if its locked waits for e.g. 1 second.

To prevent the package from running into a...

Hi,

actually using SSIS dataflow with option fast load does a bulk insert.

Regards,

Jan

I had some data loss by using fast load. Rows had been imported but did only contain NULL values.

My workaround was to limit the maximum commit size to 100k...

Hi,

we are using COLLATE in expressions only if we can not change the collation as this seems to be very slow... I think you should keep that in mind.

Regards,

Jan

Hi,

it seems that this error only occurs by converting datetime columns into a style which contains spaces. Using 126 as style (also tried 101 - 105) works fine, while using...

Hi Matt,

thanks for that hint, it seems that I'm getting this error if one of the used columns is datetime, although it is converted into nvarchar.

I'll try to find an...