It is really strange,because everything finishes successfully if I run the package from

SSMS/Integration Services under msdb.

It fails only when I run the job. But I need to run this job...

HI,

Yes there is a dsn created for that name in the ODBC DATA Source Administrator and the name of the driver there is Client Access ODBC Driver(32 bit) ...

If I used DT_WSTR then it said it couldn't convert non-unicode to unicode string data.

It failed also if I used varchar.

But then I tried from the SSMS using .Net Framework...

Thank you very much for answering!

So, I was not very sure how to see the CCSID of the column but I saw in the properties of the emulator somewhere where...

I am really stucked with this problem. I need to schedule also this task, but scheduling is available only from SSMS and not from SSBIDS. When I import the...

First of all thank you very much for helping me.

I did as you told me for the flat file and in fact there were 55 rows with problems, 54 of...

It's really strange but it suceeds only if I configure the error output to ignore failure.

Very strange. Neither cast to character solves it. I hope it hasn't have anything wrong...

Hi again!

I am from Albania. In fact I have done some tries and I have come in the conclusion that it hasn't have to do with any special character of...

Thanks for helping!

I am using "IBM DB2 UDB for iSeries IBMDA400 OLE DB provider"

Everything goes ok for most of the tables. I am facing this problem only in some tables

As...