I do suggest read the article in BOL titled "Using ActiveX Scripts in DTS"

There are a few keys to make it work properly other than what you normally do in...

Or you can shorten a little by changing the while loop to this

while @i <= len(@AlphaStr)

select @RtnStr = @RtnStr + CASE WHEN substring (@AlphaStr, @i,1) LIKE '[0-9]' THEN substring...

Yes it is not a good encryption, and this is a major reason why it is not documented. They don't really want you to use it.

When you created the package, was it on your local machine you did this. If so open the SQL connection and verify that it is valid for the box. You...

Have you tried to execut it on the server by hand? If works then is a permissions thing if not then something about the server is different in how it...

I don't neccessarily from this think you are going about what you really want. But I want to make sure I fully uunderstand. Can you give details on a bit...

ActiveScript is an design object you drop into the design of the DTS package, it is the wrapper for VBScript code that is all. Then you do the nightmare stuff...

Might try vbscript are on

http://www.planet-source-code.com

but I never found any myself, ended up writing what I wanted myself for this type situation. Mine is a paging app that does web pased...

I think this fits your bill if not should be close.

SELECT company_name, datepart(mm,created_time) as dupmonth, count(*) as dupcnt

FROM company

LEFT JOIN

(select min(created_time) mct, company_name cn from company) as tblMins

ON

company_name = cn...

I still have to point out the one major flaw that always is overlooked with a single DB solution. Many times you may have some related data but much is...

The only downside with sp_start_job is if it is already running it will throw an error. Check the job state first before executing by using sp_help_job or look at it's...

Yes, you just have to open the Excel file as a recordset and loop thru the column count to find out what they all are and you can get the...

You are not supposed to place any triggers on system objects. They are not guaranteed to work and they can cause unexpected issues.

The best way I have seen most people...

This shopuld help

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

If it is on the same machine then you can use ActiveScript within the DTS package, if remote there are the inet COM dlls that are part of windows or...