To Balmukund

Thanks that was an interesting read.  In the case I mentioned we were getting the correct results which had been verified.  It was simply too slow and based on...

Hi Philip

You are getting warmer!

Yes that is along the right lines, but the transformation will actually do the 'for' loops for you.  Basically...

Philip:

An 'ActiveX' transformation allows you to write Visual Basic code that can execute the calculations for you on the fly.

Search the web for examples of DTS packages using ActiveX.  I...

If you are comfortable using VB then DTS is the choice for you.  You can execute an ActiveX transformation during the import process.  Essentially you can execute custom VB Script...

I ran into one massive performance slowdown that was actually sloppy work at a previous employer.

There was a table that used a DECIMAL(12,0) for a primary key (related to a...