Query below fails when running in SSIS package (SQL Server 2005 (Build 3790: Service Pack 2) derived from dimension package in analysis services) and also fails in SSMS with error as referenced below:
SELECT DISTINCT pkg.PrimaryBarcode
FROM dbo.Package AS pkg (NOLOCK)
JOIN dbo.PackageCycle AS pc (NOLOCK)
ON pkg.PackageKey = pc.PackageKey
WHERE (pkg.BillCycleDateKey >= 20061201) OR (pkg.BillStatusKey = 1)
I received a partial result set (should return about 10.5m rows) followed by
An error occurred while executing batch. Error message is: Couldn't replace text
Error msg from SSIS is a timeout issue (but I really think it is an memory issue).
I suspect this is a memory issue, but cannot find any reference to this particular msg on the Microsoft forums or the other 3rd party forums. PrimaryBarcode is a varchar(50)
I am not sure where to go from here. I would appreciate any ideas. Thanks in advance.