Importing tables into SQLServer

Hi, I've just got my brand new shiny SQLServer and would like to set some new tables set up etc. But I'm really lazy and I was wondering if there is any way of importing table layouts, coulmns, whole structure type thing into SQLServer from Microsoft Access using DTS? I know it's a bit optimistic, but just wondered...

Any help gratefully accepted.

Thanks,
Paula.DTS could do it, but it would be ugly. I'd suggest the Upsizing Wizard (http://support.microsoft.com/default.aspx?scid=kb;en-us;325017) for this job.

-PatP

Importing DATE with Timestamp(In a Flat file) Column using SSIS

Hi

SSIS is brand new for me.. Playing with since a few hours..

Iam trying to import a Flat File into the SQLSERV DB using SSIS..
One of the column is in this format -- "YYYYMMDDHH24MISS"

How do i get around this to import the data in a readable fashion into the Destination?

Thanks!
MKR

Hi MKR,

What data type are you wanting the result to be?

You can use a derived column component to parse the format of the column and create anything you like -- a DT_DBTIMESTAMP, a string with your own format, etc...

You could turn the string in the format you have above into a string with this format: "YYYY-MM-DD HH:MM: SS" with an expression like this in derived column (where i am assuming the string is in a column called 'Col'):

SUBSTRING(Col, 1, 4) + "-" + SUBSTRING(Col, 5,2) + "-" + SUBSTRING(Col, 7,2) + " " + SUBSTRING(Col, 9,2) + ":" + SUBSTRING(Col, 13,2) + ":" + SUBSTRING(Col, 15,2)

Is that the sort of thing you are looking for?

Thanks
Mark

|||Thanks Mark..

But as i was telling you earlier.. My Knowledge on SSIS is very limited..
Now that i know we can manipulate the string..

Where do i do this -- I mean, where do i add this SUBSTRING Manipulation..

|||You want to add in in the data flow, using a derived column transformation.|||Thanks! Welch n Mark

Importing Access 2000 queries

Hello,
Brand new to SQL. I got all my data over to the SQL database. Is there a
way to get the access queries into SQL?
Thanks,
Gale
"Gale Coleman" <gcoleman@.legalassist.org> wrote in message
news:uxh9DkRkEHA.3828@.TK2MSFTNGP10.phx.gbl...

> Brand new to SQL. I got all my data over to the SQL database. Is there a
> way to get the access queries into SQL?
Access queries may or may not translate depending on how they are written.
On the SQL Server side, to access or manipulate data you have the option of
creating Views or Stored Procedures. Views are probably closest to Access
queries, and even have an 'SQL' window display of the query (you could try a
copy/paste of the Access query to a view as a starting point).
Steve

Importing Access 2000 queries

Hello,
Brand new to SQL. I got all my data over to the SQL database. Is there a
way to get the access queries into SQL?
Thanks,
Gale"Gale Coleman" <gcoleman@.legalassist.org> wrote in message
news:uxh9DkRkEHA.3828@.TK2MSFTNGP10.phx.gbl...

> Brand new to SQL. I got all my data over to the SQL database. Is there a
> way to get the access queries into SQL?
Access queries may or may not translate depending on how they are written.
On the SQL Server side, to access or manipulate data you have the option of
creating Views or Stored Procedures. Views are probably closest to Access
queries, and even have an 'SQL' window display of the query (you could try a
copy/paste of the Access query to a view as a starting point).
Steve

Importing Access 2000 queries

Hello,
Brand new to SQL. I got all my data over to the SQL database. Is there a
way to get the access queries into SQL?
Thanks,
Gale"Gale Coleman" <gcoleman@.legalassist.org> wrote in message
news:uxh9DkRkEHA.3828@.TK2MSFTNGP10.phx.gbl...
> Brand new to SQL. I got all my data over to the SQL database. Is there a
> way to get the access queries into SQL?
Access queries may or may not translate depending on how they are written.
On the SQL Server side, to access or manipulate data you have the option of
creating Views or Stored Procedures. Views are probably closest to Access
queries, and even have an 'SQL' window display of the query (you could try a
copy/paste of the Access query to a view as a starting point).
Steve