Results 1 to 2 of 2

Thread: Problem with DTS when using #Temp, temporary tables

  1. #1
    Join Date
    Aug 2004
    Posts
    52

    Problem with DTS when using #Temp, temporary tables

    I've created one stored procedure which uses #temp, temporary table.
    When I schedule it to generated output in CSV file using DTS, it flags me an error
    as ,
    'Context: Error Calling GetColumnInfo. Your Provider dows not support all the interfaces/methods required by DTS'

    Can anyone tell me why this error occurs? Or is it true that one cannot use Temporary tables in generating output in CSV or text file using DTS ?
    I am using MS-SQL Server 2000

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use global temporary table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •