Copy a database

[strtech]

I have a SSIS package that is importing thousands of records into a Microsoft Access database. I would like to include backing up the database or at least getting a copy of the affected tables before the import tasks execute.

Is there a way to accomplish this since the Backup Database Task isn't available?

 

[mrdenny]

If you have the permissions to back up the database, you'll want to just use the BACKUP DATABASE command to backup the database.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog