March 20, 2017 at 7:35 am
Hello I Have a package where it loads data from source to destination.
Source is using a sql command where the columns are getting from view. In that view both From and To date columns are date, null.
In the destination there is a table created where those to columns date, null
When I run the package- I receive a conversion error that these columns needs to be updated.(that's because in the destination when I view show advanced editor - OLEDB Destination Input- In the Input columns showing from and to date s DTDBDate and External columns - From ad to date as Unicode (DT_WSTR) ; Not sure in the table I kept as date, null but why still in the package its showing as Unicode? I tried to update this columns and save it but again its coming to Unicode.
Any solution?
March 20, 2017 at 7:51 am
Add a data conversion (or a derived column) task to convert from the data type of your input file to the data type you want for your output file. Change the new column to something like dtmFromDate and dtmToDate and use those new columns in your data flow to write out to your destination table.
I hope that helps,
Rob
March 21, 2017 at 8:23 am
This is what I have in the package -
In OLEDB Source Output
External columns
From and Todate both are - DT_DBDate
In the Outputcolumns
From and Todate both are - DT_DBDate
In OLEDB Destination Input
External columns
From and Todate both are - Unicode(DT_WSTR)
In the Input Columns
From and Todate both are - DT_DBDate
Where exactly you are asking me to change?
In the destination table the data type for these two columns as date,null.
Not sure why this is showing as Unicode.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply