Question about configurations

I've been reading up on package configurations, but I'm not quite sure how to use them correctly. If I am developing a package, I want to connect to a testing server. Then, when it is working correctly, I want to connect to a production server. Are configurations a helpful way of doing this, or would it only be helpful if in the future, I need to make the packages reference a different server?

Hi Micheal,

That is exactly the use I want to make of configurations. I have been experimenting with registry and configuration file but neither seem to work. frankly I don't get it because I do exactly what I find in literature concerning this topic;

Keep me posted if you find the solution I'll do the same.

Greetings,

Paul.

|||

Configurations are all about taking the environment specific values out of a package and storing them elsewhere to make your packages portable. The configuration will then provide this information when you load the package.

Easy Package Configuration
(http://www.sqlis.com/default.aspx?26)

Jamie Thomson - SSIS Jibber Jabber : SSIS: Indirect configurations ROCK!
(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx)

Keep Your Packages in the Dark
(http://www.sqlmag.com/Article/ArticleID/47688/sql_server_47688.html)

|||

Hi Michael,

You might find the solution in my thread Package Configuration using xml-file fails from yesterday. Jamie Thomson gave a very usefull answer.

Greetings,

Paul

Question

Hello every body.

I have a problem with SQL Server. I have two computers (XP and Vista) I am developing my project sometimes on XP and sometimes on the Vista one.

Everything was fine until when I started working on login part of website. The XP is totally fine but when I run my website on my Vista to see and test, this error show up:

So I did a little search and aparently this is what I should do to fix this problem:

sp_configure 'user instances enabled','1'

RECONFIGURE;

GO

I used this code in SQL server Express and pressed Execute, but this was the error:

Msg 15247, Level 16, State 1, Procedure sp_configure, Line 94
User does not have permission to perform this action.
Msg 5812, Level 14, State 1, Line 2
You do not have permission to run the RECONFIGURE statement.

Now I have no idea how to fix it any further.

I appreciate your help.

Thank you.

Try to login with admin or sa account which has admin prievelage on Sql Server ...

|||

You might try logging in as the Adminstrator on the XP machine before running your recongifuration script.

|||

Thank you very much, I tried it as Admin but still the same exact error is there.

Stiletto you said log in on XP as admin but my problem is not on XP its on Vista.

I actually tried the same thing before (I loged in as Admin) but now this is the second time and still the error is the same.

Do I need to uninstall the SQL server and install it back ? What do you think friends ?

|||

Check the permission with the sa or admin acount of sql provide it full permissions and try again ... uninstalling is not a solution i think so ..

|||

Do I need to attach my website's database before running that SQL code ?

And where do i have to check the permission ?

|||

Check the Permissions in the Sql Management Studio for the User ...

|||

Hi,

I am kind of new with this. Where am I suppose to do this (Checking user permissions). I mean which part of managment studio ?

What would generally cause this in the first place ? how come my XP is fine but Vista turned up to be like this ?

|||

I think you XP and Vista has different Sql Server installed. You need to goto open Sql Server Management Studio . Under the security node under the login check for the particular account. Click on the account you want to give permission .. check the server roles. You can enabled more roles.