[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