Handling SSIS errors

#1

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#2

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#3

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#4

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#5

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#6

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#7

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#8

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#9

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

#10

I am assuming if the logins no longer exist is Active Directory, then you can
delete the user account/SID from the source SQL Server before you run the
transfer task.

Happy 4th!!!

--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2005
Management & Administration

Look forward to my new book called SQL Server 2008 Management & Administration

"Leon Shargorodsky" wrote:

Quote:

I'm using "Transfer Logins" task in SSIS package to copy SQL logins from one
server to another. Some logins no longer exist in Active Directory and this
is where my package breaks.
How can I make my package ignore the errors and finish copying existent
logins?

Thank you in advance for your help!

Leon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Handling SSIS errors

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Handling SSIS errors - 07-01-2008 , 03:07 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM

RE: Handling SSIS errors - 07-04-2008 , 02:01 PM