Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I created an SSIS package to transfer logins from one server to another in SQL 2005 SSIS project using BIDS.

I want to transfer all packages but skip 3. So I changed the maximum number of error count to 3. But it didn't help.

can anyone please help me in achieving this?

Thanks in advance

share|improve this question
Why not just script them out with sp_help_revlogin? – mrdenny Aug 26 '10 at 22:29
I found that sp_help_revlogin doesn't copy server roles across. + I need to run this on daily basis. Any comments? – Manjot Aug 26 '10 at 22:39
up vote 0 down vote accepted

Work around- used dynamic sql to capture all logins, stored it into a temporary table. Scripted out for the ones needed and then ran executesql.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.