Solved

Dts Showing wrrong field types in destination tab

Posted on 2011-09-17
7
264 Views
Last Modified: 2012-05-12
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
Comment
Question by:fordraiders
  • 3
  • 2
  • 2
7 Comments
 
LVL 22

Expert Comment

by:8080_Diver
Comment Utility
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
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
>>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
 
LVL 3

Author Comment

by:fordraiders
Comment Utility
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 up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
>>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
 
LVL 22

Accepted Solution

by:
8080_Diver earned 500 total points
Comment Utility
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
 
LVL 3

Author Comment

by:fordraiders
Comment Utility
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
 
LVL 3

Author Closing Comment

by:fordraiders
Comment Utility
I actually created a new table and then scripted from there.
Thanks
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now