August 7, 2013 at 9:49 am
Hi all,
New to complex SSIS and have a requirement but I'm not sure if SSIS is the tool for the job.
I'm looking to combine several tables into a single data load table using SSIS. The tables are built by some software that I wrote and are created during a data processing stage. Each of the tables will be in a different format and represent a different load file but all will contain various key fields that will need to be extracted, cleansed and then placed in another table. The various key fields may not have static names (e.g. 'payment' in one table and 'pymnt' in another) so will need to be mapped to the destination table if possible.
As I've not used SSIS a great deal (I've used SQL Server for over 10 years in various dev roles) I was wondering if anyone could give me any pointers in terms of direction or even if SSIS is actually the right tool for the job ?
I can use either 2008R2 or 2012.
Many thanks in advance
August 7, 2013 at 10:27 am
How many files are we talking?
if its less than say 20 its probably still pretty easy to use SSIS.
2008/2012 in this case is about the same..
CEWII
August 8, 2013 at 2:14 am
There will probably be around 20 a day.
Currently I'm looking at wrapping BCP commands ? The client wants to build a 'customer take on' process and what I'm thinking is a bulk copy from the input format to the holding tables before load into their alpha based systems.
I guess I'm looking for the quickest path to that solution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply