I can think of three methods. 

1. Since DTS packages are stored in the MSDB database, back up the database then restore it after the rebuild.

2. Open each package in...

Hi Lowell,

My PL/SQL is sort of rusty, but I think GROUP BY isn't allowed in a view definition.  Try leaving that out of the CREATE VIEW and using it in...

Open the child package in DTS Designer, open Package Properties dialog, select the Logging tab, enter the name of an error file in the "Error handling" section. 

Hopefully, you'll get...

Create a package in DTS Designer.  We use this script, which is a variation of a script from this site, to list FK constraints and generate DROP CONSTRAINT and ADD...

If you haven't already, turn on package logging for the child package.  Also turn on logging for each Transform Data task or Data Driven Query task that you may have...

Are you using DTS to import the file?  If so, look on the options tab of the Transform Data Task.  There, you can specify error files that will contain rows...

Just make sure the stored procedure and table are both owned by dbo.  Then you can grant EXECUTE for the stored procedure to a user without granting table privilages.

Greg

You could try sp_depends to start.  Be aware that doesn't list cross-database dependencies and it might not list other dependencies.  See this forum thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=19637

Greg

Try this:

select dateadd(day,-1, tranxdate)

See DATEADD in BOL for details.

Greg

Maybe your client has an Oracle background.  I remember "dump" terminology from my Oracle DBA days, too.  The output of an Export is a .dmp or "dump" file. 

Greg

Try dropping the database you created on the experiment server and let RESTORE create the database.  See 'How to restore a database with a new name' in BOL. 

Greg

The package itself can't send email after it's completed.  You could use workflow to make the send mail task the last step in the package so the email is sent...

So, you want to move a SQL Server instance from one server to another?

We've settled on using scripts to detach and attach databases, create backup devices, create logins, create jobs,...

Additionally, if you want the group to be in the db_datareader role for each new database, add the the group as a user and a member of the role in...

Use the undocumented stored procedure msdb.sp_reassign_dtspackageowner.  Look at it in Query Analyzer to see the parameters it expects.  BTW, a package must be owned by a login, rather than a...