Do you have standard SQL Server backups running and are the backups being moved off the machine and offsite? Even if you have virtual servers, server image backup/restore, clusters, mirroring,...

If a drive fails you would need to replace the drive and rebuild your raid array using the RAID console.

Can you delete or move the files after you download them? Then you would just have the new files to download.

Otherwise it sounds like you would need scripting or run...

See this for some ideas. Scripting sounds like it would give you the most control.

http://social.msdn.microsoft.com/Forums/en-SG/sqlintegrationservices/thread/c025bb49-6c6d-4a4b-ada0-5c8966189cd4

You could probably call your package multiple times using DTEXEC passing it a variable...

I suspect any differences would be minor if they exist at all. If you run...

http://www.mssqltips.com/tip.asp?tip=1641

Did you try seaching the internet?

Strange.

Any difference if you move higher up in the path?

\\bhdata1\qlextlivi4.csv

Any shares in the path?

stebennettsjb (6/10/2011)

---

So im trying get an inventory of all the SQL boxs out there and im finding lots of Express edition 2005/2008 out there. Do you do anything to these...

http://msdn.microsoft.com/en-us/library/ms143736.aspx

Thanks Phil,

Option 1 seems possible. It would be a little more complicated than it seems since i was hoping to also dynamically create worksheets. I may go done this road...

I hoping to generate scripts which I could run on a different server so I'll need sp_help_revlogin. I may look at SSIS or maybe return back to my adventures with...

Can anyone provide specifics on using BCP through SQL Agent?

I have a 'Operating system (CmdExec)' step set up with the following command.

bcp master.dbo.sp_help_revlogin out c:\test.txt -n -SMYSERVER\MYINSTANCE -T

I am getting...

I ended up modifying the procedure uspCientfavoriteLists to accept one parameters @client instead of 2, @client and @ListType.

I am then filtering the returned results at the tablix level. ListType...

Doesn't BCP require xp_cmdshell to call it?

I'm running into this issue when I try to edit a job with a powershell step.

http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps

I thinks this is unrelated to the powershell script.

This works from the ps...