March 1, 2019 at 4:20 am
hello All,
the business requirement is that we can get files from various clients in different formats and diffferent column names but need to get loaded into the same table.
So is there a way to use a mapping document like a excel file to map what column name in csv file maps to which column in table and load it accordingly through SSIS.
Thanks
m
March 6, 2019 at 11:52 am
If you can identify the client by either the data in the file, or by the folder from which it came, yes, this can be done. If you expect someone here to do that for you, that's asking far more than what a forum poster should spend time on. The ideal is that something in the filename or the folder it comes from identifies the client, and you can then use a table-driven method that has a row for each client, and a column for each database table column, which then has the client file column name. Alternatively, you can have a staging table for each client, and then run a table-driven dynamic SQL process from that point forward.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply