In my Dts Package Im trying to run a Data Transformaion using the following
select statements:
tblICItemMaster.ItemNumber, tblICItemMaster.ItemID,
tblZStorItemLocation.Location, tblZStorItemLocation.Quantity, Getdate () as
Updated,
tblZStorItemLocation.RecordId, tblZStorItemLocation.DTstamp,
tblZStorItemLocation.Recordcount, tblZStorItemLocation.PcId,
tblZStorItemLocation.UserId, tblZStorItemLocation.BoxId,
tblZStorItemLocation.Task
FROM tblICItemMaster INNER JOIN
tblICItemCrossReference ON tblICItemMaster.ItemID =
tblICItemCrossReference.ItemID INNER JOIN
tblZStorItemLocation ON tblICItemCrossReference.ItemCrossReference =
tblZStorItemLocation.BoxId

ORDER BY tblZStorItemLocation.DTstamp DESC

Every time I run this I recieve and Error Invalid Pointer. If I run it in
the query analyzer it runs fine. Any ideas as to what is happening?

Sorry I found the problem. I started the sql statement with Use Mydatabase, I
removed that and everything worked fine.

Thank you anyway

"bhorwitz" wrote: