Code changes in the Dtsx file in an SSIS package not reflecting after deploying and running on the server

Posted by SKumar on Stack Overflow See other posts from Stack Overflow or by SKumar
Published on 2011-01-17T23:49:46Z Indexed on 2011/01/17 23:53 UTC
Read the original article Hit count: 331

Filed under:
|
|

I have some folder called Test-Deploy in which I keep all the dtsx files, manifest and configuration files. Whenever I want to deploy the ssis package, I run manifest file in this folder and deploy.

My problem is I have to change one of the dtsx files out of it. So, I opened only that particular dtsx file BI studio, updated and built. After the build, I copied the dtsx file from bin folder and copied to my Test-Deploy folder.

When I deployed and run this new package in the Test-Deploy folder, the changes I made are not reflecting in the result. I could not find any difference in the results before and after changing. My doubt is has it saved my previous dtsx file somewhere on the server and executing the same dtsx file instead of the new one?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about ssis