file example

• riya_dave

  Hall of Fame

  Points: 3106

  More actions

  August 15, 2012 at 9:06 am

  #260762

  hi,

  i need example of taking data from file and putting into table and doing some modification of data ,

  getting data from table and putting into file.

  with max transformation ,can anybody send me link or example.

  thanks

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  August 16, 2012 at 2:21 am

  #1526385

  Looks like you might want SSIS for this.

  Plenty on the topic in the stairways section.

  Use it to load the file into the table, then you can use T-SQL to modify it.

  Or modify the data in the SSIS package before loading it into the database.

  Exports exactly the same, but in reverse.