Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

OLE DB Source Task - Error "Command text not set for comma..

   Database Forums (Home) -> DTS RSS
Next:  fillfactor  
Author Message
Adam S


Since: Mar 12, 2007
Posts: 10

(Msg. 1) Posted: Fri Jul 06, 2007 7:26 pm
Post subject: OLE DB Source Task - Error "Command text not set for command objec
Archived from groups: microsoft>public>sqlserver>dts (more info?)

When using an OLE DB Source Task I receive an error that says:
"Error at Import OLE DB Source: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB
error has occurred. Error code: 0x80040E0C.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for
Oracle" Hresult: 0x80040E0C
Description: "Command text was not set for the command object.".

We have reconfigured the connection manager multiple times and all
connection tests succeed.

Any help is appreciated.
Adam S

 >> Stay informed about: OLE DB Source Task - Error ""Command text not set for comma.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Why no source columns in Transform Data task? - Sometimes when I use a Transform Data task, enter a proc as source, the transformations tab does not show any columns in the source list and the task complains of undefined tranformtions. In the source tab and clicking on previous button, it shows..

Data Pump task for varying number of source column - Hi, I am trying to load a text file into a table using the data pump task. The source file can have up to 16 columns but may have less. I always want to take all the columns and I am sure there must be a way to check whether a column exists before..

Input Parameters in DataReader Source of Data Flow task - Is it possible to pass input parameters to a DataReader Source of a Data Flow task? The query parse balks at the question mark placeholder in the query, so I am assuming no. Any suggestions on an alternative?

DTS SQL TASK ERROR - Hello, How can I implement error handling in sql task? My DTS imports flat file using the sql task and I would like to know the record ID or fields when it fails. Thanks

Data Pump Task Error - I have a data pump task in which I am pulling data from Oracle to SQL Server, so hopefully somebody in here can help me out. The data pump task is running a query against an Oracle table and then copying the data straight into a SQL Server table. I...
   Database Forums (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

[ Contact us | Terms of Service/Privacy Policy ]