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

error running package

 
   Database Help (Home) -> DTS RSS
Next:  smtp problem with pear and exim on cpanel  
Author Message
ronnie

External


Since: May 14, 2008
Posts: 27



(Msg. 1) Posted: Wed Dec 24, 2008 9:35 am
Post subject: error running package
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I am trying to run a SSIS package from Visual Studio on my machine. This
package is to connect to a database but I am getting this error:

The AcquireConnection method call to the connection manager failed with
error code.

What might be causing this error?

 >> Stay informed about: error running package 
Back to top
Login to vote
Todd C

External


Since: Jan 31, 2007
Posts: 106



(Msg. 2) Posted: Fri Jan 02, 2009 6:28 am
Post subject: RE: error running package [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There are several reasons. What is the error code and what is the error
description?
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"ronnie" wrote:

> I am trying to run a SSIS package from Visual Studio on my machine. This
> package is to connect to a database but I am getting this error:
>
> The AcquireConnection method call to the connection manager failed with
> error code.
>
> What might be causing this error?

 >> Stay informed about: error running package 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Running a dtsx package - Good Afternoon, i tried this thread on a .NET Forum, and it seems that this forum would a more likely candidate for help. What i am trying to do is run a DTSX package from the file server, not the sql server. there are many ways to do this, but i seem...

Running SSIS package for non-dba users - Currently I have two SQL servers that need SSIS packages run against them to upload data from excel or access. The preferred method is to have an end user start the process. On one server, the SSIS file package is run by starting a SQL job, which has..

DTS Package Error - Hi there, I have created a DTS package that copies data via an ODBC connection into a MSSQL 2000 Server + SP3 on a Win2000 server + SP4. The package runs as a scheduled job at 15 min intervals due to data volumes and network bandwidth to keep the..

Error while executing the SSIS package - Hi, Here is a strange problem i"m facing with my SSIS pakcage. I've a SSIS package which reads from a csv file and loads the records into database. I've used a Flat File as source and OLEDB as destination. On my development machine, the package run...

SSIS nested package error - Hi, We get an error running a SSIS package which calls another package. Both packages execute Ok independently. Error: "The LoadFromSQLServer method has encountered OLE DB error code 0x80040E09 (The EXECUTE permission was denied on the object..
   Database Help (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 ]