Neil,

No, you wouldn't need a proxy in that case. When you look at the job history, does it say that the job step is executed as the login that...

Jaybee,

Regarding moving DTS packages between SQL 2000 instances, I prefer to open the packages in the old instance and save them to the new instance. They're stored in msdb,...

I guess Manoj and Simon got here before me, but I'm glad you got the info you needed.

Is the source data folder where the package file is stored i.e. D:\DMSSURG2K5_SSIS\CTSurg2K5_SSIS\CTSurg2K5_SSIS\CTSurgerySSISInboundRecords.dtsx?

That's what the Agent login needs access to.

User permissions are stored in the database, so they are not copied when you copy logins from instance to instance. You can either script the users and permission from...

Check to see if SQL Server is set to Windows Authentication mode or if you used the wrong password for SA.

I got this error when trying to execute a package stored in the file system and found that the SQL Agent account didn't have access to the folder where the...

I think the problem is not so much who owns the package as it is who is running the job. If you want a login other than the one...

Go here for links to a bunch of articles: http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html

Download and run SQL Server 2005 Upgrade Advisor to see a what issues you may have with your DTS packages. ...

No. Build it yourself by selecting from sysfulltextcatalogs in each database.

You could add a check to see if each table exists before attempting to import it. I could either be a step in the job before the step that...

PK_MyTableName is probably the primary key for MyTableNameorig. Renaming a table doesn't rename it's indexes and constraints.

I can't find it on the SQL 2005 installation CD so it probably isn't included. That doesn't mean it won't work in SQL 2005. If you have a...

What kind of help do you need?

I don't think there's a built-in way to do this. This is probably best handled in code in stored procedures. How are employees accessing the data? Do...