July 16, 2015 at 9:54 am
I used the import wizard in sql server 2012 management studio to load data from an excel 2013 spreadsheet into a new table in a sql server 2012 database. I saved the package to the file system since I want to be able to rerun the package and potentially change where the excel spreadsheet is obtain from when I use this code in production.
Thus I have the following questions about executing the package I saved to the file system:
1. Can you give me directions on how I can execute the package that I saved to the file system? I tried doubling clicking on the dtsx package and that did not work.
2. If I want to change any of the input and/or output locations, is this possible? If so, can you tell me how I can change the file system package? Do I need to open the package in ssis manager or in visual studio?
July 29, 2015 at 7:11 am
Hi,
1. You should have BIDS/Sql Server Data tools installed in your machine to open the package in Execute Package Utility.
2. From Execute Package utility, you should be able to change parameters, I haven't tried this.
Regards,
Vijay
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply