I created an SSIS Package and when I run it by executing the package from within Visual Studio or by executing the package from within the SSIS interface in SQL Management Studio, I get the same result. However, if I execute the package using a SQL
Agent job, I get a different result. The first two execution methods return 30k rows and the SQL Agent method returns 26k rows. I am using the same login for everything (the SQL Agent job is being run with a proxy with the same credentials
that are used to run SQL Management Studio). I tried deleting the job and the package and creating new ones. I restarted everything. Version is SQL Server 2005. Any help would be greatly appreciated. Thanks.
View Complete Post