tags:

views:

284

answers:

1
Q: 

How To Use Business Intelligence Development Studio On Remote SQL Server

Hi, all

Is that possible for BIDS to build a SSIS package on remote SQL Server instance? Since I only have SQL Server Standard Edition on the production server.

BTW, when I use BIDS to build a Integration Service Connection Project, it throws a exception like this: exception of type 'System.Exception' was thrown And nothing is created. Anyone have ideas on this?

A: 

Install SSIS on the client.

Oliver Townshend  2010-01-12 08:56:51
So the client still need license for Standard/Enterprise/Develop Edition?
Roy  2010-01-12 09:08:32
You can develop with the Developer version, but to deploy with proper licensing, you'll need Enterprise.
Oliver Townshend  2010-01-13 09:49:11
You might find this thread useful (or confusing). Apparently there are some situations where you can use standard. http://social.msdn.microsoft.com/Forums/en-SG/sqlintegrationservices/thread/6ce7599a-930d-47a9-8fd6-358bf9ed9ef2
Oliver Townshend  2010-01-13 09:50:23

related questions

In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?
Advantages of MS SQL Server 2008 over MS SQL Server 2005?
SqlDataReader.HasRows returns false since SQL 2008 upgrade
How do I set the login info for SQL Server 2008 in Entity Framework?
Move SSIS Packages from SQL Server 2005 to 2008.
Installation problem sql server 2008
How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?
How to use DataMining feature of SQL Server 2008 with ASP.Net
SSAS Cube Browsing not working after SQL 2008 CTP uninstall
Hooking up Reporting Services 2005SP2 to SQL Server 2008
New Date/Time data types in SQL 2008
Can SQLExpress 2005 and 2008 be installed on same machine without issue?
Any reason to have SQL Server 2005 and 2008 installed on same machine?
Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008
How do I get the full name of the current user from a SQL Reporting Services 2008 report?
How do I fix a Cross language installation problem in SQL Server 2008?
Upgrade MSDE to SQL Server 2008
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
SQL Server 2008 Reporting Services Report Definition Customization Extensions
Moving SQL2005 app to SQL2008
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Can I use SQL Server Management Studio 2005 for 2008 DB?
SQL 2008 Dialect Support for NHibernate
SQL Server 2008 vs 2005 Linq integration
SQL Server 2005 and 2008 on same developer machine?