Guess they will come later today when the DBA waskes up 🙂

Hi,

As a starter ... I think I will try the SQlBulkCopy class ... since writing the SSIS package etc. and figure it all out will take time ... but for...

Holy mother of GOD ...

SSIS Package with the "Script Task" seem handy ...

Now I can move my ugly console app into the SQL server ... and handle it all from...

After reading a little about SSIS packages it seems really handy ...

But with the above ... would that not create some extra steps ... as I see it ... would...

Hi,

Ramesh (1/12/2009)

---

Mikael,

I am no expert:), but I liked to put my own thoughts on this.

Instead of reading the file row-by-row and forming the dynamic sql for every 1000 lines, what...

Hi Barry,

Sure ... here it comes.

With the times above ... this is what takes...

So ... for 4mill rows, 65 mb data ... it takes like ( this is a guess ) 20% of the time my Import app is running ...

Its all running...

Before...

Nicholas Cain (1/11/2009)

---

Out of curiousity, are all the inserts and updates happening on the same tables for all of the sql files? If that's the case could you drop the...