Temparary tbles in DTS

• Yuvraj Powar

  SSC Veteran

  Points: 272

  More actions

  February 15, 2005 at 1:14 am

  #76239

  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:46 am

  #542249

  #TEMP tables do not show as being able to be selected as SOURCE/DESTINATION.  There are two ways to get around this.

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• philcart

  SSC-Forever

  Points: 47796

  More actions

  February 15, 2005 at 11:50 pm

  #542452

  Nice one AJ I think you may have been censored

  Yuvraj, take a look at this post

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=161904

   

   

  --------------------
  Colt 45 - the original point and click interface