April 17, 2008 at 4:58 pm
I found a server in my organization with MS SQL Server 2005 Enterprise Edition installed on it. I like to import Excel to a SQL Server database. However, the SQL Server Integrated Services does not seem to be installed. Can't find the short-cut to launch it. How do I tell if its installed?
April 25, 2008 at 3:36 am
You develop SSIS packages within Visual Studio / BIDS (Business Intelligence Development Studio)
So you need to open either of those 2 programs and under new project, select integration services package - BIDS should be on your SQL 2005 machine as long as the tools were installed when the server was set up.
SSIS is a service, so if you need to check if its running, go to your services and check - it will be listed as SQL Server Integration Services - you may need to start it.
Kind Regards, Will
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply