Are you looking at the table by opening it in Enterprise Manager?  I've noticed that errordescription isn't displayed there.  I can see it if I query the table in QA. ...

Enable logging for the package by going to the "Logging" tab of Package Properties in DTS Designer and checking "Log package execution to SQL Server".  You can also designate a...

Just so I'm clear about this: your top level package is a parent that executes child packages with Execute Package tasks and you expect the parent package to fail if...

Hi Ed,

Which data types have you tried and which method are you using to import the data into the table? 

Greg

You backup msdb just like you do any user database.  Either right-click on msdb in Enterprise Manager and select 'All Tasks' then 'Backup database' or use BACKUP command in Query...

Hi Ronnie,

No, I haven't.  I'm really just looking for an example to refer to.  I'm working on a team trying to figure out how to use employee data in SQL...

Lumigent Log Explorer, Red-Gate SQL Log Rescue, ApexSQL log.

Greg

I believe it's better to grant EXECUTE permission to stored procedures in msdb than to grant permissions to the system tables.  Basically, the user needs to be able to execute...

Try having the child package join the parent package's transaction.  Then, if the child package fails, the parent package will also fail. 

1. Right-click on the Execute Package task in...

It's also helpful to enable package logging in the DTS package itself. 

1. Open the package in DTS Designer.

2. Right-click in an open area and choose Package Properties.

3. On the...

Assign execute permission on sp_get_dtspackage to the users whom you want to open the packages.  As long as they're not the package owner or a member of sysadmin, they won't...

Gaby,

You can use DTS, but it's going to be pretty tedious.  You might be better off using the bcp utility.  You could create a bcp command for each table, put...

Please post the error that DTS is reporting.  If you have package logging enabled, the error will be shown there. 

Greg

I'm not sure I understand this problem.  Is there duplicate data in the input file that would result in duplicate key errors in the destination table?

Could you post the structures...

User SERVERPROPERTY e.g. SELECT SERVERPROPERTY('collation').  See SERVERPROPERTY in BooksOnLine.