a temp table is used in the sql query of the source in data flow of my package..if i run the package getting the error '[OLE DB Source ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Invalid object name '#Output'.". '
i tried all possible ways i knew..any help is greatly appriciated..enclosing the query also