Hi Experts, I had a Question.Theres a remote server which spits out 3 text files and 3 csv files on to a shared drive every day and all the file names will have a name and date like "textA02/12/2009", "csvA02/12/2009" and files for the last 30 days will be stored in this shared drive. Now I have to create an SSIS Package to fetch the file for that day from the shared drive and loadsit into the concerned table in the database every day.
this has to happen daily. there are no data manipulations involved in this and the data from these files has to be loaded into the data base AS it was in the Textfile. My first problem is creating the package and the second problem is Scheduling the package to run every day. Can any one give a solution to this. Its very urgent to me..Even a small help is very much appreciated.. Thanks in Advance