How to create a temp table in SSIS

• TangoVictor

  SSChampion

  Points: 10975

  More actions

  April 23, 2009 at 8:05 am

  #208665

  Is there a way to create a temp table in SSIS (memory) that can be accessed by an OLE Source?

  thanks - tom

• vishal.gamji

  SSCertifiable

  Points: 6126

  More actions

  April 23, 2009 at 8:52 am

  #982981

  Do u mean like an execute SQL task creating the temp table and then the OLEDB source in a data flow task access it.... u can.

  for the source to read the temp table work with the SET FMTONLY option. Lookup in BOL.

• ruizeddy

  Old Hand

  Points: 323

  More actions

  April 24, 2009 at 6:12 am

  #983471

  Not sure if this is what you are looking for, but I have used this method to create memory tables to temporarily store data.

  declare @dbs as varchar(100)

  declare @recmodeltbl table(modeltype varchar(100))

  set @dbs='xyz'

  insert into @recmodeltbl select convert(varchar(100),DATABASEPROPERTYEX (@dbs , 'Recovery'))

  select @recovery_model = modeltype from @recmodeltbl

  May your fish always be bigger
  Than the holes on your net.