June 26, 2003 at 7:15 am
One of our developers is creating a DTS package which pulls data from a Sybase databse. When creating a transformation task she types in the sql query and then changes tab, with this the query trys to run on the SYBASE db. Is this behaviour normal, and is there anyway to stop it?
June 27, 2003 at 9:06 am
What does "and then changes tab" mean? Is the Sybase db setup as a linked server?
Darren
Darren
June 30, 2003 at 12:18 am
"Changes Tab", when she is setting the transformation properties and she changes from the "general" tab to, say, the "Destination" tab. As far as I know they're not using linked servers.
DeltaKilo
June 30, 2003 at 4:33 am
Yes when you alter the source query or data object in the sourec tab then it will rerun to validate what it has as available from the source data. But it only samples the data for the most part depending on how you access.
June 30, 2003 at 4:42 am
A-haaa.
Is there any way of preventing this as the query is pretty hefty and changing tabs becomes very much a thumb-twiddling event?
Thanks
DeltaKilo
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply