I've heard of this problem before.  It has to do with variable data lengths in the source.  The usual advice is to try the workaround in this KB article:

Either drop the foreign key constraints before importing and recreate them after importing or import the tables in the corrrect order (parent then child, as you stated).

Here's a script I've...

Here's one that I created to run a DTS package.  Note that the DTSRun command is encrypted as I don't have one on hand that's in plain text.  The entry...

SQL 2005 gives the option to log step results to a table.  You could check that for each step, then query the table in the last step of the job...

John,

See "SQL Server Agent Fixed Database Roles", particularly SQLAgentOperatorRole, in BOL.

Greg

Maybe Loner means she uses OPENROWSET?

Greg

If DBCC DBREINDEX is used in the plan, you're probably right that it's generating a lot of growth in the transaction log.  I noticed that you have restricted log file...

I'm not sure how much help I can be.  I'm able to create a connection in a DTS package for a SQL 2005 data source.  The only time I've gotten...

Try logging on to the database server using that account and try executing the package manually.

Greg

Use sp_helpsrvrolemember.  What do you want to do with the list of logins once you get them?

Greg

If, by circular reference you mean a table referring to itself via a foreign key constraint, the query I posted should show that.  You can get rid of them by...

We've chosen to migrate rather than upgrade mostly because we wanted an easy way to fallback if something didn't work as expected in SQL 2005 and because some of our...

Try this query to get a list of all the foreign keys and referenced tables in a database:

select

t.name as 'Table', c.name