Can I load source text file into temporary table?

• JMI

  SSChampion

  Points: 11831

  More actions

  October 14, 2008 at 7:15 am

  #127965

  I'd like to load my source text file into #tmpSICDIM table and then do some manipulations - convert rows into columns.

  Can I do that?

  So far I have not been able to find a way to do it in SSIS.

  OLE DB Destination can not be temp table?

  Can I do it or not?

• hodgy

  SSCertifiable

  Points: 5906

  More actions

  October 14, 2008 at 9:38 am

  #884714

  Have a look here for a possible solution

  SSIS: Using Temporary Tables

  Life: it twists and turns like a twisty turny thing