You would have to pass the web address as a global variable, named gv_WebAddress for example, and change the line:

 objSvrHTTP.open "GET", "http://www.exodus.co.uk/xml/aaa.xml", false

TO

 objSvrHTTP.open "GET", DTSGlobalVariables("gv_WebAddress").Value , false

This should do the...

You could use an ActiveX script to try to connect to the DSN. You can then have OnSuccess and OnFailure workflows from it.

Something like:

Function Main()

 Dim conn

 Dim connStr

 Dim userID, pWord

 userID =...

Take a look at BCP in Sql Server Books Online. The answer you need is there.

Hi Phil,

I use ActiveX scripts within DTS packages to download files from HTTP sites. If this is necessary as part of a procedure, I execute the package using EXEC...

Thanks. I think it might be me just being lazy!

You would have to have a lookup table of ALL of the values possible. You could create this on the fly in your SQL statement if it is necessary. Using...

Why do you have to use the GROUP BY? I would understand the use if your query looked like:

SELECT col1, COUNT(col2)

FROM table

WHERE col1 = @var1

GROUP BY col1

It is very hard...

Can you give some info with regards to the real-life problem that you are trying to address?

There are some confusing aspects to your query.

If you remove the GROUP BY clause you will get a count of 0. As there are no groups (customerIDs) that match the where clause no rows are returned. 

No probs. It just struck me, there's a good explanation of parameters at http://www.sqldts.com/234.aspx, a site that has been (and continues to be) very useful.

The Parameters button is one of the available buttons in the Execute Sql Task Properties dialog. Here you can map both input and output parameters.

Check out BOL for a (maybe)...

It works on the principle of first in, first out. When you click on the Parameters button and assign the variables, the first ? will map to Parameter 1, the...