The person that use to work on our SSIS packages is no longer with the company. SQL uses my store procedures. When I make a change to my SP meaning limiting the rows. When the SSIS runs the output file is updated as well. For some reason this one package is not updating. Why do you think this could be? I am not experienced with SSIS packages. There are no errors when the packages are ran.
Are you sure it's calling the stored procedure you modified? Or it could be pointing to a different database connection. How does it get the database connection string? What are you doing to limit it and why?