working with the wizards

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  March 22, 2012 at 9:40 am

  #270531

  I want to open the excel file using SSIS and save the results in a text document. When i look at the import or export wizards, i either have to import the file to sql server or export the file from sql server. I do not see an option where I can have excel as the input file and and save the output to a text file.

  How would I accomplish this goal?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 22, 2012 at 9:47 am

  #1462838

  Looks like you get to develop a custom SSIS package.