SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Import Tool does not properly delimit files		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SergioM
Yak Posting Veteran

72 Posts
Posted - 05/21/2012 :  12:06:24  Show Profile  Reply with Quote
I'm using the import export tool to import a tilde-delimited .AP file. This particular document has 60 columns. But for whatever reason, I can only map 9 columns. The ninth column then has all of them lumped together in one column. It does read the tildes (~), but it only uses them to delimit for part of the file. Then it just begins to read them literally. Is there something I can do?



P.S. The document is very large (over 125 MB!) so I can't really, manually alter the document (in excel or otherwise) prior to importing.
Edited by - SergioM on 05/21/2012 12:10:43

visakh16
Very Important crosS Applying yaK Herder

India
47189 Posts
Posted - 05/21/2012 :  16:51:02  Show Profile  Reply with Quote
so far as delimiter is proper it should correctly interpret it. B/w have you given any text qualifier?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

SergioM
Yak Posting Veteran

72 Posts
Posted - 05/21/2012 :  18:53:05  Show Profile  Reply with Quote
I don't understand the first sentence. Can you rephrase it? Also, I have not given it a text qualifier. Should I?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47189 Posts
Posted - 05/21/2012 :  19:00:06  Show Profile  Reply with Quote
quote:
Originally posted by SergioM

I don't understand the first sentence. Can you rephrase it? Also, I have not given it a text qualifier. Should I?

My question was is it actually only ~ character which seperates values. Are the entire values enclosed in some qualifier like ""

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts
Posted - 05/22/2012 :  06:27:57  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Try to reset your columns again.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

SergioM
Yak Posting Veteran

72 Posts
Posted - 05/24/2012 :  14:43:58  Show Profile  Reply with Quote
Resolved!

So, for whatever reason, it only wanted to map 9 columns. But if I go to the advanced settings of the wizard & click "new"; it does properly include a new column.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000