Yes, that is all that is in the Script Task.

Delete files from a directory.

Andrew SQLDBA

Yes to both

I have given the service account full access permissions to the directory. I can copy into that directory, but I cannot delete from. The directory is on the...

Thanks Lutz

That works perfectly. I have always used SET, which will allow only one value, SELECT allows multiple values.

Another fundamental difference between SET and SELECT is that, you can use...

Yes, I have all of that. There is almost nothing in the event log. I have sent the patch log that is generated, off to Microsoft. They have not gotten...

Phil

That is just what I have done, I am more of an ASP.NET developer. I am using that so that I can place breakpoints and more quickly see the values...

Hey Phil

I think that I may have mis-typed.

I am using two variables minTime and maxTime

minTime = 1:55:00 PM

maxTime = 1:57:00 PM

I am using the time the file was created to...

Hey Phil

Very close. There is another package that fires off at midnight that deletes all files, after copying all of them to an archive directory. This is only for a...

Will not work

The file names change daily.

I want to copy only the files that are created between a certain time of day. Say between 1:30 PM and 2:00 PM

No matter...

Phil

What about instead of the file timestamp of a date and time, I want to use only the time. Is there a way to strip off the date and compare...

Thank you Phil

I just figured it out right after I posted on here.

What luck, I worked on this all day yesterday, and after walking away from this yesterday and looking...

Sorry Dood

That did not work.

I have the file size in the table, I want to compare that file size with the actual file. Just something that I would like to...

I believe that the SQL jobs stores 254 rows of history.

Check to make sure that the job has not fired off only two times. And also that someone has not...

Thanks Everyone

That code does the trick

I missed the last numeral 1

That was totally throwing me for a loop

Andrew SQLDBA

OK, how about the opposite:

I would like to keep the path and do away with the file name:

I would like to have this returned:

Thanks

Andrew SQLDBA

Perfect

Thank you

I did not think about using 'Reverse' that is what was holding me up, and mine was not working.

Thanks again

Andrew SQLDBA