You need to develop a strategy to cleanse the data so that you can normalize it, create Clustered Indexes, Primary and Foreign Key Constraints as was suggested.

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Congratulations Jeff.

You could use the SSIS Export Wizard.

mzzzshay (9/8/2011)

---

I have to use bcp to import a text file from my computer. I am getting the above error and not sure why. Here is my code...

Just my personal preference.

I would prefer to document the Path in the Statement.

I would try to avoid having to CD to the path where the destination file exists every time...

You don't need to prefix with the drive?

Smiley77 (9/13/2011)

---

A little background..

I have a user who wants to be able to refresh a copy of his test database from production on the fly. He needs to be...

The following may give you some ideas:

http://stackoverflow.com/questions/640862/change-column-type-from-ntext-to-varbinarymax

The Jets loaded up with players recently.

They now have two former Pittsburgh 1st round draft picks as their starting Wide Receivers.

I would think...

I gave you an example early on that was based on the Adventureworks2008 Database.

If I'm not familiar with something and I'm getting errors, I have tried running the example.

Often this...

BCP OUT to the local Server.

Compress the file and copy to the destination server.

Uncompress the file.

BCP IN to the destination server.

What is the syntax?

Could you include the DDL and the Data for the file so that I can test?

With the SELECT INTO not only will it not carry over the Identity but it will not carry over Indexes, constraints, etc.

As was suggested Script the Table and perform an...