Congratulations guys.  I have used and promoted SSC for a number of years.  And I began using Red Gate’s products because of SSC.  Both are great assets to any...

Thank you for replying Scott, David, and Abdul.  As I said in a previous post, we are looking to store package configuration data in the .dtsconfig file rather than in...

Thank you to kenambrose, noggin, BEACHDBA, and David Russell for replying.  Do any of you use package configurations and logging?  If so, how do you store this type of data?  Also,...

Brandie,

Take a look at my post regarding a similar problem.  Title of the post is Changing connections at run time.

Lee

To follow up on this thread, we ended up putting configuration settings in an XML file and then in the job we specified the XML file.  In this case, things...

Don,

We too have a ton of DTS packages on our existing 2000 servers and we are now deploying our 2005 farm.  At first, we planned to do a slow transition...

Scott,

Thank you again for the reply.  I see what you are saying and I can see this could be the case.  But, if the configuration setting is only affecting one...

One last thing before I go home.  If you create a new job and create a step and you set the Type = SQL Server Integration Services Package, what is the...

Hey Scott,

Thank you for replying.

It is indeed true that connections are not allowed to my local SQLExpress database.  When the job runs the package on the server, I don't want...

J.L.,

Thank you very much for replying.  I'm not sure I follow your suggestion.  The part I don't understand is creating a "empty" config file.  But, I did try setting my...

I figured this problem out.

In order to fix the problem, I had to create a new SRS role (View Folders Only) that has the View Folders permission...

Thank you TomT and Wanderer for your responses.  Since the time I have posted this, I have came to both of your conclusions.  We are currently leaning more to using...

Thanks again for your response Zubeyir.  I agree with your assessment.

Zubeyir,

Thanks for responding.  I should say I personally do not have an issue with it.  But there are DBAs in our shop that think giving developers MS will give them...

Well, I have some bad news.  Maybe some grateful person reading these posts will know something about this.  We did our domain move last weekend.  It now appears that we...