I am not expert in SSIS and that is why I am planning to import CSV files in Staging tables and then transform them into final tables. I would like to know strategy to limit number of CSV files from data sorces. My question is about populating dimension tables. Instead of bringing separate CSV file to populate dimension table, can I bring the same information in CSV file (with other information) which will be populating staging tables. For example, if I have CSV file with transaction no, Item No, Item desc, Qty Sold, Discount, Cost etc fields, Can I import this file in staging table and then will populate Item Dimension table and then I will populate FACT table. What are other methods to populate Dimension tables (My objective is to bring least no of files from DataSource)?

Your general methodology sounds good: For each CSV source file, load the data into a staging table. From there update your Dimension table using a MERGE statement in T-SQL, matching on the natural or business key. Next, load the data from the staging table into the FACT table, and lookup the appropriate Dimension Keys from the Dimension tables in the SSIS Package.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.