If I read it correctly, then u will always get the same count if just use one table with where condition as T.Col1 will always equal to F.col1.. so on...

Other possibility is that you have jobs for DBCC defrag/reindex that are executed on adhoc basis on a SQL DB that has considerable data (abt 30 GB or more).  If...

Did you check your DTS properties.  More than likely, the dts set to fail on first error.  If you untick the option, it should follow thru

the correct syntax for not null check is 'IS NOT NULL' and  not ' =  not null', hence the syntax error. 

 I would think the easiest approach would be to...

Not sure if you have any issue here but personally I won;t classify this as a bug. If you need to use special characters then any language will need...

One of the possible reason could be the global variable names.  These are case sensitive so if not defined correctly in DTSRun command, it uses from the last execution of...

Thanks for your reply....

Not sure how SQL determines degree of parallelism for query execution but If it;s parallelism on it's own then should it not be a daily occurance? 

Couple of ways to address this.

a.  define sp's for each update passing dynamic parameters as input fields and exec sp's with global parameters set to dynamic fields in exec sql...

You can access either of the server using ADODB and trusted connection using activeX.  Dump the required data in the staging tables using adoDB connection and then do simple insert once the...