CODEWITHSUNDEEP
ssistype-conversion
Badr Erraji
Badr Erraji

Reputation: 237

how to fix CONVERSION errors after importing SSIS PROJECT

I'm importing a perfectly working SSIS project from TFS.

I have actually a problem with all the packages that contain a data FLOW with a date importation.

I get dozens of this error :

Validation error. DFT Get Date ODBC Source CodeDate2 [63]: The OLE DB provider used by the OLE DB adapter cannot convert between types "DT_BYTES" and "DT_DBDATE" for "Date".

and when I click on the odbc source editor, I have the following message:

the metadata of the following output columnsdoes not match the metadata of the external columns with which the output columns are associated:

Output "ODBC Source Output": "Date"

Do you want to replace the metadata of the output columns with the metadata of the external columns?

the fact is that works everywhere but on my computer.

is there an ole db provider component I'm lacking of something like that?

Upvotes: 1

Views: 3582

Answers (3)

Jaggana
Jaggana

Reputation: 580

Same here, I forced the type casting it in the select and it works :

SELECT
    [...]
    cast(release_date as datetime) as release_date,
    [...]
FROM cm_wo

Upvotes: 0

Daniel Gimenez
Daniel Gimenez

Reputation: 20599

Downgrading will work, but if that's not possible for you, then rewriting your queries may also solve your problem.

In my case I had a Postgres query returning columns of type date. I just converted them all to timestamptz using ::timestamptz. At that point the columns changed from DT_BYTES to DT_DBTIMESTAMP, which was just fine for my purposes.

Upvotes: 3

Yang.Z
Yang.Z

Reputation: 101

It might be related to the version of Visual Studio or SSDT.

Try to install SSDT 15.8.0(SSDT previous releases), and run the package in it.

I once saw similar posts on MSDN after the release of Visual Studio 15.9.2

Import from Teradata using ODBC gives VS_NEEDSNEWMETADATA error

ODBC Progress datatype problems after updating to VS 2017 15.9

Upvotes: 1

Related Questions