We are provided montly data from ATT wireless in flat files regarding our Cell Phone costs and usage for several hundred users. I have created a simple integration service job to automate the transfer of data into 2 different tables. I have created some external lists in Sharepoint 2010 and also some Reporting service reports based off this data. My problem is my process only covers the current month. Whenever I run the job with the latest files it simply overwrites my existing data. I would like to provide up to 1 year of reports. This data is updated every month with your wireless bill. I am rather new to Integration services and a bit confused if its even possible to create some sort of process that would allow me to automate this process. It seems to me if I start dealing with creating new tables based on each month, or Views that I would end up having to create new reports for each of these as well. Maybe I am simply adressing this whole thing wrong. In summary, I have monthly flat files being provided from ATT dumped into SQL via Integration services. This data is displayed in Sharepoint and Reporting services. Everything works fine however my solution onl allows for the current month since every time I run the Integration service job it overwrites existing tables, etc. My goal is to automate a process similar to what I am doing and store up to a year of data and reuse my existing reports as much as possible. Any ideas or opinions is greatly appreciated.

Check your package. There must be an ExecuteSQL statement that clears the target tables. Remove that table. Make certain that you have some way to identify the record as being from the current month.Russel Loski, MCT

You need to provide more details about the package. Are you using control flow tasks or a data flow? what is you destination and how are you configuring the destination or tasks that loads the data in target? Your goal is clear, but you are not providing enough details about the package(s) to give you specific advise. If I were you, I would load the flat files in a table via data flow. You may need to put some logic in place to load new rows and update changed ones.Help Others! Don't forget to mark your thread as answered

Thanks for the information, I will provide more details tomorrow and am also reading up on integration services to get a better understanding of this.