Home / server / Questions / 175002
Accepted
Manjot
Asked: 2010-08-27 14:12:14 +0800 CST

MSSQL: SSIS 2005 transfer logins task

  • 772

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

sql-server-2005 ssis

1 Answers

  1. Best Answer

    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.

    • 0