I believe you would have to build a dynamic SQL statement or define the table column to be used in the Where.  Currently SQL would parse the Where clause as...

Where...

Are you calling this pump multiple times? It may be nessissary to call the Connection.ReleaseConnection() method; Modify the file name; then call the Connection.AcquireConnection(TaskName) method.

I have never had...

Scott,

Send me an email to mgercevich_nospam@gmail.com (remove the _nospam from the address) and I would happily send you a copy of a utility that I wrote a while back. The...

Since this VBScript calls COM Objects.. inorder to do this in T-SQL; You would need to use the sp_OACreate methods to create references to the object as local variables.. then...

The Row Delimiter is a member of the OLEDBProperty Collection of the Connection Object.

From the Package2 Hierarchy...

Connections...Connection2.ConnectionProperties.OLEDBProperty("Row Delimiter").Value

HTH,

-Mike Gercevich

If I am understanding your question correctly, I believe you would have to create an object within your component to DTS.Package2 then access the value of the constants via the...

Backup you database and restore it into the new Test database, is the easiest method of doing this and keeping all your constraints.  Syncronization can be done with third party...

Simon,

Correct.  Each Step in the Steps collection has an Execute method.  You could monitor the ExecutionStatus property and on completion, determine Success or Error state. (If you really really had...

The Package and extended Package2 objects Execute method do not return a Result.  If you know that exery Step in your Package should execute with a Step Result of Success,...

See this post of mine on a simular topic for an example:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=221076#bm221486

-Mike Gercevich

Since you are using CDONTS.. which I believe is only supported on NT4 (yikes) (cdonts was deprecated and you now should be using CDO), you need to set your MailFormat property...

You may want to use the CDO object from an active-x script to send your message and attachment:

Here is a link that can easily be adapted to a DTS Active-X...

Are you using the built-in Send Email task in DTS?  or are you using an Active-x Script that uses a third party SMTP Emailer?

If you are using the built-in task......

Is your variable "L" being returned with a value less than 15?  say 10... L-15 would = -5... you can't do that on a Left function.

Also... it would not hurt...

You cannot use the FOR UPDATE unless every row in your cursor is unique...

Try adding an IDENTITY column to this table and re-run this procedure.  Your update of a single...