Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
doran_doran
Posting Yak Master
179 Posts |
 Posted - 2008-10-02 : 22:40:11
|
| I have a very large text file that I can only download through a link. There are some dates with 0000-00-00 format and DTS fails when it sees this. I tried to replace these date using notepad but it takes for ever to do this. Here is the error I getError during Transformation 'DirectCopyXform' for row number 3802. Errors encountered so far in this task: 1TransformCopy "DirectCopyXform'conversion error Conversion invalid for datatypes on column pair 16(source column 'date'(DBTYPE_STR), destination column 'date'(DBTYPE_DBTIMESTAMP).What are my options? |
|
|
chwanhun
Starting Member
22 Posts |
Posted - 2008-10-03 : 09:49:13
|
| Change the datatype of your destination column to alphanumeric. If that works, you can then go back and format that field to a datetime datatype. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 10:15:18
|
| Or. just use a derived column task and using expression change value to 1900-01-01 if 0000-00-00 which is default date that sql server understands. then use this created column to map to your destination date column. |
|
|
|
|
|
|
Import text file with error when 0000-00-00