dbTalk Databases Forums  

DTS Data Pump Task...What if source columns are re-ordered..?

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


Discuss DTS Data Pump Task...What if source columns are re-ordered..? in the microsoft.public.sqlserver.dts forum.



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

Default DTS Data Pump Task...What if source columns are re-ordered..? - 07-03-2006 , 05:58 AM






I have a data pump task which uses a csv file as the source, and a db
table as the destination. I have set up transformations to map the
fields in the source to the destination.

However...if the order of the columns in the csv file is now shuffled,
but the names of the re-ordered columns are still kept the same (but
obviously just in a different order), would my data pump task still
work, or would the fact that the columns are now in a different order
mean that my transformations would need to be redone?

Thanks folks!


Reply With Quote
  #2  
Old   
Davide Rossetti
 
Posts: n/a

Default Re: DTS Data Pump Task...What if source columns are re-ordered..? - 07-03-2006 , 07:17 AM






Hello mj.redfox.mj (AT) gmail (DOT) com,

Quote:
I have a data pump task which uses a csv file as the source, and a db
table as the destination. I have set up transformations to map the
fields in the source to the destination.

However...if the order of the columns in the csv file is now shuffled,
but the names of the re-ordered columns are still kept the same (but
obviously just in a different order), would my data pump task still
work, or would the fact that the columns are now in a different order
mean that my transformations would need to be redone?

Thanks folks!

if the header of your file contains column names you shoudn't have problems,
even if columns are reordered (of course in file connection props you need
to check 'First row has column names').
Bye




Reply With Quote
  #3  
Old   
AT
 
Posts: n/a

Default Re: DTS Data Pump Task...What if source columns are re-ordered..? - 07-03-2006 , 07:47 AM



Thanks Davide, much appreciated.


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.