Groups > comp.databases.ms-sqlserver > #1223

Re: Issue with importing Access db into a SQL Server 2000 or Express

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> (permalink)
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

Show key headers only | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Issue with importing Access db into a SQL Server 2000 or Express justaguy <lichunshen84@gmail.com> - 2012-08-18 08:30 -0700
  Re: Issue with importing Access db into a SQL Server 2000 or Express Erland Sommarskog <esquel@sommarskog.se> - 2012-08-18 20:59 +0200
    Re: Issue with importing Access db into a SQL Server 2000 or Express justaguy <lichunshen84@gmail.com> - 2012-08-30 12:36 -0700
  Re: Issue with importing Access db into a SQL Server 2000 or Express Philipp Post <post.philipp@googlemail.com> - 2012-08-20 01:39 -0700
  Re: Issue with importing Access db into a SQL Server 2000 or Express rja.carnegie@gmail.com - 2012-08-20 04:13 -0700

csiph-web