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
Roberto Madro R.Programmer AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
For starters, if you need to do any data type conversions this should be done in an Derived Column task, not by mapping a column of one data type to a column of a different data type.

Also, the ability to do the Derived Column task is dependant on all of the columns in the source being convert-able to the data type in the destination.  For example, the string 'banana' can't be converted to a number.  So in this case, the numeric value needs to be convertable to a date.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Also, as a wild guess, make sure that you have your mapping correct, as mapping a number to a date could be a mistake.
0
Roberto Madro R.Programmer AnalystAuthor Commented:
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.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Hmm.  Haven't dealt with that one before.   Perhaps a data converstion task to add a new column, converted to DT_DATETIME format, then map that column to your destination DT_DBTIMESTAMP?
0
Roberto Madro R.Programmer AnalystAuthor Commented:
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.
0
Roberto Madro R.Programmer AnalystAuthor Commented:
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.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In the Package tab, scroll to the bottom, then scroll up until you se the message in the above comment, the scroll up more until you see the first error message.

As you are experiencing, SSIS error messages are NOT abundantly developer-friendly.

Since I can't connect to your source of data, my ability to troubleshoot this will be limited.
0
Roberto Madro R.Programmer AnalystAuthor Commented:
The combination if your feedback helped solve the error(s) I was experiencing, many thank, we're on track now.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.