The size of the database doesn't matter so much as your organization's tolerance for data loss i.e. how much data would you be willing to lose if you had to...

Are you running sp_dropalias in the MarketingRpt database? 

Perhaps the login isn't aliased to dbo at all.  If the login is a member of sysadmins, it's not aliased to dbo...

1. Open the package in DTS Designer

2. Right-click on the Data Transformation task and choose properties

3. Click on the Options tab

You'll see a section at the bottom of the pop-up...

Geetha,

I assume you're using a Transform Data task to import the data.  Look on the Options tab of the task properties and you'll see that Use Fast Load is checked. ...

A database can have just one primary file.  Each database is limited to 32,767 files including the primary file and log files.

Greg

I agree about DBCC LOG, but here's a link to the syntax for it:

http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp

Greg

I'll burn that bridge when I get to it.

Greg

You can change the owner without using the stored procedure and cursor.  The key bit is the undocumented stored procedure sp_reassign_dtspackageowner.

In msdb, Execute sp_enum_dtspackages to find the name and id...

Shagols,

I understand your situation and I'm sure you're careful enough about it that there would be no data inconsistency.  It seems that MS is trying to protect people who aren't...

I think it's to better ensure data consistency.  Even though the databases on the two servers have the same name, they are different databases with no guarantee that they are...

You're absolutely correct.  The tasks (and the steps that use them) are named in the order they are created, not the order they are eventually executed.  Unfortunately, you can't make...

Papillon,

I've replied to your thread in the DTS forum.

Greg

Papillon,

The there are lots of causes for a timeout error, especially if it's intermittant.  There could be another process blocking the Execute SQL task or the timeout property might be set too...

I agree with John.  We run SQL Server backups to disk files which are backed up to tape by our network technicians.  The tapes are stored offsite so that we...

Somebody,

If you want to add package execution to an existing job, run the DTSRUNUI utility and copy the generated DTSRUN command into a new step in the job.  You...