×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SSIS Import Wizard

SSIS Import Wizard

SSIS Import Wizard

(OP)

Is this a new forum? If so, may I have the honour of posting the first question.

I am trying to migrate a non-SQL Server database to SQL Server 2005. The source database happens to be a Visual FoxPro DBC, but that's not really relevant. As far as SSIS is concerned, it is an OLE DB data source.

I am using the SSIS import wizard, and this has successfully imported all the tables, columns and data types. However, there seems to be no way of importing indexes or constraints.

Am I right that this is a limitation of the import wizard, or am I missing something?

It's not a big issue. I can always find other ways of doing the job. I just wanted to make sure I wasn't missing something obvious.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

RE: SSIS Import Wizard

Congratulations on being the first to post a genuine question!!

@=)

As far as the indexes and constraints go, usually SQL Server does not import those from other sources.  It hasn't in the past, and I know of no reason this would have changed in SQL 2005.  

Sorry.

Catadmin - MCDBA, MCSA
"No, no.  Yes.  No, I tried that. Yes, both ways.  No, I don't know.  No again.  Are there any more questions?"
   -- Xena, "Been There, Done That"

RE: SSIS Import Wizard

Correct SSIS and DTS don't pull in the indexes aned constraints.  You'll need to create them manually.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

RE: SSIS Import Wizard

(OP)

Thanks to both of you for your replies. This confirms what I had assumed. As I said earlier, it's not a problem. I can write code in Visual FoxPro to convert the indexes and constraints. I just wanted to check that it was necessary.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close