This query works in Query Analyzer:

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tempLabelData]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[tempLabelData]
GO

CREATE TABLE [dbo].[tempLabelData] (
[ItemNo] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Size No_ Description] [varchar] (20) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Cat_ No_ Description] [varchar] (25) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Plating Type] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[BaseQty] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Base Unit of Measure] [varchar] (2) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL,
[Whse] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnitCost] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Unit List Price] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[UPC Code] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INVALF] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BOXCODE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Gross] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CWgt] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COUNTRY] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QTYPERUOM] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CorpClass] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[code] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Basis] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INCOMP] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INCMPD] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPKDS1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPKDS2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPKDS3] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPKSZ1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INPKSZ2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


DECLARE PWWCursor CURSOR FOR

SELECT DISTINCT (replace(Item.No_,'-','')) as ItemNo,

UOM.[Super Equivalent] as SuperEquiv,
UOM.[Sales Qty Alt_] as ALTQTY,

Item.[Size No_ Description],
Item.[Cat_ No_ Description],
Item.[Plating Type],
REPLICATE(' ',6-len(cast (cast (UOM.[Alt_ Base Qty_] as integer) as
char(6)))) + (cast (cast (UOM.[Alt_ Base Qty_] as integer) as char(6)))
as BaseQty,
Item.[Base Unit of Measure],
' ' as Whse,
' ' as UnitCost,
REPLICATE(' ',7-len(cast (cast (Item.[Unit List Price] as
decimal(7,2)) as char(7)))) + (cast (cast (Item.[Unit List Price] as
decimal(7,2)) as char(7))) as [Unit List Price],
Item.[UPC Code],
' ' as INVALF,
' ' as BOXCODE,
REPLICATE(' ',6-len(cast (cast (Item.[Gross Weight] as decimal(7,2))
as char(7)))) + (cast (cast (Item.[Gross Weight] as decimal(7,2)) as
char(7))) as Gross,
REPLICATE(' ',7-len(cast (cast (Item.[Weight_100] as decimal(7,2)) as
char(7)))) + (cast (cast (Item.[Weight_100] as decimal(7,2)) as
char(7))) as CWgt,
' ' as COUNTRY,
REPLICATE(' ',6-len(cast (cast (UOM.[Qty_ per Unit of Measure] as
integer) as char(6)))) + (cast (cast (UOM.[Qty_ per Unit of Measure] as
integer) as char(6))) as QTYPERUOM,
' ' as CorpClass,
case UOM.Code
when 'PC' then 'P'
when 'LB' then '#'
when 'FT' then 'F'
end as Code,
' ' as Basis,
' ' as INCOMP,
' ' as INCMPD,
RIGHT(Item.[Cat_ No_ Description Alt_ 1], 30) as INPKDS1,
RIGHT(Item.[Cat_ No_ Description Alt_ 2], 30) as INPKDS2,
RIGHT(Item.[Cat_ No_ Description Alt_ 3], 30) as INPKDS3,
Item.[Size No_ Description Alt_ 1]+' ' as INPKSZ1,
' ' as INPKSZ2
FROM Porteous$Item Item
inner JOIN [Porteous$Item Unit of Measure] UOM ON
Item.No_ = UOM.[Item No_]
where Item.No_ >= '00000-0000-000' AND
Item.No_ <= '99999-9999-999' AND
Item.[Unit List Price] < 10000 AND
Item.Inactive = 0


-- Row Holding Variables

DECLARE @ItemNo varchar(12)

DECLARE @SuperEquiv varchar(1)
DECLARE @ALTQTY varchar(1)

DECLARE @SizeDescr varchar(20)
DECLARE @CatDescr varchar(25)
DECLARE @PlatingType varchar(4)
DECLARE @BaseQty varchar(6)
DECLARE @BaseUOM varchar(2)
DECLARE @Whse varchar(6)
DECLARE @UnitCost varchar(7)
DECLARE @UnitListPrice varchar(7)
DECLARE @UPC_Code varchar(12)
DECLARE @INVALF varchar(8)
DECLARE @BOXCODE varchar(2)
DECLARE @Gross varchar(6)
DECLARE @CWgt varchar(7)
DECLARE @COUNTRY varchar(2)
DECLARE @QTYPERUOM varchar(6)
DECLARE @CorpClass varchar(1)
DECLARE @code_ varchar(1)
DECLARE @Basis varchar(1)
DECLARE @INCOMP varchar(7)
DECLARE @INCMPD varchar(2)
DECLARE @INPKDS1 varchar(30)
DECLARE @INPKDS2 varchar(30)
DECLARE @INPKDS3 varchar(30)
DECLARE @INPKSZ1 varchar(30)
DECLARE @INPKSZ2 varchar(30)


-- Valid values for tempTABLE

DECLARE @outItemNo varchar(12)
DECLARE @outSizeDescr varchar(20)
DECLARE @outCatDescr varchar(25)
DECLARE @outPlatingType varchar(4)
DECLARE @outBaseQty varchar(6)
DECLARE @outBaseUOM varchar(2)
DECLARE @outWhse varchar(6)
DECLARE @outUnitCost varchar(7)
DECLARE @outUnitListPrice varchar(7)
DECLARE @outUPC_Code varchar(12)
DECLARE @outINVALF varchar(8)
DECLARE @outBOXCODE varchar(2)
DECLARE @outGross varchar(6)
DECLARE @outCWgt varchar(7)
DECLARE @outCOUNTRY varchar(2)
DECLARE @outQTYPERUOM varchar(6)
DECLARE @outCorpClass varchar(1)
DECLARE @outCode varchar(1)
DECLARE @outBasis varchar(1)
DECLARE @outINCOMP varchar(7)
DECLARE @outINCMPD varchar(2)
DECLARE @outINPKDS1 varchar(30)
DECLARE @outINPKDS2 varchar(30)
DECLARE @outINPKDS3 varchar(30)
DECLARE @outINPKSZ1 varchar(30)
DECLARE @outINPKSZ2 varchar(30)


