Hey Jenny,

It definitely works for excel.

I have a for each file enumerator which enumerates and even traverses subdirectories and imports any excel files found (amongst other things). Wrote it quite...

Hey Jacobus,

You could for example use a variable as a SQL source, and then populate the variable in a scripting task.

Sterkte man!

~PD

I suspect that your row width needs to be adjusted by 3 characters

I am assuming that you know what the VB.NET script fundamentally would look like (my forte is definitely not VB.NET). Sure if you google accessing a sharepoint site via .NET...

You may consider creating a new file outside of the for each loop enumerator, and then disabling the overwrite option during the loop section.

You would most probably have to increment...

As far as I know bulk insert is for use with flatfiles.

You can insert using commit batch sizes, which should improve your performance

Jamie's site - Conchango.

My bad, getting old here

Professional SQL Server 2005 Integration Services really worked for me. I suppose its different strokes for different folks.

What I did find to be very helpful when just starting on SSIS:

-...

For each ADO enumerators are actually really easy.

- Create an object variable, and add a prepare SQL task to your control flow.

- Write the SQL statement, and change to full...

Many ways to skin a cat, whichever works best for a particular situation...

Assuming that you were using a For Each ADO enumerator, I dont see any reason why the loop...

Hey,

There is a sum operation on the aggregate function, also a count distinct, mini and maxi.

But careful, you would need the values to be sorted prior to performing the aggregation...

No prob,

I am actually offline from SSC for a while to finalise my project but thought I would just put in 5 cents today on this post....

Crever has made a...

I am with Jim on this one, it is...

I am going offline from SSC for a about a month, finally got some actual productional sourcefiles to work with.

Keep on posting if you find any new techniques though, mighty...

😀 One out of 2 correctly spelt names is a start...

Thanks Jeff,

Sorry, getting a bit absent minded here. You are right, I did suggest SSIS, my bad (3 letters -...