SQL Function "select @@SERVERNAME" will return the current server.

This query will work:

select  company_no

 ,category

 ,current_product = sum(Case When product_status = 'sold out' Then -(no_of_items) Else no_of_items End)

from  test

group by company_no

 ,category

It's pretty easy to create an Excel connection to the worksheet, and then use a Transform Data task to move data into it. By default, rows will be appended to...

Have you made certain that the Oracle Client is installed on the SQL Server from which the dts package is run --  as well as having an ODBC connection set...

I've experimented with a couple of ways to deal with this. One way that is kind of messy, but works is

1) Create a blank file for to use as a...

Chances are that the VENDORS table has a vendor_id column that is unique. This is the column that should be joined to the PRODUCTS table -- not the vendor_name column.

You can also use RAISERROR to force an error condition in dts. 

declare @FUNCTIONTEST varchar(2)

set @FUNCTIONTEST = 'KO'

IF @FUNCTIONTEST='KO' RAISERROR ('DO NOT PROCESS',11,1)

The above lines will create an error condition in the dts...

Do you have any ActiveX scripts in the package that independently attach to the database?

In the Analysis Services pane, right click the server name, and select properties. The location of the data folder and temporary folder are found in the "General" tab.

Whoops, the last part of my suggested query was left off. This is one I would try:

SELECT     COUNT(*) AS Total

FROM         records

WHERE    ...

Try this query:

SELECT     COUNT(*) AS Total

FROM         records

WHERE     year(reportsentdate) = @year