I am not too savy with SSIS packages. I just know the basics.
What i need is to have a package execute a query that will determine if i need to
1. get/capture the file name located in a table. i then will need to delete that data from the table (could be multiple filenames that will need to be captured)
2. and find that filename with a .xml extention in a directory and move it to another directory location renaming the extention of that filename.
i already have a database connection set up
i am using MS VS 2008 / VB Script
can some one help with this?