February 13, 2012 at 7:56 am
Hi!
I have a very simple packge where I am unable to have correct Metadata on ADO.NET destination component in my data flow. It is connected to an ADO.NET source component wich is just fine and they are both using the same data source. :crazy:
Check attachments for details and thanks for the help
February 14, 2012 at 12:02 am
Do you have any error messages?
Try using the data conversion component to align metadata.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 14, 2012 at 6:50 am
I don't get any error message until I execute the package. Some dates are prior to 1753-01-01, so they need a datetime2 field in the database.
I discovered OLEDB destination component gets the correct metadata. So I've used this work around.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply