dbTalk Databases Forums  

Importring files with non standard column numbers

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


Discuss Importring files with non standard column numbers in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ian Gorski
 
Posts: n/a

Default Importring files with non standard column numbers - 11-13-2003 , 12:33 AM






I'm trying to import a file that has rows with different
number of columns.
DTS fails when it encounters when it encounters one of
these rows.
How can I check the columns in the row and skip importing
the dud one before dts tries to import.

I'm choosing a subset of the columns using active x
scripting

ta

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.