I have installed SQL SERVER 2008 R2 on one PC. When I created a Package in BIDS and run it in debug mode it works perfectly. When I run it in "Start without Debugging" I get an error in the command window which says ""To run a SSIS Package outside of BIDS you must install Standard Edition of Integration Services or higher".
Does anyone have any idea why I can't run this outside of BIDS?
Which version/edition of SQL Server do you have? And are you using the Data Mining Query Task or one of the following transformations?
- Data Mining Training Destination
- Data Mining Query Component
- Fuzzy Grouping
- Fuzzy Lookup
- Term Extraction
- Term Lookup
- Dimension Processing Destination
- Partition Processing Destination
Thanks for your reply.
The Version is SQL SERVER 2008 R2 and I am not using any of the tasks which you listed. Any other ideas? This is really causing me problems trying to deploy this. Thanks for the help!
SQL SERVER 10.50.1600
- Edited by EMKISER Monday, July 01, 2013 2:02 PM change
Your database Version may be SQL Server 2008 R2, but there is also an "Edition". You can see your edition by selecting the properties of your server in the Object Explorer treeview of the SQL Server Management Studio. In the Server Properties window, look at the "Product" line. It will say something like "Standard Edition" or "Express Edition".
If you are using "Express Edition", you're out of luck. Look up the "Integration Services" section of the supported features for SQL Server 2008 R2. The Express Editions won't do what you need because they want to sell you a more expensive edition.
In the Properties box it says
Microsoft SQL SERVER Developer Edition (64bit) (It comes from our MSDN subscription)
When I do the Select @@version it says
Microsoft SQL SERVER 2008 R2 (RTM) 10.50.1600 1 (x64) April 2, 2010
- Edited by EMKISER Monday, July 01, 2013 3:52 PM change
Ah, I recognize that one. Developer Edition will let you do this, the edition is not the problem. The problem is you're not actually running it on the server. Instead, it's trying to run it locally. You likely have Visual Studio and a stub edition of SQL Server Express locally, and that's what is failing.
You need to schedule this as a Job through SQL Server Agent on the server. To do this, you will need to go through package deployment and configuration. This is unfortunately necessary.