tag:blogger.com,1999:blog-5098208425613902582.post7532425699498471358..comments2023-05-24T04:03:44.929-07:00Comments on Tips and Tricks for SQL Server Developers: SSIS Package Configuration in SQL Server 2008SQL BI Devhttp://www.blogger.com/profile/05174359128365572180noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5098208425613902582.post-26533139570592900242013-02-04T20:07:30.102-08:002013-02-04T20:07:30.102-08:00Thanks Grefire.Yes, I meant to load in BIDS. Albei...Thanks Grefire.<br>Yes, I meant to load in BIDS. Albeit, package variables will read the values from config file either way, we just need to define the configuration file while executing the package.<br><br>Following article explains how we can execute SSIS packages in different ways: <br>http://sql-bi-dev.blogspot.in/2012/09/different-ways-to-execute-ssis-packages.htmlHari Sharmahttp://www.blogger.com/profile/17519330349426599363noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-13672440335412943562013-02-04T13:33:48.723-08:002013-02-04T13:33:48.723-08:00In step 7 when you say "next time you load th...In step 7 when you say "next time you load the package" do you mean in BIDS or at runtime? In BIDS that's working for me. At runtime the design-time values are overwriting the settings in the file. From what I can find this is by design and a change from how life was in SQL 2005.<br><br>Could you update your article or write a new one to deal with deployment to production environments, please? You've got a wonderful style and everything above was clear. Most of everything else I've read has not been up to your quality so I would appreciate your experience with this part of SQL 2008.<br><br>Thanks!Greyfirehttp://www.blogger.com/profile/03656494429830703204noreply@blogger.comtag:blogger.com,1999:blog-5098208425613902582.post-8711129823511632010-11-14T13:21:54.574-08:002010-11-14T13:21:54.574-08:00Nice article. Thank you Hari.Nice article. Thank you Hari.Anonymousnoreply@blogger.com