Solved

Dts Showing wrrong field types in destination tab

Posted on 2011-09-17
7
307 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 22

Expert Comment

by:8080_Diver
ID: 36556473
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
ID: 36556785
>>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
ID: 36557682
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36557705
>>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
ID: 36559532
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
ID: 36567088
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
ID: 36578618
I actually created a new table and then scripted from there.
Thanks
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

707 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