yes, I have seen it lock on a SELECT when I don't think it should. When it's done that we've use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED. Sometimes that will...

See if this will get you started:

http://www.sqlservercentral.com/articles/introductiontodtsinsqlserver2005/1486/[/url]

The following blog has some good SSIS info:

http://blogs.conchango.com/jamiethomson/[/url]

See if this will help you get started:

http://msdn.microsoft.com/en-us/sqlserver/bb945116.aspx

1st question:

are you going from x64 to x86 at any point?

2nd question:

Have you verified that the linked servers are configured properly and working?

3rd question:

Go to the server and do Start->Programs->Administrative...

You could try to use the import wizard for DTS packages from SQL Server 2005. Your results may vary.

With the information you've provided I believe it's possible to say that some of the stored procedures are stored in the msdb database and some are stored in the filesystem.

Did...

From my experience it doesn't matter if you are hitting an engine or integration services. The only way I can get the box enabled is to use SQL Server logins....

Good to know that you got it working.

Also, anytime you see 2005 code there's a possibility you could adapt it to work with 2000.

Guess we better all be careful :

http://www.freepatentsonline.com/y2007/0118573.html

I'm trying to do this myself as well.

You already mention that you are looping through a temp table with the linked servers so I won't worry about that.

See if this code will get you started:

SET NOCOUNT ON;...

See if this link helps you at all:

http://www.sqlservercentral.com/Forums/Topic553730-146-1.aspx#bm553792

Good article Brandie, I hadn't seen that one.

If you are looking into becomming a dba I would highly recommend reading through Brad McGehee's "How to be an Exceptional DBA".

http://www.red-gate.com/products/sql_backup/offers/exceptional_dba_awards.htm

http://www.sqlservercentral.com/Forums/Topic525175-10-1.aspx

Yea, I passed it a few weeks back. Luckily my weak areas of weren't exposed too badly. 🙂

I'm going to agree with Brandie.

Go with the 2005. Once you take the 3 exams and get MCITP in 2005. If and when you are working with 2008 you can...