DECLARE @checkItem varchar(12)


OPEN PWWCursor
FETCH NEXT FROM PWWCursor INTO @ItemNo, @SuperEquiv, @ALTQTY,
@SizeDescr, @CatDescr, @PlatingType, @BaseQty, @BaseUOM, @Whse,
@UnitCost, @UnitListPrice, @UPC_Code, @INVALF, @BOXCODE, @Gross, @CWgt,
@COUNTRY, @QTYPERUOM, @CorpClass, @code_, @Basis, @INCOMP, @INCMPD,
@INPKDS1, @INPKDS2, @INPKDS3, @INPKSZ1, @INPKSZ2

SET @CheckItem =@ItemNo


SET @outItemNo = @ItemNo
SET @outSizeDescr = @SizeDescr
SET @outCatDescr = @CatDescr
SET @outPlatingType = @PlatingType

SET @outBaseUOM = @BaseUOM
SET @outWhse = @Whse
SET @outUnitCost = @UnitCost
SET @outUnitListPrice = @UnitListPrice
SET @outUPC_Code = @UPC_Code
SET @outINVALF = @INVALF
SET @outBOXCODE = @BOXCODE
SET @outGross = @Gross
SET @outCWgt = @CWgt
SET @outCOUNTRY = @COUNTRY

SET @outCorpClass = @CorpClass
SET @outCode = @code_
SET @outBasis = @Basis
SET @outINCOMP = @INCOMP
SET @outINCMPD = @INCMPD
SET @outINPKDS1 = @INPKDS1
SET @outINPKDS2 = @INPKDS2
SET @outINPKDS3 = @INPKDS3
SET @outINPKSZ1 = @INPKSZ1
SET @outINPKSZ2 = @INPKSZ2

SET @outBaseQTY = '0'
SET @outQTYPERUOM = '0'

WHILE @@FETCH_STATUS=0
BEGIN

IF @ItemNo <> @CheckItem
BEGIN

INSERT INTO tempLabelData (ItemNo, [Size No_ Description], [Cat_ No_
Description], [Plating Type], BaseQty, [Base Unit of Measure], Whse,
UnitCost, [Unit List Price], [UPC Code], INVALF, BOXCODE, Gross, CWgt,
COUNTRY, QTYPERUOM, CorpClass, Code, Basis, INCOMP, INCMPD, INPKDS1,
INPKDS2, INPKDS3, INPKSZ1, INPKSZ2)
VALUES (@outItemNo, @outSizeDescr, @outCatDescr,
@outPlatingType, @outBaseQty, @outBaseUOM, @outWhse, @outUnitCost,
@outUnitListPrice, @outUPC_Code, @outINVALF, @outBOXCODE, @outGross,
@outCWgt, @outCOUNTRY, @outQTYPERUOM, @outCorpClass, @outCode,
@outBasis, @outINCOMP, @outINCMPD, @outINPKDS1, @outINPKDS2,
@outINPKDS3, @outINPKSZ1, @outINPKSZ2)

SET @CheckItem =@ItemNo

SET @outItemNo = @ItemNo
SET @outSizeDescr = @SizeDescr
SET @outCatDescr = @CatDescr
SET @outPlatingType = @PlatingType

SET @outBaseUOM = @BaseUOM
SET @outWhse = @Whse
SET @outUnitCost = @UnitCost
SET @outUnitListPrice = @UnitListPrice
SET @outUPC_Code = @UPC_Code
SET @outINVALF = @INVALF
SET @outBOXCODE = @BOXCODE
SET @outGross = @Gross
SET @outCWgt = @CWgt
SET @outCOUNTRY = @COUNTRY

SET @outCorpClass = @CorpClass
SET @outCode = @code_
SET @outBasis = @Basis
SET @outINCOMP = @INCOMP
SET @outINCMPD = @INCMPD
SET @outINPKDS1 = @INPKDS1
SET @outINPKDS2 = @INPKDS2
SET @outINPKDS3 = @INPKDS3
SET @outINPKSZ1 = @INPKSZ1
SET @outINPKSZ2 = @INPKSZ2

SET @outBaseQTY = '0'
SET @outQTYPERUOM = '0'
END

IF @ALTQTY = '1' SET @outBaseQTY = @BaseQty
IF @SuperEQUIV = '1' SET @outQTYPERUOM = @QTYPERUOM

FETCH NEXT FROM PWWCursor INTO @ItemNo, @SuperEquiv, @ALTQTY,
@SizeDescr, @CatDescr, @PlatingType, @BaseQty, @BaseUOM, @Whse,
@UnitCost, @UnitListPrice, @UPC_Code, @INVALF, @BOXCODE, @Gross, @CWgt,
@COUNTRY, @QTYPERUOM, @CorpClass, @code_, @Basis, @INCOMP, @INCMPD,
@INPKDS1, @INPKDS2, @INPKDS3, @INPKSZ1, @INPKSZ2
END

CLOSE PWWCursor
DEALLOCATE PWWCursor

SELECT * FROM tempLabelData order by ItemNo


However, when I create a DTS with a Transform Data Task and select SQL
Query for Source and paste in the source, it will process for a bit and
then tell me one task failed and give me "Invalid Pointer"

Any help?

I put the Cursor part in an SQL task and then put only SELECT * FROM
tempLabelData order by ItemNo
into the Transfor data task and seems to work now.