Brian,

Does your solution involve two different SP scripts (one with 'WITH ENCRYPTION', and one without)?  Or does your solution use only one SP script?  Because, what I am looking for...

lara,

Just as an FYI add-on to what everyone else has said:

When you run a DTS Package from designer, you are running it under the context of YOUR network logon.  When...

Put your mouse cursor on top of the icon, a hint will display.  It's one of the connection icons that looks like a printed page.

JN,

I recently went through the same thing.  Look at the following ActiveX VBScript code:

Dim strConnectString, conServerDB, strUniqueIdentifier, strSQL

'Set up and open database connection.

strConnectString = "Provider=SQLOLEDB; Data Source=ServerName;" & _

                   "Initial Catalog=DBName;UID=User;password=Password"

Set conServerDB...

More common, maybe, but does that necessarily mean it should be done that way?  Why use two FETCH NEXT statements when you can easily use just one?

BSB,

As far as your contention that "with limited use they can make code very clear", let me ask one thing:

Since you used a GoTo and a label in your original...

BSB,

Your solution won't work if @abc = 'C'.  If you are only going to use one "Begin" "End" block it should be around the ELSE clause which has...

BSB,

Before anything else, just let me say one thing...

DON'T USE GOTO!  DON'T USE GOTO!  DON'T USE GOTO!  DON'T USE GOTO!  DON'T USE GOTO!  DON'T USE GOTO!  DON'T USE GOTO!  DON'T...

You don't need to use the Max() function in the where clause of the second SET statement.  "WHERE UnitPrice < @max1" will limit your search to those UnitPrice's which are less than...

Hatim,

Each connection (or spid) has it's own set of "@@" variables.  You don't have to worry about someone on another connection changing your @@rowcount or @@identity variable.

The following code assumes that ENRid is a UniqueIdentifier:

Update

   Enrollment

Set

   ISMid = NULL

From

   Enrollment enr1

Where

   enr1.ENRid >

      (

       Select

          Min(ENRid)

       From

          Enrollment enr2

       Where

          enr2.ISMid = enr1.ISMid

      )

I'll keep that in mind.  Thanks.

Remi,

If I could give you a star I would.  I just replaced about 10 lines of code declaring and using a recordset and an ADO Command with your 1 line of...

The simplest DTS package I can come up with has a global variable, three tasks, and and two connections.  In order they are:

Declare a global variable for the filename.

1. ActiveX...

Everything everyone is telling me, I already know.

Let me state this very clearly:

What I am looking for is if there is a way to execute SQL against the existing DTS...