Loading files from different sources into one database table

[Ulianna]

Hi,i am very very new to ssis i woould like to load different files from different sources (csv and excel files) and load them all into one table,i need to use scd 1 and scd 2 in the different tables.

 

[johnherman]

if you post this question in the SSIS forum (Tek Tips calls it Microsoft SQL Server: Data Transformation Services which is an older name), you will probably get better results.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity