You can use dynamic sql:

Declare   @Tbl_Name varchar(200)

Declare   @sql varchar(200)

Set @Tbl_Name = 'YourTable'

set @sql = 'Select * From '+@Tbl_Name

exec(@SQL)

If you saved it to the sql server and have backups of the msdb database you could restore this base onto another dummy instance and then open the package and...

Microsoft has a a tool that does this already:

http://support.microsoft.com/default.aspx?scid=kb;en-us;271509

You look at the output using a ms tool called sherlok:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49847

This can be scheduled and the output is easy to...

Are you seeing the leading zeros missing when viewing in excel, or are they actualy missing if you open the csv in a text editor. Just guessing but excel maybe...

This should give you what you need, just need to doctor the script to insert into a reporting table, use a where clause on the insert where last run date...

you could pull all the file names into a temp table by calling the dos command dir through xp_cmdshell, after you have the file name in the table set up...

I would have a look at this article:

http://support.microsoft.com/kb/250367

Don't know how your dmz is set up, but I would talk to your network guys and see if they can open up a port for you.

Have a look at http://vyaskn.tripod.com/repl_ans2.htm#nosync

He describes the creation of these sp and how they are created

Have a look at sp_attach_single_file_db in bol, don't know if you will have issues running this against 2005 from a 2000 mdf you may want to try and attach first...

look up isnull function in bol.

This article has a function and examples of how to check for file status, you could modify the checking script and put that into an additional sql task and have...

If the file you are restoring from is on a different machine use the unc path:

\\servername\foldername\filename.extension

You can test to see if the server you are restoring to can see...

Thanks, I will take a look.

on the left of the design page is the connection objects, choose a sql connection object and update the details with the server you want to connect to.