SSSI and DTS Packages
-
Guys,
I have a user that wants to migrate SQL Server 2000 packages and create new packages in SQL 2005. Which server role do I need to add his login? and what other privilges would he need to have to accomplish his task?
-
Hi,
You can grant the user sa permission. Or open a DTS package and manually try to save a package in the SQL2005 Server.
-
tell him to use Visual Studio , create a new SSIS project and use the migration wizard for DTS 2000. (he must be able to get to the SQL2000 package ! )
For the project, he'll need no auth at all at your server, other than eventualy the package may need if it is designed using windows authentication.
To deploy, he'll need auth to be able to get to SSIS !
Check BOL for that.
btw Greetings from SQLPASS in Denver
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply