Yeah, this site is very helpful.  I would also have to echo DSP's suggestion to check out http://www.SQLDTS.com.  You will learn much from them as well.

You could change the "retry attempts" in the job that runs the DTS to something greater than 0.

Wow -- I got it right.  Maybe we should add this to the stupid Question of the Day.  Maybe then I would get one right for a change.

Glad to be...

The error message (conversion of a char data type to a datetime data type) indicates that there is a problem with trying to load the converted datetime to the variable...

You could also use the FileSystemObject from within the DTS

The problem with calling Win APIs from within an ActiveX Script is that it only allows for variables to be dimmed as variant and APIs require strict declarations.

When running using DTSRun, make sure the command line text does not contain version information denoted by the /V flag.  You can start the DTSRunUI.exe interface and have it to...

I see you already have the solution.

Always a day late and a dollar short -- story of my life

I would have to agree with Mike -- why not just use VBScript to perform the calculation?  Simply dim a variable in the ActiveX Script and perform the calculation.  You...

Remi,

You already had the solution in your post, I just wanted to make it more clear.  And I agree with you, I prefer the Sum(Case) syntax as opposed to (Case...

The problem with your original SQL is you have ACTION_TAKEN in the Group By

Not sure if this is what you're after, but when I dynamically build a SQL string in an ActiveX Script and then save this string to the source SQL of a...

So this would the the same as "Top n With Ties"

Here's the solutions that I finally arrived at...

Select State, Company, Revenue

FROM myTable A

WHERE Revenue IN

(

Select TOP 2 Revenue

From myTable B

WHERE B.State = A.State

Order by Revenue DESC

)

Order by State, Revenue...

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspmethai_4p0k.asp

Execute Method

The Execute method executes a Data Transformation Services (DTS) task object.