Menu
Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go into job scheduler, either.
637
The SSIS package is stored in the file system as XML files. If you need to schedule this, you can simply create a SQL Server agent job and point your (package). dtsx and a config file if you have one. But, it cannot be managed from the Management Studio environment if that is what you are asking.
1 Open SQL Server Management Studio, and select the Server on which the SSIS package you want to edit is stored. 2 Expand the Data Transformation Services folder, so that you can see the SSIS packages. 3 Double-click the SSIS package you want to edit. 4 Double-click the line connecting Connection 1 and Connection 2.
When you start SSMS, it allows you to choose a Server Type and Server Name. In the server type dropdown, choose "Integration Services" and connect to the server.
Then you'll be able to see what packages are in the db.
108
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
