Showing posts with label weekly. Show all posts
Showing posts with label weekly. Show all posts

Wednesday, March 28, 2012

receive files from remote site only if file does not exist in local directory

I need to only receive files via ftp when the file does not exist on my local machine. FIles are being added to the remote location on a weekly basis and they are being downloaded locally. I do not want to download all the files each time. Instead, just download what was not already downloaded. Is there a way to do this? I want to do this using SSIS / ftp task.

Thanks in advance.

One way to accomplish this is to use the Execute Process task to run ftp.exe to get a list of the files on the server, then compare that list to your local directory. You could compare the file lists through a script task. Then FTP each file that you need to pull down.|||Thanks very much. I will try that.

Wednesday, March 21, 2012

rebuild indexes on replicated db

Ive rebuild the Indexes on a Replicated db weekly. However, it makes the Log
Reader Agent blow up with "cannot exec sp_replcmds" error. It doesnt restart
until done manually. Any ideas on how to fix?
SQL2K SP3
TIA, ChrisR
Stop the log reader. Run dbcc reindex. After rebuilding the indexes, restart
the log reader agent.
The problem is that the rebuilding of the indexes is a logged operation and
this interferes with the log reader.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ChrisR" <bla@.noemail.com> wrote in message
news:%23sUKEPM0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Ive rebuild the Indexes on a Replicated db weekly. However, it makes the
> Log
> Reader Agent blow up with "cannot exec sp_replcmds" error. It doesnt
> restart
> until done manually. Any ideas on how to fix?
> --
> SQL2K SP3
> TIA, ChrisR
>