Home Forums SQL Server 2005 SQL Server 2005 Integration Services Stored Proc with temp table issue. RE: Stored Proc with temp table issue.

  • May 26, 2013 at 1:35 pm

    #1618624

    BlackGarlic (5/26/2013)

    index portion of code is wrong. It's actually

    create NONCLUSTERED INDEX #idx_ID on #ID(ID) include (TID).

    But I will run it again without index portion.

    I an using following sql code in OLE DB Source:

    exec dbo.usp_GetBill_Info @StartDate =?, @EndDate=?

    And you have defined the parameters and the appropriate variables in the OLE DB component?

    I am trying to do something similar using SSIS on my system at home, just not with your proc.