dbTalk Databases Forums  

Issues importing flat file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Issues importing flat file in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JMM B
 
Posts: n/a

Default Issues importing flat file - 06-19-2006 , 06:53 AM






Hi,
How can I import/export the file below when the first and last columns
don't match the other ones? I've tried many different combination when
going through the DTS Wizard, but didn't work. For example, when
importing, I managed to define the columns according to the second row
below, but always get an error when running it. Or, when I ran it, the
table created in the database contained only some of the columns, but
not all of them...
Any help is welcome
Thanks a lot.

0000000000000000 00000000
4916110000500316BASIL DUNNE MR 19470614449
4916110005025822DANIELLE MCGEEHAN MISS 1982060980
4916110005025830PATRICIA CAHILL MRS 19510221
4916110005025848EAMON SWEENEY MR 19610623
4916110005025855THOMAS CONWAY MR 19690922
9999999999999999 00000000


*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.