Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Integration Services VS BCP (2008 R2) Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 9:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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
Post #1420171
Posted Thursday, February 14, 2013 4:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:51 PM
Points: 7,140, Visits: 12,763
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
Post #1420344
Posted Friday, February 15, 2013 3:40 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
Thanks for the info
Post #1420465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse