When you find out that a lender's import had bad data, do you have to back out all the data that was imported from that file or only specific rows? ...

So, you want the job to think that the package succeeded. 

Okay, try this.  Open the package, then look at the Logging tab on Package Properties.  Make sure "Fail package on...

Two packages aren't necessary.  We run a script in Query Analyzer to generate ALTER TABLE DROP CONTRAINT and ALTER TABLE ADD CONSTRAINT statements, in the correct order, for a database, then...

You could change the workflow from the Execute SQL task to "on completion" rather than "on success".  Then the folowing tasks would execute whether the stored procedure succeeded or not.

Greg

Do the tables already exist in the destination databases?  The trick is to copy the tables in the correct order i.e. the referenced tables, then the referencing tables.  I've had...

There are lots of ways to move packages and how much work you have to do depends on how the packages are written.

To move the packages to a new server...

Paul,

Not sure what you mean by "incremental" backup.  A differential backup will backup the part of the database that has changed since the last full backup.

Greg

Did you close the session that you used to change the database to single user mode?  If you didn't, it's using the one allowed connection.

Greg

That option only works if the destination is a SQL Server table.  I'm not familiar with retaining nulls in a text file.  I'll have to research a bit.  Maybe someone...

Make sure that the domain account that SQL Server Agent runs as has write permission for the shares where the text file and Access database are located.

Have the user who selected the data into the temp table run this statement:

SELECT temp.*

INTO newtable

FROM temp

newtable is the name of the table that was dropped.

Greg

This article by Brian Knight may help.  See the "Permission" secton at the end of the article.

http://www.sqlservercentral.com/columnists/bkelley/services.asp

Greg

Thomas,

You may have to script out the CREATE VIEW statements from Access and run them on SQL Server to create the views.  I only have Access 97, which doesn't allow...

Tom,

This is from the same page in BoL that you quoted:

Permissions

BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner...

What are the source and destination in the package?  Is one of them a flat file on a network share?  If so, does the domain account that starts SQL Server...