import export using csv file

• am-244616

  SSCarpal Tunnel

  Points: 4936

  More actions

  February 8, 2007 at 1:37 pm

  #194236

  Guys,

  I have txt file with following values

  fname lname

  ______________

  Tom Gray

  Tim Junk

  I want to be able set a job to import this into NAME table 10pm every night

  NAME table has the following columns

  FNAME VARCHAR(20)

  LNAME VARCHAR(20)

  DNAME VARCHAR(50)

  after I load the data I concatenate FNAME and LNAME into DNAME. I want to setup a job then to export out DNAME column

  is there any way this can be acconplished using dts job

  Thanks

• Loner

  SSC-Insane

  Points: 21279

  More actions

  February 8, 2007 at 1:50 pm

  #688662

  You already posted this question in the DTS section.