Generic Bulkload routine using SQlBulkCopy Class

[Martijn Evers AKA DM Unseen]

All,

Has somebody ever written a (fully) generic bulk load routine to load
data between datasources using a SQLCLR routine that employs the
SqlBulkCopy Class?
I'm looking to enhance the loading of our Datawarehouse with such a
routine, but most routines that I have found are written for a
specific problem.

DM Unseen
AKA
Martijn Evers

[Bob Beauchemin]

Hi Martijn,

You can't use the context connection with SqlBulkCopy (it's not supported)
so why use SQLCLR?

Cheers,
Bob Beauchemin
SQLskills

"Martijn Evers AKA DM Unseen" <dm.u...@gmail.com> wrote in message
news:e8533dae-726d-4c38...@p20g2000yqi.googlegroups.com...

[Martijn Evers AKA DM Unseen]

On 3 mrt, 21:17, "Bob Beauchemin" <no_bobb_s...@sqlskills.com> wrote:
> Hi Martijn,
>
> You can't use the context connection with SqlBulkCopy (it's not supported)
> so why use SQLCLR?
>
> Cheers,
> Bob Beauchemin
> SQLskills
>

> "Martijn Evers AKA DM Unseen" <dm.uns...@gmail.com> wrote in messagenews:e8533dae-726d-4c38...@p20g2000yqi.googlegroups.com...

>
>
>
> > All,
>
> > Has somebody ever written a (fully) generic bulk load routine to load
> > data between datasources using a SQLCLR routine that employs the
> > SqlBulkCopy Class?
> > I'm looking to enhance the loading of our Datawarehouse with such a
> > routine, but most routines that I have found are written for a
> > specific problem.
>
> > DM Unseen
> > AKA

> > Martijn Evers- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Bob,

currently purely for convinience, Since I runn all ETL in process with
SQL Server from T-SQL. I know the restriction but I thought it would
still be fastest when copying datasets from one server to another, or
even within a server, if the dataset is large eneough!(i do not have
SQL server 2008, else that would be a non issue).
But an external routine could also be OK.