May 9, 2012 at 2:43 pm
I have been using the import and export features of sql server 2008 r2 every time I need to load and/or extract data from the database.
However, I am wondering if you can tell me the following:
1. How do you save the SSIS package that you just executed and where is the package saved to?
2. Once you want to run the SSIS package, how do you execugte the package you saved?
3. Also if SSIS is not working on sql server 2008 r2 database that I have access to, what do I need to do get get ssis running on the database?
May 9, 2012 at 4:27 pm
In the wizard there is a checkbox for saving it or not. Yo then have to choose between saving it in SQL Server or the file system. If you choose the file system, you are prompted for a location. You should be able to right-click on the package in the file system and open it with the Package Execution Utility.
May 10, 2012 at 12:07 am
Regarding point 3: open the package using BIDS (Business Intelligence Development Studio), run it and see where it fails. Fix it 🙂
This is only possible if you don't use Express to create the SSIS package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply