Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing fox data
Message
 
 
To
09/03/2010 12:24:08
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01453503
Message ID:
01453505
Views:
40
>Hi
>
>I'm importing a large foxpro table into SQL Server.
>
>The import using the Import Export Wizard worked created the table and I have my data but I want to adjust the structure of the table .
>
>When I try to amend the structure I get a warning
>
>Saving Definition Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible.
>
>How can I import my data into a table which I have already set up so I don't have to change the structure (I'm actually trying to make one of the items a PK.)
>
>Thnaks

Can you insert your data into existing table? Are you using SSIS for this task?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform