[dba-SQLServer] SSIS, SQL Server Integration Services, DTS

Hi Tom

Thanks. 
By second thought, I remember having installed the SQL Server 2005 Express editon as well. Perhaps that is from where the manager origins.

/gustav

>>> tomlough at eircom.net 21-01-2008 09:07:28 >>>
Gustav,

AFAIK, the Express version of SQL doesn't come with the GUI management
tools. The configuration manager is used primarily for security &
configuration, e.g. active protocols, services, etc.
You can download the version of Sql Management studio from :
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D- 
94B8-5A0F62BF7796&displaylang=en
but this isn't typically included in the VWD install

Tom

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com 
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: 21 January 2008 07:50
To: dba-sqlserver at databaseadvisors.com 
Subject: Re: [dba-SQLServer] SSIS, SQL Server Integration Services, DTS

Hi Mark

I'm no expert in SQL Server and I have no running installations of version 7
(except the MSDE which came without administration tools).
To me it looks like you do have SQL Server 2005 Express installed from the
MS Visual Web Developer Express. The "SQL Server Configuration Manager"
should be located under "Configuration Tools" under your Start menu entry
"Microsoft SQL Server 2005".

/gustav

>>> markamatte at hotmail.com 18-01-2008 21:17:25 >>>

Gustav,

In reading your last post mentioning "SQL Server Configuration
Manager"...below is my other post concerning this.  I'm at a point where I'm
not sure what I have installed?

************I currently use SQL Server 7. I installed MS Visual Web
Developer Express...and it added a folder MS SQL Server 2005. In the Folder
under "Configuration Tools" it has SQL Server Configuration Manager...which
I have no idea what it is. There doesn't seem to be a place to manage
tables/SPs. Is the folder misleading or does this mean SQL Server 2005 has
been installed? SQL7 and Enterprise Manager still seem to be working
properly.

Any thoughts? 
Thanks, 

Mark A. Matte


> Date: Fri, 18 Jan 2008 19:14:10 +0100
> From: Gustav at cactus.dk 
> To: dba-sqlserver at databaseadvisors.com 
> Subject: Re: [dba-SQLServer] SSIS, SQL Server Integration Services, DTS
>
> Hi Arthur and Robert
>
> Just realised what the SQL Server Configuration Manager is for ...
> It showed that I have two SQL 2005 Servers installed locally, SQLEXPRESS and MSSQLSERVER. Of these, the first is the Express edition I guess (from a previous install of Visual Studio 2005 Express) and the second must be the developer version installed with VS2005 Standard.
>
> The second wasn't running. I started it and somewhere I noticed a tip to create a DTS package: Run DTSWizard from Start Menu, Run.
> That wizard connected happily to a server and offered to save and run the created SSIS package ... OK, and yes it did. Success!
>
> Now I need to find out how to get to that saved package ...
>
> /gustav