asked on

Dts Showing wrrong field types in destination tab

sql server 2008 r2

I'm trying to import a text file into a table and during the destination tab.
The destination field types are wrong. as shown in the pic below.

I have double checked the table in sql server and the fields in question are (nvarchar)
but they keep showing up as date/time field types ? or some other field type..??

any help ?

Thanks
fordraiders
example-dts.png

8080_Diver

Look at the data that you are importing. Is it possible that the source data looks like a Time datatype? Try taking a couple of rows from the source data and putting quotes around the columns in question.

Anthony Perkins

>>I have double checked the table in sql server and the fields in question are (nvarchar)<<
I suspect you are not looking at the right table or you have not selected the right table in your drop down box in the Transformation task.

Fordraiders

ASKER

ac, It is the right table. double checked.

I belive it is somewhere in the text file itself and will double check on that and get back

Anthony Perkins

>>I belive it is somewhere in the text file itself and will double check on that and get <<
It can't be. You are showing the Destination table. This has nothing to do with the text file.

ASKER CERTIFIED SOLUTION

8080_Diver

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Fordraiders

ASKER

The text file is pipe delimited...I found Pipes in the text file itself. So sql server thinks its creating a new column and bombs out

Fordraiders

ASKER

I actually created a new table and then scripted from there.
Thanks