Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | 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