Thx much for your reply. I will try that. I did the following, right before I saw your post.

1. Go directly on the destination server

2. Create the package...

Executed as user: Domain\mysqluser ... Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:11:30 PM Error:...

Hi. This is getting SUPERCRITICAL here. I made the package a .dtsx file. I need some tips on what I should do.

1. Do I need a proxy...

I believe I do save my sql authenticated password. I will try to save as a file, and turn on logging.

This is most frustrating, b/c you are now required...

I tried both 'Do Not Save Sensitive'.... (ie no protection), and 'Rely on Server and Storage Roles' but no success - with different errors.

I forced the job step to...

I feel like I tried everything! I went through this article step-by-step and still no success.

http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

The only thing I couldn't/didn't do is set up the credential for...

thx for reply. I saved it to the SQL Server. I can't even kick off the job without erroring out. Suggestions?

Thx, know about SQLcm, but trying to avoid the $$ for now.

I meant triggers are the most common way, but agree that it is a bad idea -which is why...

why?  Maybe for non-intrusive logging and correlation of events.

I know the best ways are triggers and/or profiler, but wanted to avoid this.

Now that you know why, can you suggest from...

So, every node particpating in peer-to-peer requires a SQL Enterprise License?

Well, thanks Peter that was of great help.  Is that not what these forums are for?

Thx Yes, I was considering a CTE, but came here for some help, specifically some code.

Thx, all - I used a forward-only cursor afterall - doesn't take much resources.

Thx for the quick reply.

While I appreciate this method, I'd prefer not to use sp_msforeachdb, b/c I need to use the dbname in a sp script.