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 |
|
Horn300
Starting Member
8 Posts |
 Posted - 2012-09-26 : 12:23:01
|
| Hi,we installed version "Standard".I dont know how to modify an SSIS-Package, can't find Visual Studio.Is the Visual Studio-Application not included in Standard-license?With regardsMatze |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-26 : 13:30:14
|
| It is SQL Server Data Tools under the SQL Server 2012 program group. If you don't have it download it here: http://msdn.microsoft.com/en-us/data/tools.aspx |
 |
|
|
Horn300
Starting Member
8 Posts |
Posted - 2012-09-27 : 05:06:27
|
| Thanks a lot.I made a SSIS-package with import wizard in the SQL Management Studio and saved it on the database, not file system.After connection to integration services, the package is listed below saved packages\MSDB.Then I opend Visual Studio in order to edit this package and connected in Server-Explorer to the database.Can't find the package.Am I right here with this question? |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-27 : 07:35:05
|
| I have not done it that way. When you connect to the server explorer, you are connecting to the database engine, not SSIS. If you right click on the SSIS packages node in the solution explorer and select "Add Existing Package" and follow through, you will find the stored package. |
|
|
|
Horn300
Starting Member
8 Posts |
Posted - 2012-09-27 : 08:36:01
|
| Thank you very much. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-27 : 09:13:45
|
| You are very welcome - glad I could be of help :) |
|
|
|
|
|
|
SQL 2012 and Visual Studio