Paul Sheriff's Inner Circle

I want to write a utility to delete files from folders on multiple servers that are more than x days.  I plan on storing the folder information (UNC folder name, number of days old and whether to delete from subfolders) in a database table.  I would like the program to be a service that actually executes once a day.  My questions are on authorization and scheduling.  If the service is running on severx, it needs to be able to delete files on serverx, servery, etc.  What's the best way to setup the authorization?  Run the service under some type of administrative account?  What's the best way of getting the service to only perform the delete action once a day?  Say 2AM.

Thanks!! 

I needed to upload files to another site and was able to do that without much problem using the System.Net.WebRequest class.  The site I have to upload to has changed to SFTP using SSH2.  I can't find anything in the .Net 2.0 Framework that supports SFTP.  Am I just missing it?  I looked for free and open source .Net components that implement SFTP but I can't find any.  Do you know of 1 or do you have any code that implements SFTP to upload a file?

Thanks!!

I need to create a process that runs a number of stroed procedures in sequence then execute several SQLServer 2005 SSIS packages that export the tables to delimited text files.  I was thinking of creating a service that runs on the same box as the SQLServer instance.  This service would execute the stored procs using ADO.Net and execute the SSIS packages.

Is executing SSIS packages through a service possible or advisable?  Is there a better way to create an integrated process (executing both the stored procs and SSIS packages)?

Thanks!! 

I have a toolstripprogressbar that I active when the user clicks a button.  The process contains several long running stored procedures.  While the stored procedures are running, the progressbar is not being updated because it running on the same thread as the main form, I believe.  I guess the solution would be to create a separate timer using System.Threading.Timer when the button is clicked and dispose of it when the process is done.

Does that sound right?  Do you have a sample of something like this?

I need to create a .csv file from a SQL query.  What I have done is retrieve the data into a datareader.  For each row in the reader, I get the data for each field (e.g. reader("fieldname").ToString, place quotes around it and add a comma to the end.  I use a stringbuilder to concatenate the fields.  Once all the fields are concatentated, I use a streamwriter to write the stringbuilder to a file.

There has to be a better way!!  Have any better ideas?

Thanks!!

Has anyone ran in to this problem

 invalid digital signature installing vs2008 pro

Hi Paul,

Any thought to having an InnerCircle get together at Tech-Ed in Orlando this June?

Until Later...Mike