Forum Discussion
Data Type Inconsistencies
I am working with a client who was receiving an error message in SSIS saying that a field was not Unicode and needed to be for the destination. We went to SSMS and Object Explorer, and low and be...
You need to open the SSIS package for edit, and refresh data source/destination.
- The problem is in SSMS. If I use the designer I see 1 data type for ColA and if I open object explorer, I see a different data type for ColB. When I query the system views, I see the same data type as in designer, but SSIS sees the same data types as object explorer. The data sources and destinations have been refreshed and have the same results. I'm wondering if there is an OLE DB vs ADO difference or something.
The table is created within an SSIS Execute SQL Task with a SELECT INTO. I'm going to replace it with a CREATE TABLE to hopefully get rid of the problem, but I'd still like to know what I am seeing and why.- I'll suggest to use Visual Studio and open the package from there. then make sure it runs within VS and adjust data types if needed
Regards
Javier
