What are the tasks in the package and what does each task do?  Enable package logging and post which task fails.

Greg

In Query Analyzer:  SP_HELPROTECT NULL, 'user'

In Enterprise Manager:  Expand the database, expand Users, right-click on a user, select All Tasks, select Manage Permissions

Greg

Are you restoring a database from a backup or are you importing data using DTS or some other ETL-like tool.  Are the import and export tables like staging tables?

Greg

I'll take a guess.  When you run the package manually (as yourself or as America\SVCSQL), are you logged on to a workstation or to the server?  My guess is that...

"Backup device" is a synonym for either a logical or physical device.

RESTORE HEADERONLY

FROM DISK = 'd:\Microsoft SQL Server\MSSQL\Backups\mybackupfile.BAK'

substituting your disk file for the stuff in quotes.

Greg

Perhaps some tasks weren't properly.  This MS Knowledgebase article has suggestions causes and workarounds:

http://support.microsoft.com/kb/288910/en-us

Greg

Use RESTORE HEADERONLY in Query Analyzer.

Greg

Steve,

I don't have first-hand experience with this error, but searching MS Knowledgebase for he error message returns several possibilities and fixes.

http://search.support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&1033comm=1&spid=2852&query=Could+not+obtain+information+about+Windows+NT+group%2Fuser&pwt=false&title=false&kt=ALL&mdt=0&res=20&ast=1&ast=2&ast=3&ast=4&mode=a&adv=1

Greg

We're starting to plan our upgrades and will probably start upgrading to SQL2005 in the next 6 months or so.  We've already gotten budget approval for new license purchases and...

Hi Sheila,

A package executed on your workstation actually runs there.  That means the data will be pulled from the text file on the server, throught your workstation, and back to...

I have never had that happen.  I'm using the same version and SP level as you and the check boxes on the Copy tab always stay the way I've set...

Does the package create tables in the destination database or just insert data?  If it's the former, the destination user must CREATE TABLE permission or be in the db_owner or...

Hi Sherrie,

Global variable names are case-sensitive so make sure you've spelled it exactly the same in the Execute Package task as it's spelled in the sub packages.

Greg

Yes.  The reason you don't see table permissions for the user is the permission is granted to the role and the user is a member of the role.  See 'fixed...

You can't administer full-text from a client computer.  I've found that I have to connect directly to the server or through Terminal Services. 

This article explains why:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q270671

Greg