In sql server 2012, I want to take input from a user and load the data into a temp table. I then want to update several production tables with the data that has been supplied by the user.
Since this is my first time creating an SSIS, I have the following questions to ask you:
The user wants to be able to enter the data in a Word document. Is that possible? If not, should I ask them to load the data into an excel spreadsheet so it is easier to obtain the data?
To create the SSIS package, should I use the import wizard in sql server and save the package somehow? How would I save the package so that it can be executed again? If I do not use the import wizard, what do you suggest that I do?
Who you show me with pictures and/or explain to me, and/or point me to a link (url) that will tell me how to accomplish this goal?