April 1, 2011 at 4:35 am
Hi,
While SSIS package i got the following error.
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 Native Client" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Invalid object name 'teoco.IDDMOUBYV_ROUNDEDDLYTRMCAR2011-04-01-2011-04-30'.".
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
Could you please help me in resolving the issue. Thanks in advance.
April 1, 2011 at 4:51 am
its quite hard to predict the reason without knowling your dts/ssis, but from the error, it seems like the object not exists.
Description: "Invalid object name 'teoco.IDDMOUBYV_ROUNDEDDLYTRMCAR2011-04-01-2011-04-30'
----------
Ashish
April 1, 2011 at 5:44 am
Hi Ashish,
Thanks for the quick response.
I am using an OLE DB as source and destination is a flat file with SQL command option and after giving the sql query i got the above error. I am using SQL server 2005.
Thanks.
April 1, 2011 at 5:58 am
so the invalid object which I referred, does exist? Give more detail as what you doing within your package.....like from which table to which flat file(txt file or something else)
----------
Ashish
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply