Yes... you can do it as shown below.  Or, you can also use a Exec SQL task to do the count, and put the result into a global variable.  You...

Example for a "conditional" Data Transformation Task:

IF (SELECT Count(*) from table_A) >  0

BEGIN

  SELECT    A,B,C,D

  FROM my_table

END

ELSE

BEGIN

 --This Query does not return any data

    SELECT     A,B,C,D  

    FROM my_table...

What kind of task do you want to execute? 

If the task can be completed with a T-SQL statement, then you can use a T-SQL IF statement to either execute...

Can't help you much with the dll registration.  I did have a slightly similar problem last week.  My prod server stopped talking to my Domain Controller.  Since it couldn't see...

I understand your situation now.  I would suggest that you do not register the DLL's on your web server.  Especially since it isn't working for you.

In your ASP page, create...

Well... try this article:  http://www.sqldts.com/default.aspx?225

I'm not quite sure why you are trying to "install" dts on your web server.  Do you want the packages to actually run on the...

Even doing this doesn't work?

EXEC master.dbo.xp_cmdshell 'dir c:\'

This is assuming that you have your package saved as a "Local Package" on the server.

When looking at the list of Local Packages, right click on the package and hit...

Are you specifying the entire path for the dll?

From redist.txt on the SQL Server Installation CD:

INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)

---------------------------------------------------------

The following files must be registered using the regsvr32.exe...

Why are you trying to use xp_cmdshell to execute the package?  You can schedule the DTS package as a job... and then just start the job (can do this with...

Use regsvr32.exe to register each of the DLL's.