Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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
0
Fordraiders
Asked:
Fordraiders
  • 3
  • 2
  • 2
1 Solution
 
8080_DiverCommented:
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.
0
 
Anthony PerkinsCommented:
>>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.
0
 
FordraidersAuthor Commented:
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
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Anthony PerkinsCommented:
>>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.
0
 
8080_DiverCommented:
In an effort to satisfy any thoughts that you may be looking at the wrong table,could you please script the table (I am guesing that it would be CRS_CPIR_MASTER based upon your connection name) using Management Studio and as a CREATE?

0
 
FordraidersAuthor Commented:
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
0
 
FordraidersAuthor Commented:
I actually created a new table and then scripted from there.
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now