Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nvakeel
Yak Posting Veteran
52 Posts |
 Posted - 2008-01-17 : 11:24:52
|
| Hello Folks,I need your help regarding bulk upload/insert in sql server 2005.I have a table (xyz) residing in x database. I have a txt file abc.txt in c:\abc.txt path. The table has two columns, col1 is simply S.no and Col2 holds the records. Now I want to upload the text file 'abc' which holds only the records. Is there any way to insert records only.If not I even can remove col1 and make table holds only one column.your help is appreciated.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-17 : 11:34:42
|
| this can be achieved using dts. modify the transformation tab properties to map data from text file to Col2.Make sure you either make Col1 nullable or add a default value. |
 |
|
|
|
|
|
bulk insert / bcp/ bulk upload