possibly not working because , the sql server agent dont have the rights.!

or,, if ur folder path is of network then it will not work under current authentication. for this...

I think, nobody check this question before post on SSC. This question is completely wrong.

Still i didn't believe that this question is posted by "Steve Jones - SSC Editor". w00t...

+1.

+1

MarkusB (9/6/2013)

---

That part is a bit more tricky. Do the filenames contain a date or do you need to get it from the file attributes?

I would say using a script...

patel.ritesh.r (9/3/2013)

---

Hello,

I am new to SSIS. Can anyone help me provide solution for below mentioned scenario…

I want to transfer data from Excel file to SQL server table based on the...

Thanks for acknowledging my problem.

In a nutshell, i want a Script for my script task that delete all files from the...

MarkusB (9/6/2013)

---

I hope I get it right now.

Create your package with two "file system tasks" connect them with an "on success" connection.

Then define a variable "sourcepath" and change the sourceconnection...

MarkusB (9/6/2013)

---

Not sure I understand what you want. Do you want to make then file and\or path configurable? The use SSIS variables.

Or do you need to move the package to...

That i know, but an architecture with idea of how to make it configurable will be a help.

i.e. package is in working condition while moving from one machine to...

Thank you Mr. Chris

The query is JUST PERFECT.

Thanks a TON. 🙂

This is exactly what i want,,, i.e. back up file to go in E: drive and in Reports file.

And the script you provided will fail. stating,, "Its directory not found."

Thank You Mr. Perry Whittle,, Thanks A LOT

Perry Whittle (7/16/2013)

---

Mr. Kapsicum (7/15/2013)

---

some Developer takes a full backup of the database in an emergency or any situation,, then in that case,,, the Monday differential backup will be of...

easy one...!!! 🙂