This works as well. http://www.sqlservercentral.com/scripts/Administration/62729/

I gave up on xp_delete_file.

Elliott W (4/21/2010)

---

RS allows you to connect to those servers directly and in most cases I would suggest you do. Linked servers usually incur a performance penalty especially on...

If you can query the system tables then this is clearly the best method but I have no idea if this is possible.

See this as an alternate method.

http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm

If...

The SQLCMD utility could be a solution.

On your source instance create a linked server to you archive instance. Then reference your linked server in the insert statements.

Thank you gentlemen, I learned something new today. Much preferrable to the date calculation method.

A linked server could work.

http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/

or you could use SSIS. Run the import wizard from management studio, configure and save your package, schedule your package.

Use IF...ELSE

http://msdn.microsoft.com/en-us/library/ms182717(SQL.90).aspx

My month end check is a little different

declare @currentdate char(8)

declare @lastmonthdate char(8)

SET @currentdate = (SELECT convert(char(8), getdate(), 112))

SET @lastmonthdate = (SELECT convert(char(8),DATEADD(dd, -DAY(DATEADD(m,1,getdate())), DATEADD(m,1,getdate())), 112))

PRINT @currentdate

PRINT...

eConnect is the accepted GP mechanism for importing data. Good luck.

I would check with GP and see if this is supported. Some systems especially accounting systems don't support direct updating of the database and you may damage data integrity.

They may...

I think this is the main problem: the database desing comes after processes and data-flow analysis, that can have been done poorly. A perfect database design based on a poor...

Why destroy information which may be useful, that is the timestamp?

Change your restore script to dynamically set the fname of the file to be restored.

http://blog.tech-cats.com/2007/10/sql-server-script-to-restore-database.html

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/66372/

I would review security best practices. Search 'sql server security best practices'.

If the question is "How do you insure the security of the server?" your answer could be "by following...

Is there anti-virus on this drive?

If you are using the Import/Export wizard I believe you can still save the package at the end of the process even though its failing. Then open the package in...