IF they access your system via Terminal Services..

Unfortunately, because they are using Terminal Services it is as if they are sitting at the server...

Only way I could think of is...

I would also check and make sure that you are not attempting to copy the users/permissions etc...  this could cause the DTS package to fail as well...

Just for giggles...

What happens if (not this EVER happens) your Network guys MOVE the network segment that your box is on and forget to tell you?

I know this from experience. ...

To all who have a better way of doing this....

I unfortunately, am ingrained in certain HARD ways of doing things....  I also look for the easy way and the smart...

Depending on the set-up of the SQL server i.e. either per Server, Process, user the CAL may show as NULL.  Also, the different versions of SQL 2K may show as...

Unfortunately, I don't think that is possible.

The problem is the the SQL Server is requesting data from Oracle FROM SQL and SQL has no way of knowing or handling the...

DELETE FROM table1 WHERE CONVERT(VARCHAR(10), Field1, 101) <

SELECT DATEADD(DAY, -60, CONVERT(VARCHAR(10), GETDATE(), 101))

is one way.  There are multiple other ways of doing this too.

Here's one inelegant way:

DECLARE @val DECIMAL(18,5)

SET    @val = 7.225

SELECT CAST(LEFT(@Val, CHARINDEX('.', @val) - 1) AS VARCHAR(10)) + '.'

     + SUBSTRING(CAST(@Val AS VARCHAR(10)), CHARINDEX('.', @val) + 1, 2)

I'm sure that...

I apologize.  I missed the setting of the @Include to a variable like 'A', 'I'

You will need to build your SQL string and then EXEC it or run sp_executesql.

Hopefully in...

When you open the scheduled job there should be on the first screen a job owner...  that is who is running the DTS package scheduled.

When you manually run the package...

Sounds like you want the last 2 orders to NOT include the very latest one??

If that is the case you will have to build in a correlated sub-select or some...

Have you tried WHERE Status = @Include?

If that fails you will have to create teh entire SQL string as a variable and then

sp_executesql @SQLString

Can you please let us know what the step is supposed to do so we can help you diagnose the problem?

Unfortunately, without understanding what step 1 does I am only guessing as to what the real issue is.

When you run the package yourself it runs from your PC and under...

The maintainers of SSC try their best to manage this site.  As far as I know they have the following going on:

1. New baby
2. Jobs are demanding more of their time
3. This is...