Thanks Everett! I will give it a try later in the week when they get data back into the Oracle database and let you know if that did the trick....

Ok, I found the problem. Apparently, the cause of the problem is because there are spaces in the TEMP and/or TMP environment variables. See this site for more detail.

At the May SQL Server Live conference, Michael Hotek said he is currently working on a book devoted entirely to replication from a beginners perspective to the advanced level. Don't...

Yes, you have to have SQL Mail started prior to using xp_sendmail. You can start it through the GUI by using Enterprise Manager or you can use the T-SQL form...

I have also gotten that error several times before. Normally, I just close EM and reopen it. Everything seems to work fine after that.

Jason

Thanks!!! That script did the trick.

Jason

Okay, I created a new version of the package with a different name, but it still failed trying to open it from the client.

SQL Server Version --> 7.00.1021

MMC Version...

No, I think your solution and advice was right on.

Jason

Okay, I did what you asked and everything worked fine. I was able to open the package (after closing it), execute the package, and make changes.

The packages that I...

Thanks for your help !! I got it to work!

Jason

I used the same code that's in the article for a recent project, and it works great. However, I noticed in the code that the first recipient will not receive...

Okay, I think I'm starting to get it now. The NT logins have to be in the same domain as the servers; otherwise, I will have to create a SQL...

Actually, the package closes and we're left looking at the window where you see the list of packages that are created.

Jason

First off, both servers are in the same domain. Sorry, I should have mentioned that before.

Secondly, are you saying that one NT Login can't be mapped to the same NT...

Brian,

I liked your article. I myself am in the middle of testing TSA for our documentation purposes. I have found the same exact pros and cons that you have. Also,...