Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Glasgow, Scotland
    Posts
    107

    Unanswered: temp table in DTS Package

    Hi,

    I am trying to create a DTS package that transforms the results of a stored procedure into an Access database table. Within the stored procedure I use a temp table to return the dataset:

    SELECT patno, patfname, patsname, DOB, patadd1, patadd2, patadd3,
    patadd4,patpcode,chinum,sex,mcnGP,DOD,COD
    FROM dbo.##tmp_tblPrivDemo ORDER BY patno

    However, when I try and click on the Transformations tab within the DTS package I get the following error:

    Error Source: Microsoft OLE DB Provider for SQL Server

    Error Description: Invalid Object Name '##tmp_tblPrivDemo'

    When I use a permament table it runs fine but there is a decrease in performance. Does anyone know how I can get this package to work using temp tables?

    Thanks

  2. #2
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63

    Try bracketing it

    How about wrapping the name in brackets: [##tablename] ?

Posting Permissions

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