Bert Carles (11/20/2007)
Perhaps that restriction pertains to a #TEMP table? All I know is the DTS works as coded.
I still getting error invalid object name 'tempdb.dbo.DayDBStat' at the same Transform Data Task when I click on the transformation tab. I couldn't understand why?
My SQL2000 version is 8.00.2187.