Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-05-09 : 16:45:01
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-09 : 22:22:19
|
| 1. you can chose the option save package in export import wizard and select option of where to save it ie either in SQL Server or file system. If you choose sql server it can be found at MSDB folder while connecting to Integration services of server. If you're choosing Filesystem you need to browse to local path where you can save it as a .dtsx file.2. If you want to run package again and package is stored in sql server you need to connect to integration services of instance expand MSDB folder and select the package , right click and select Run package from the menuIf package is stored in file system as a .dtsx file, open Business Intelligence Development studio, start a new integration services project. Browse and add package to the project and click execute button on top3.You first need to check if SSIS services is installed and running on server. Go to services.msc from run. check if you've SQL Server Integration Services service present and is running. If its not running start the service. Then open SSMS and try to connect to Integration services. if its running you'll be able to connect------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
ssis 2008 r2