DTSTransform Copy: Schema Validation failed for DAte /TIme Stamp -
05-02-2006
, 10:17 PM
Hi...
I am new to SQL server and creating a DTS apckage to extract data
depending on a particualr date column in the database The date is in Unix
date tim e format. In my SQL query i ahve the conversion like
dateadd(ss,( AHD.issue.open_date-14400), '19700101') as open_date.
wheer open_date is the column in the database. I am getting the error when i
execute the package. the open_date field is stored as a double in the
original table
Please somebody help..urgetn...
Thanks
Banu |