CraigL77


Does anyone know if there is a .NET object that does something similar to BCP We are trying to export data in a lightweight (minimal dependancies) manner from SQL Server to a txt file. If there was a .NET component that did this it would really help us. There is a SQLBulkCopy object but I think its for importing to SQL Server.

Does anyone know of one





Re: SQL Bulk Export without BCP?

smathew


why dont you create a DataFlowtask and add the SQL Server source as in your OLEDBSource Component and use FlatDile Destination to point to the destination txt file map the necessary field from source to destination and you should be done..

sm







Re: SQL Bulk Export without BCP?

CraigL77

Because we dont want to use SSIS if we dont have to. As I had said we want it as lightweight as possible.

I realize this might not be the right place to ask this, but thought someone from the MS team might know what SSIS uses behind the scenes.







Re: SQL Bulk Export without BCP?

Phil Brammer

CraigL77 wrote:

Because we dont want to use SSIS if we dont have to. As I had said we want it as lightweight as possible.

I realize this might not be the right place to ask this, but thought someone from the MS team might know what SSIS uses behind the scenes.



SSIS uses SSIS. SSIS has a .Net API available, but it's still SSIS and it isn't redistributable which means you'll still have to have an SSIS license (really a SQL Server license) to use it.

So you'll have to head over to one of the .Net forums.





Re: SQL Bulk Export without BCP?

CraigL77

We have the license, what is the name of the SSIS api




Re: SQL Bulk Export without BCP?