x

SSIS Connection Managers not connecting in debug

Hi, Just recently we have begun to experience an issue with our connection managers in debug. I am using ssis 2005 BIDS. I can open the connection manager in the package, enter the password and click "Test Connection" with success. But when I execute the task, I get an error indicating the connection was not successful. I have a package config file enabled. When I disable the config file it executes properly. The config file has ConnectionString, Server name, user name and Password in it. However, I am trying to test the passing of a variable from the config file to the package, so I need the config file enabled. Can you tell me how the config file comes into play regarding debug? Am I doing something incorrectly?

Thanks! paws27284
more ▼

asked Sep 24 '12 at 06:21 PM in Default

paws27284 gravatar image

paws27284
353 23 28 32

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Hi ,

I guess the problem is more of an access issue or invalid credentials set in the config.

Quick suggestions. Try to recreate the config file again after entering the values in the package connection string. Try to check if the config connection string matches the connection string in package. I guess it is enough you condfigure only the connection string since that holds all the required parameters.

Thanks, Kannan
more ▼

answered Sep 25 '12 at 05:48 AM

aRookieBIdev gravatar image

aRookieBIdev
2.3k 42 54 58

(comments are locked)
10|1200 characters needed characters left
Overall it looks like all of my connection managers at some point in time become corrupt. It doesn't matter which package, whether there is a config file associated or not, whethter in debug or executing the package from the SQL job agent. Any ideas or suggestions regarding the whole idea of connection managers?
more ▼

answered Sep 25 '12 at 07:07 PM

paws27284 gravatar image

paws27284
353 23 28 32

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1933
x900

asked: Sep 24 '12 at 06:21 PM

Seen: 679 times

Last Updated: Sep 25 '12 at 07:07 PM