Thanks John - I'll give it a go. Helps point the finger in the right direction, I guess!

Joe - We use dedicated development on SQL Source Control.

Seemed to make most sense at the time!

Cheers

Ben

I've been using Subversion for about 6 years for SSIS packages. Firstly on a Linux server, and now on a Windows server using CollabNet Subversion Edge (it's free, and provides...

I'm already doing something very similar on one of our systems. The process requires me to load data from a standby database into one which the users can access. The...

I've had to use them for SFTP (via psftp), and for connecting to web services (via DLLs).

Ben

Thanks Guys

I've downloaded the SP1 version of the basic installer, but I can't try to install until later on due to some hardware testing on the new machine.

I'll try later...

I'm...

I think that's close enough for me.

The Warehouse database log has grown to 4Gb overnight, whereas running essentially the same processes using the alternate database with the simple logs has...

Hi Gail

Thanks for the speedy response - you've confirmed that it is as I had hoped:-)

The tables that I'm building up are basically being put into a holding area before...

Answering my own posts now...

I've ended up writing a script as follows:

Public Class ScriptMain

Inherits UserComponent

Private NextKey As Int32 = 0

Private LastID As Int32 = 0

Public...

Hi John

Thanks for the response. It's an option I hadn't thought of - I was aiming to keep as much of the processing in the pipeline as possible, but this...

Hi John

I'd hoped that the Row Number component would do what I wanted, but I can't see how to "restart" the numbering each time you get into the next ID...