how to move files that will be created at run time using file system task

I want to move a file from a folder which will be empty at the beginning of the package but the data flow task will create a flat file in it and the File system Task willl execute after the data flow task . It has to move that file which was created by the dataflow task during the package execution to a new folder where there may or may not be files.

When we are configuring the file system task to move files, we have to initially provide the file that u want to move and the destination file too. In my case these files dont exist at the time of package creation but are rather created at run time.

My question is how can make File System work in this case as I am not able to provide source and destination files in the File System Task at the time of package creation as these files dont exist at that time but are created when this package is run

I dont want to use Sript task as I am not very familiar with Scripting.

Any other ideas??

Any Help will be greatly appreciated.
esotericmeeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Reza RadConsultant, TrainerCommented:
use variable for file system task
you can set variable with file name that generated dynamically, and file system task will use variable and find the correct file.

let me know if you need more details.
0
esotericmeeAuthor Commented:
Yeah but would be the variable value initially? I am just beginning working with SSIS so it takes time for me to understand this..But i appreciate your help.. I need like more detailed ans if possible.. Thanks a lot
0
Reza RadConsultant, TrainerCommented:
yes you must set default value for variable to a valid file path, this is default value and doesn't use in runtime, but SSIS needs this default value for checking validation in design time of package,

double click on your file system task, you will see this property : IsSourcePathVariable  , set it to true, then you can set variable in SourceVariable property,
your variable must be string datatype, and it's better to be in package scope,

after dataflow, add a Script task, and set variable value there.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
esotericmeeAuthor Commented:
IT worked
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.