May 20, 2011 at 9:00 am
I'm trying to execute a slightly modified version of a script I found on here. It creates and deletes some temp tables.
I'm trying to execute it in a visual studio 2008 Integration Services project, using the data flow task->OLE DB Source ->SQL command data access mode.
I'm getting the below error when trying to preview the query. Is there some trick to temp tables with this?
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "Invalid object name '##FullBack'.".
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
May 22, 2011 at 11:50 pm
You need to set the RetainSameConnection property on the connection manager to TRUE.
edit: oh yeah, also make sure the temp table actually exists when you do the preview
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply