dbTalk Databases Forums  

Naming col001, etc of imported flat file for transformation

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Naming col001, etc of imported flat file for transformation

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


Discuss Naming col001, etc of imported flat file for transformation in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Zach.Baier
 
Posts: n/a

Default Naming col001, etc of imported flat file for transformation - 05-11-2005 , 04:48 PM





How do you give user friendly name to columns from a text file connection?
change col001 to AccountNbr, etc for use in script transformations.

Reply With Quote
  #2  
Old   
Michael Evanchik
 
Posts: n/a

Default RE: Naming col001, etc of imported flat file for transformation - 05-11-2005 , 07:44 PM





Zach

While using the dts wizard, there is a transform button, from there there is
an edit sql button, there is where you can change the field names

Michael Evanchik
www.michaelevanchik.com


"Zach.Baier" wrote:

Quote:
How do you give user friendly name to columns from a text file connection?
change col001 to AccountNbr, etc for use in script transformations.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top