James,

This is getting to a level of confusion. Why can't you build the package from the file I mailed you ? All you have to do is build a simple...

Hi,

Thanks for the feedback. Here is the SP's code :

/*------------------------------------------------------------------------------------------

'  Name: sp_REPLICATE_PopulateDestination_IUD

'

'  Purpose: Build a dynamic SQL Strings to syncronise data from CASReplica...

Hi,

I did find a suggested solution at http://www.sqldts.com/main.asp?nav=1,6,234,0

I followed it to a tee, but still the SP's return values does not override my Packages' Global Variables.

The SP...

Hi,

Thanks for the feedback. 2 Simple questions though.

1. What exactly is the SQLAgent logon account and how do I use this account to log onto the server, do I...

Thanks for the reply. The MsgBox I only used to know where in the code I am. You can ignore them. I think you might be right with reference to...

Thanks, the LoadFromSQLServer method works fine. The only problem might be an speed issue, when using the Package Execute task one can run many tasks parallel (asynchronously) and, depending on...

Hi Liz,

One can use : DTSGlobalVariables.Parent.Name in VBScript to get the Package Name

This package object (DTSGlobalVariables.Parent...) can also be used to reference the DTS Package's Tasks, Connections, Steps, Transformations, etc.

Hope...

Thanks for the feedback, I am in the process of building a workaround. I have managed to clear the Source and Destination Columns via an ActiveX script just before running...