Dinesh - I probably will not know the answer to this question, but I'm sure that it will help others who do to work out what the problem is if...

A boxer, perhaps?

OK, good point.

Here's one that should work:

select t.transactionnumber

from tbl t

join (select t.transactionnumber from tbl t where t.itemid = 'mouse') t1

on t.transactionnumber = t1.transactionnumber

join (select t.transactionnumber from tbl t where t.itemid =...

Are there any Scheduled Tasks on the server that may be running these jobs?

There will be other guys on this forum who have better experience with this than I (I've never had anything like that many servers to look after), but one way...

Do you have network and admin access to all of the servers?

Maybe you could put your script into a stored procedure and have your job run that?

NULL is definitely a special case in SQL Server and cannot be treated as just another value (because it isn't).  I bet lots of people on here have been caught...

That's the way I would do it - here's some sample code - notice that I have put the connection string in a global variable for ease of use:

 Dim strConn

 Dim...

One way is to put a piece of ActiveX code as the first step in the DTS package.  Perform the IS NULL checks in this step and then:

 if (NULL condition) then

  main...

No need to use set.  Just use

oRS = DTSGlobalVariables("RSTables").Value

you're in VBScript land here - not SQL Server.

You will need to be a bit more specific before we can really help you.

Can you provide a bit more detail about why you need to do this?  What are...

Not 100% sure that I have understood the question - I am no XML dude - but if you are having problems as a result of SQL Server generating primary...

Can you be a little more specific - is the import actually failing, or are you validating the data after import and finding that it is 'corrupt' because it fails...

DTSSource and DTSDestination are available within a Transform Data task.

When you create a Transform Data Task, you must specify a source connection and a destination connection.  It is from these...