Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From: rja.carnegie@gmail.com
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Issue with importing Access db into a SQL Server 2000 or Express
Date: Mon, 20 Aug 2012 04:13:20 -0700 (PDT)
Organization: http://groups.google.com
Lines: 19
Message-ID: <6d507f46-5c6f-4e52-a91c-6c348fce94dc@googlegroups.com>
References: <56060285-704f-4160-aa10-d0dd839178da@w9g2000yqe.googlegroups.com>
NNTP-Posting-Host: 194.83.173.135
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1345461201 22622 127.0.0.1 (20 Aug 2012 11:13:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 20 Aug 2012 11:13:21 +0000 (UTC)
In-Reply-To: <56060285-704f-4160-aa10-d0dd839178da@w9g2000yqe.googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=194.83.173.135; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP
User-Agent: G2/1.0
X-Received-Bytes: 2039
Xref: csiph.com comp.databases.ms-sqlserver:1223

On Saturday, August 18, 2012 4:30:00 PM UTC+1, justaguy wrote:
> Downloaded an eval copy of SQL Server 2008 (Enterprise edition),
> upon installation, I couldn't find SSIS anywhere. How come? 

In SS2005 Management Studio, open a server in Object Explorer,
right-click on a database, choose "Tasks", "Import Data", 
and you should find yourself working with SSIS, whether it 
says so or not.

The mad head technician here didn't let us have SSIS, which is
quite a disadvantage.  He's afraid of it.  I think it requires 
components at client and server, maybe, but I suspect that you 
have to choose deliberately not to install them, and it is 
perverse to do that.

SSIS is an enterprise-grade workbench for importing, exporting, 
tidying and mutilating data between formats or just between servers, 
and because it's a standard part of SQL Server, there may not be 
another working way provided to do what you're trying to do.