dbTalk Databases Forums  

SSIS Flat File Connection

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


Discuss SSIS Flat File Connection in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jay Abbott
 
Posts: n/a

Default SSIS Flat File Connection - 06-02-2006 , 11:44 AM






Is there a way to enter the columns of a flat file without using the GUI? It
is easy for me to format a list of column names and column widths that I
could copy and paste, but the only way I see to input file parameters is via
the GUI. In the old DTS you could edit the connection object and copy and
paste a list of column widths, now it looks like I can't do that.

Any body found a better way?

Thanks,

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: SSIS Flat File Connection - 06-04-2006 , 05:27 PM






Hello Jay,

The only way I can think you could do this is to edit the XML. I trust you
mean that you do not want to use the UI at all?

Allan

Quote:
Is there a way to enter the columns of a flat file without using the
GUI? It is easy for me to format a list of column names and column
widths that I could copy and paste, but the only way I see to input
file parameters is via the GUI. In the old DTS you could edit the
connection object and copy and paste a list of column widths, now it
looks like I can't do that.

Any body found a better way?

Thanks,




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.