up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
82% accept rate
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
feedback

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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