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

Mark A Matte markamatte at hotmail.com
Tue Jan 22 10:15:43 CST 2008


Thanks,

I think thats what has happened.  MS Visual Web Developer Express did install SQL Server 2005, but not the GUI....I think???  I'm goinmg to try the instal of SQL Management  below.

Thanks,

Mark A. Matte


> From: tomlough at eircom.net
> To: dba-sqlserver at databaseadvisors.com
> Date: Mon, 21 Jan 2008 08:07:28 +0000
> Subject: Re: [dba-SQLServer] SSIS, SQL Server Integration Services, DTS
>
> 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
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>

_________________________________________________________________
Need to know the score, the latest news, or you need your Hotmail®-get your "fix".
http://www.msnmobilefix.com/Default.aspx



More information about the dba-SQLServer mailing list