I appreciate the effort in laying out the steps one after another. This is a good time-saver at least for me.

Here is a little more on it. It will be coming back.

http://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx

Then just change the Initial Catalog parameter in the connection string.  

Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=True;Network Library=dbmssocn;

Yep, you can do that.

Here is a article on CodeProject that will show you how to cycle through connections to different servers. I built on it to create a Login...

Try setting up a DSN using Windows authentication and have someone who can not login to the database with Windows authentication use the DSN.

I like Microsoft SQL Server 2005 Integration Services by Kirk Haselden, Sam's Publishing.

Kirk was the Development Manager for SSIS and it is obvious he knows his stuff.

I...

Thanks All.

I found the problem. During a move from a VMWare server the folder security was screwed up on some folders and what ever created these temp folders could not...

Thanks but I tried that. They seem to be associated with SQL Server someway but I sure don't know how.

Wouldn't it also make a difference who ran the query? If the dba was running it from his machine how about using sp_helpprotect?

This utility claims to do what you want.

DTSRunDec

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

Try something like this,

SELECT *

FROM AS400LinkedServerName.AS400DatabaseName.AS400Library.AS400FileName

You can use the WRKRDBDIRE command to get the AS/400 database name.

I saw that. Wish they would put the tools on-line as well.

Never satisfied

OK, where can you buy it? It seems to be out of print.