Our server currently has the following components installed for SQL Server 2005: 1. SQL Server Management Studio Express and 2. Configuration Tools (SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server Service Area Configuration).
Is there a way to setup a package using the software currently installed (if not, what needs to be installed in order to setup a package)?
I'm looking to schedule running an executible, it was fairly easy with SQL Server 2000 (using DTS), but I'm unsure how to set this up using the software we currently have installed.
It looks like you are using SQL Sever 2005 express?
Sorry but SSIS doesn't come with express, you'll need Standard edition or better:
see the section, "Integration and Interoperability":
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
|||P.S. Installing standard edition tools seems to do the trick (be sure to install Integration Services).
No comments:
Post a Comment