If it works the way the DTS wizard works in SQL 2000, the data actually is routed through your workstation when you run the wizard from there, but it stays...

Is this a named instance?

In DTS, steps are associated with tasks via the Taskname. If you've renamed tasks, the step isn't automatically updated. Open Disconnected Edit, expand steps, and highlight each step...

I apologize for misreading your original question. You were on the right track when you had the EXEC stored procedcure in a Transform Data task, but you need to...

It's an obsolete right outer join operator. It should be replaced with the SQL-92 syntax RIGHT OUTER JOIN.

Hardly. I work for state...

Put the EXEC in an Execute SQL task.

Open the package in DTS Designer, click on "Package" on the toolbar, "Save as..." and choose "Visual Basic File" in the Location dropdown.

We, too, are trying to wrap up the migration from SQL 2000 to SQL 2005. It's taken us a lot longer than previous migrations because of the big jump...

As far as I know, the query tool is integrated into Management Studio and can't be seperately installed. You might find a third party query tool that can be...

If SQL Server Agent is running as you, it throws out my idea. Maybe you should configure logging in the package so you can get some clue about why...

I'll guess that the account that SQL Agent runs under doesn't have permission write to the flat file location. When you run the package yourself, any connection in the...

This most likely has to do with the Package ProtectionLevel. The default is EncryptSensitiveWithUserKey which means only the user who saved the package can open it or execute it....

You can save the package as a Visual Basic file, edit it, and save it back to SQL Server. You could also use Disconnected Edit in DTS Designer to...

Thanks for reminding me about granting permissions at the database level. It's not very well documented and I'd forgotten about it.

As for your concern about restricting the...