July 1, 2015 at 11:39 am
Hi all. I'm running into this problem in our environments and unfortunately it happens "off and on", meaning somepackages get modified, some do not and it's annoying to say the least. This happens when moving from the Dev to TEST/UAT environment and sometimes also happens in the move from TEST/UAT to production.
I've done SELECT @@VERSION from both SQL servers (dev and our test environment) and both results are the same:
DEV = Microsoft SQL Server 2008 R2 (SP1) - 10.50.2789.0 (X64) Sep 28 2011 17:10:21 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
UAT = Microsoft SQL Server 2008 R2 (SP1) - 10.50.2789.0 (X64) Sep 28 2011 17:10:21 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Currently when it happens we end up going into the package with a text editor and making the changes. I've also seen someone suggest using "/"" to prevent it from happening however we also have issue with packages with that have "<none>" where it's replacing the LT/GT symbols to hex.
Can anyone suggest where to look? Thanks
Frank
Viewing post 76 (of 75 total)
You must be logged in to reply to this topic. Login to reply