Temparary tbles in DTS

• Yuvraj Powar

  SSC Veteran

  Points: 272

  More actions

  February 15, 2005 at 1:19 am

  #67056

  Hi,

   

  I am executing the stored procedure in DTS package.DTS pacakge genrates a report in Excel file and send a email to user.

  I am using the temp. tables in stored produre.But in transaction  tab it is not showing and source columns to connect with destination columns . It is giving error.

  Can I execute a stored procedure inside DTS having temp tables in stored procedure?.

   

  Thanks in Advance

  Yuvraj

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  February 15, 2005 at 5:49 am

  #542250

  please see comments in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=161630

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net