thank you for these two links. I need to learn it all because it became part of my job :-D I had a 3days training for the SSAS part of the BI. Then, my boss though it could be interresting for me to have a look on ssis too. And few days later I was promoted to ssis guy, and I'm receiving several txt and xls files from our italian retailers (each one with a different structure). Files I have to put in a cube. The different books I found are in my opinion too much based on the description of what's in SSIS, and not enough on "how to do it". On a youtube video I found how to build my first basic data flow but I need to know more about that . So once more, thank you for your comments.
We are here to offer any support with T-SQL and SSIS. Please post us any issue and we will get back to you.
How many files and how many different formats?
Do you have any control over the format of what they give you?
The goal would be for all of them to share the smae format (or have the same format from period to period) and automate the load to staging tables, audit the data (you should have them give you some form of header/trailer or audit file), pewrfomr data integrity checks..
hello again ! there are about 16files per weeks. I have very few control over the format (txt, xls or xlsx) it would be perfect to get them use the same structure, thus we sent them a "model". We'll see in the next days if we have been heard.