September 22, 2014 at 9:12 am
Hello All
I am running a Data migration project for an ERP Implementation. I have around 100 – 150 sql tables I need to populate. These are a mixture of parameters, codes and master data items.
The data for these tables will be provided via an excel file for each table.
Some of these will be filled in by business analysts, some by the business we are doing the implementation for.
What I would like to do is create an SSIS job which reads the data from each of the excel files and loads it in to the appropriate Sql table. Pretty straight forward and I have got this working for a few already.
My question is whether or not there is an easier way to do this? My concern is that by the time I am done, I will have created a large number of data flow tasks, split out over a large amount of packages and it just doesn’t seem right to me.
I want to be able to run this process lots of times as the excel data has the potential to change and we will also be running the data for CRPs and also go live and I want it to be 100% repeatable.
I appreciate any feedback or suggestions.
Many thanks
David
September 22, 2014 at 9:18 am
Don't know if SSIS is the best choice, but I would be my preferred choice.
SSIS gives you lots of options to do want you want, and it's graphical interface often makes it easier to manage.
That's my 3 cents worth on the subject.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2014 at 10:01 am
September 22, 2014 at 10:10 am
Steve Jones - SSC Editor (9/22/2014)
Biml
BIML = Biml I Must Learn 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply