Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing fox data
Message
 
 
To
09/03/2010 12:30:35
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01453503
Message ID:
01453526
Views:
42
TRUNCATE the table, adjust the structure and SSIS import package and import data.

>
>I wanted to know the best way to import the structure, adjust it and then import the data into that.
>
>
>
>>I'm confused. Do you want to change structure of the table or not?
>>
>>>
>>>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.)
>>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform