SSIS Step Retriving Different # of Records When Running Alone as Opposed to as part of the whole package
Posted on 2008-06-19
We have an SSIS package to migrate data from one database to another which consists of about 100+ steps. There is one particular step, that we have noticed, which when run as part of the entire package gets 636 records from the source database, but when this step is executed by itself retrives 3000+ records. The source query itself, when run in management studio returns the 3000+ records correctly.
Has anyone experienced this before or know what might be causing it?