SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL 2012 and Visual Studio
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Horn300
Starting Member

Germany
8 Posts

Posted - 09/26/2012 :  12:23:01  Show Profile  Reply with Quote
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 regards
Matze

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/26/2012 :  13:30:14  Show Profile  Reply with Quote
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
Go to Top of Page

Horn300
Starting Member

Germany
8 Posts

Posted - 09/27/2012 :  05:06:27  Show Profile  Reply with Quote
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?
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/27/2012 :  07:35:05  Show Profile  Reply with Quote
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.
Go to Top of Page

Horn300
Starting Member

Germany
8 Posts

Posted - 09/27/2012 :  08:36:01  Show Profile  Reply with Quote
Thank you very much.
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/27/2012 :  09:13:45  Show Profile  Reply with Quote
You are very welcome - glad I could be of help :)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000