June 29, 2016 at 4:18 pm
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:
1. 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?
2. 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?
June 30, 2016 at 2:02 am
Technically you can import from word - I've never done it but this link suggests it is possible: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e7987d8c-4f90-4ce1-9ba6-e3460b01248c/is-it-possible-to-extract-data-from-microsoft-word-docx-from-ssis?forum=sqlintegrationservices
Excel is a much more common source for User inputs.
If this is your first SSIS package then using the wizard would be a good starting point. You can save the created package (and there there several different options such as project deployment vs package deployment) and then execute it from SQL Agent. If there are already SSIS packages used in your organisation then follow that model otherwise come back for some suggestions.
Jez
June 30, 2016 at 10:53 am
Its interesting to learn that SSIS can process Word docs.
Thanks for the info.
July 1, 2016 at 1:31 am
Have a look at this:
I've not tried it and it looks just as problematic as importing from Excel.
Jez
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply