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 |
|
devogrrrrl
Starting Member
1 Post |
 Posted - 2011-07-12 : 09:09:24
|
| I have been provided with a | (pipe) delimited .txt and need to import into SQL. One of the columns in the file holds a date in the format of '1/15/2011' and the column is a column type 'string [DT_STR]'. I am having issues importing it as a type 'Date'. Getting an error as follows:Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting column "tkc_partner_date" (54) to column "tkc_partner_date" (153). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". (SQL Server Import and Export Wizard)Any advice?Thanks! |
|
|
lightsql
Starting Member
17 Posts |
Posted - 2011-07-20 : 04:15:04
|
| Change the datatype of your date column from DT_STR to DT_DATE. Go to Flat File Connection Manager Editor > Advanced > and directly change the data type of the column to DT_DATE, you should have no need to convert the column then... let me know if it works for you |
 |
|
|
|
|
|
Import from Text File to SQL db and getting error