Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing and exporting Text or Flat Files

Status
Not open for further replies.

jjc3397

Programmer
Dec 21, 2003
55
US
What is the procedure to Import and Export a Text or Flat File into the Seqel Server 2005 to produce a table?
 
Use the SSIS Import / Export wizard or create an SSIS package by hand or use the BCP command line utility or the BULK INSERT T-SQL command.

The Import / Export Wizard can be found by right clicking a database and going to the sub menu under All Tasks.



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"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top