mercredi 25 février 2015

SSIS One package VS Many packages To load Excel Files

I want to accomplish a project, I have different DB (same server) for each of my customers. I have to load an excel file (7 sheets) every month. (Every new month I get new excel file for each customer) The table in db's are similar to the table in excel sheets by name and columns.


What is the best way to do this kind of project? Do I have to create package for each customer or it's possible to do that with one package for all of the customers (for now, the table names , columns and number are the same for all of my customers but it can be changed if necessary in the future )


I think the better way is to make for each customer his own package with his own connection for the db.


But do I have to make every time new connection to new excel file that I got or is any other way?


I will pinpoint my project, I have for each customer a DB with 7 tables (all in the same server) and every month I get new excel file CustmoerName_MonthName.xls with 7 sheets (for now, maybe in the future and it can be more tables for one or more customers) If I'm going to use one package how does it will work if the excel file name change everytime And I have different path of the excel files for each customer? Also when I load a excel file its need to be recognize witch customer it is and load it to his own db I don’t get the excel files from the customer in the same day or week for one customer it can be at the beginning of the month and other at the end of the month, I execute the package not in normal schedule like once a week or so.


Aucun commentaire:

Enregistrer un commentaire