February 14, 2013 at 9:58 am
Hiya,
Just wanting to clear something up in my own head. When Im exporting to an xls etc I usually use Integratin Services to do it. However Im working on someone elses stuff at the moment and they are using BCP to export to csv files. Ive looked eerywhere but I can find now where that tells you the best way of doing this (Wre in 2008 R2) by the way.
Im happy to happy a go and run with the code that is there but if its a case of no one uses that any more because....... then Id rather push for integration services again.
If anyone has any information on this I would be gratefull!
Thanks
Debbie
February 14, 2013 at 4:47 pm
bcp exporting to a csv file is used all over the world and probably will be for a very long time. bcp is obviously not as robust as SSIS since there is no option to export to an actual Excel file (among other destinations) but the setup you described will scalle well performance-wise and will get the job done as long as bcp can process the data into a file per the formatting requirements and the data-recipient can successfully accept and process those files.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 15, 2013 at 3:40 am
Thanks for the info
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply