[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

"Error HRESULT E_FAIL has been returned from a call to a COM component.".

Posted on 2009-02-17
4
Medium Priority
?
3,793 Views
Last Modified: 2013-11-10
when i try to execute a sql execute task with a simple querry 'select getdate()'i am getting this error..anybody please help me..
0
Comment
Question by:ametuer999
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:PedroCGD
ID: 23665654
give a screenshot about SQL Task configuration.
Do you created the connection to the provider?
0
 

Author Comment

by:ametuer999
ID: 23665916
yeah..i have created
sql-execute-task.bmp
0
 

Author Comment

by:ametuer999
ID: 23665929
please look into the screenshot
0
 
LVL 22

Accepted Solution

by:
PedroCGD earned 2000 total points
ID: 23668941
Take a look at the package I made for you.
Open or create a SSIS Project
Add the attached package to it.
Update the connection
and run the package.

If still fails, go to your dabatase and execute the statment manually and check if runs ok.
Give feedback
Regards,
pedro
www.pedrocgd.blogspot.com
SSIS-Interface.JPG
Package-EE93-dtsx.txt
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question