August 29, 2011 at 9:24 am
Hi Guys,
We have SQL 2008 and do not have Visual Studio 2005 0r 2008 installed in our servers... to create packages and execute in our production environments, do we need to install Visual Studio 2008 or 2005 in the server as well? Or we have to install in our desktops only?
How does it work guys.. please suggest...
Thanks,
Laura.
August 29, 2011 at 9:43 am
To create/edit/deploy SSIS packages you will need to have BIDS (Business Intelligence ..etc) installed on the machines you wish to develop on. From there you can build and test your packages. However in order to deploy them to a real server (and see them run), you will need to have SSIS installed and running on the actual target SQL server(s), and have the SQL Agent Service running as well.
Once your packages are deployed you can use the SQL Agent to create a new job...which will then execute your package
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2011 at 9:44 am
thank u jessie for your response. Need to confirm couple of things.. sorry I am new to this...
To create/edit/deploy SSIS packages you will need to have BIDS (Business Intelligence ..etc) installed on the machines you wish to develop on.
From there you can build and test your packages. --I have Visual Studio 2010 I will have to install 2008 as well as 2010 doesnt have BIDS.
However in order to deploy them to a real server (and see them run), you will need to have SSIS installed and running on the actual target SQL server(s), and have the SQL Agent Service running as well. --We do not need to install Visual Studio in the server? I can see Integration Services installed in the server and I can see Execute Package Utility.... Is that enough?
Once your packages are deployed you can use the SQL Agent to create a new job...which will then execute your package
August 29, 2011 at 10:32 am
You should have the Microsoft SQL Server Business Intelligence Development Studio already installed (if you have the Client and Connectivity Tools installed on your machine from when you installed SQL Server). If you don't you can simply rerun the SQL Server 2008 install on your machine and choose it from the list of options. If that's not an option, download it from MS (I believe it's free...and the Express version will work fine too)
No, VS doesn't need to be installed on the target SQL Server. It ONLY needs to be there if you plan on building/debugging packages on the server itself (which I don't reccomend).
If SSIS is already installed on the target SQL Server, you should be good to go.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2011 at 10:51 am
thanks Jessie... In my desktop, I have SQL 2008 R2 installed and I can see Integration Services in the menu (it has Data Profiler View and Execute Package Utility). I have Visual Studio 2010 installed and I have asked the network guys to install VS 2008 in my desktop.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply