asked on

SSIS Package error in Data Flow / Data Source

In the "Data Flow" of my DTSX Package, I'm getting the following error:
"The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_NUMERIC" and "DT_DBDATE". I changed the relevant column(s) datatype in the "Output Columns" in "Advanced Editor" under "Input and Output Properties", but to now avail. Please advise.

Thx

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Horn

Also, as a wild guess, make sure that you have your mapping correct, as mapping a number to a date could be a mistake.

Roberto Madro R.

ASKER

Almost there except I have one more error to over come at the Data Flow "Destination", I'm getting the following error:

"The column "Copy of myDate" can't be inserted because the conversion between types DT_Date and DT_DBTIMESTAMP"

Please advise.

SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roberto Madro R.

ASKER

Alright, we're in the clear, no errors, however, when I execute this package, it runs fine and it displays the number of records transferred, but when I check the table at the destination there's no data, weird.

Your thoughts please.

Roberto Madro R.

ASKER

That's the error behind the no-data in table;

Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (7) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Roberto Madro R.

ASKER

The combination if your feedback helped solve the error(s) I was experiencing, many thank, we're on track now.