SQL Server Performance Forum – Threads Archive
insertion of data using DTSHi,
can someone tell me how can i insert some data into a table using dts….i have a file .bcp that has all the rows but in the following format
1 1230 52 4442 55454
there r many spaces in between the numbers…n there are 23rows like this…in case of oracle i had another file that was called as the control file and it was calling this .bcp file and then was inserting the data easily using the COMMAND PROMPT…but i m not able to figure out how can i load this data???????????????
pleaseeeeeeeeeeeeeeeeeeeee someone help meeeeeeeeeeeeeeeeeeee
Hi,<br />please look at BOL *Copying Data From a Data File to SQL Server* <br /><br />here is a example from BOL <br /><i><br />BULK INSERT pubs..publishers2 FROM ‘c:
ewpubs.dat'<br />WITH (<br /> DATAFILETYPE = ‘char’,<br /> FIELDTERMINATOR = ‘,’,<br /> ROWTERMINATOR = ‘
‘<br />)</i><br /><br />importing data into table using bcp<br /><br />bcp pubs..bitmap in test.doc -Usa -Ppassword -Sservername<br /><br />exporting data from table into file using bcp<br /><br />bcp pubs..bitmap out c:itmap.txt -Sservername -Usa -Ppassword<br /><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
Take a look at FORMATFILE option in BCP under books online. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.