SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Weird variables / expressions issue


Weird variables / expressions issue

Author
Message
Brandie Tarvin
Brandie Tarvin
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143735 Visits: 9617
We have an SSIS package that is totally hosed (got corrupted somehow) so I'm trying to rebuild it from scratch. This package was built several years ago by a vendor that we no longer have ties to. As we started looking into it, we found a lot of strange things and I'm wondering if any of you have seen this sort of thing before.

1) Native SQL OLE DB / ADO Connection managers have expressions attached to them on the ConnectionString that is the same exact information as the CM would contain if it didn't have an expression attached. For instance, a regular connection string in the properties might be "Data Source=MyServerDev;Initial Catalog=MyDB;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;". And then when I scroll down to Expressions, there's an expression attached to the ConnectionString property that is that exact same information verbatim.

2) Variables have expressions referencing themselves.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABKsAAAB0CAYAAABKWbFhAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAACLmSURBVHhe7d0NeBT1vejx3xIFrKJgfQNfGxJiU2glpdGGc+rxKCBwPQoVtFetsacNcj1qrM3Th8q5tz1ymnsPfQnofVCe057Y2udYooLlBJSUe/tyiSVyolWMhsT4VsFXoGgBeds7v//8Z3d2d3Z3NtmETfh+nmfIzH9mh92dnZn//Ob3/09EvrMlKgAAAAAAAEABGGb/AgAAAAAAAEcdwSoAAAAAAAAUDIJVAAAAAAAAKBgEqwAAAAAAAFAwCFYBAAAAAACgYPA0QAAAAAAAAMj//foE+ZtPjbJTcY3tH8gtj71mp/ofmVUAAAAAAAAwnty2Ry77121mePvDg7Z0YA07fOMYO5qo+sbJkm5eNua19xZLdTRc0pYu33nlSDsVLMwyAAAAAAAA6L23Pzoov3n1QzPsP9T7xng/nn2uRP/58/L7mjI5aXhqrpSW6TxdRpf1GyZlY1KDStExMrdMpPnFnbYgN40PPytF/9gjjZGILQEAAAAAAMCx4q7mN6Wh9V35q/NPkvXVpQkBKx3XMp2ny+iyfsOa5RSZW2GnPBVjZLb8WR5vt9PHmPkTx8jpJx5vp1yUUaYoo0xRRpmijDJFGWWKMsoUZZQpyihTfSkLy8tayjQkZysdDUEBq2yBKlU04vr/8d1vnfGx/NPz+22RSPUVF8jVH7wtc19wys4aJ53fLpH7rjhbvnv5OPnvn43I2qf3yNuaNRUdKT+4a5L8w8cfy1du+7Q8/LefkDf+z0656KYK+eW43XJ/9yF3hZnW4bjos2Plr/e+L5tKJsiOW87LuExsnY7JV5bHl79sjJz80ruy4SObzTW5WKK3FwfPy2L3/sOya98hOeKMR+z/TxlllFFGGWWUUUYZZZRRRhlllFHWn2VhPdW1R0afcJxccu6JtiRRuiBQNtUVnzTv64mXdpvp2qoznf+nSJ7bsS9Wlivvvc6fNEa+9KlRcuNFn8wYqFIRadoZPTxX5O8Xv+I22zMBqE/LhN+2y989G5HJVxbLDc+9It96Oz7vrvdfk6KHd8Wmr5I/y9pH7DIO7V9q0fsvSdmTbgAs4zocuvy/fXqYbPv9i+5r0iyTuM5y2XLhbpny47fkWX3fk4sl9jnGni2dt42Wtf/7Rff/nDxOfrDjrdj7C2uMs0FGHlckOz48YEsoU5RRpiijTFFGmaKMMkUZZYoyyhRllCnK+lYWlmZP1VadYadcvQ1UKX0a4Gu7DsSe/PfqtybJBWOG5+VpgPddda78wyXue73/D+/K7WvTv8dh0r5LmmWkTBxrS8aeKld9Mt4E8Nkne+JBnsh++dZv/yxy2gky2d/P1cvbMwaCwqzjyEs9sUCUWeaRd6S7bKz84KyAzryiY+R7U52N8ogNVKn27fLjD/xNGvfL1h129NnM7y+dk0ccJ6efWOSMxd8DZZQpyihTlFGmKKNMUUaZoowyRRllijLKVF/KwvKa2Xn6EqjSrKqzTjpeSj45wozrcNIIt58pr6y3tOnfRWM/YafEjPv7sEoWke9sifqzlkzG0mk7YhlNSsva//oEOyVy5L0dbkaTnJCQheVJzoJSadcRiQQurwGpXy0ZK9tsdlTCMtrE79rgJxWufXSL/F27+77uPn2YO+17b2Gc+oki2fPxEefLESly3t/+Q0coo4wyyiijjDLKKKOMMsooo4wyyvq1rLe8/ql6G6hS2s9VNpF7/tOOhZfcR5XSbLD/9/pHMrOxSz46kPq5TRir8cU/S8mFp8rk6Ei54cIR8acAasDo3smmuV3Fd7aYNxV5NB7ECiUf6whw5MguucVbn28wgSnNzGp4ViL37ZCyuRVy+N7i1CceZjBl3IkyaniRHDwcjf1YKKOMMsooo4wyyiijjDLKKKOMMsr6s6y3NEjVl0CV8sdWPvWDF0yZ/vWX5yqoM3UddNzf6Xoyk1kVy2J6fLdcNXek1Hv9V2nH6Lf5ph0JfUWFyazKtg6nTJf/icT7pzL8fVDZZRLX6euTKhOvX62XkzK3AAAAAAAAkEL7qdL+qjRYpX1Y9UZQoMrP628rKMPKDV9FdsnjnSPk7mvHSknnrlhQyeXrz+qscfLI1BF2IhfZ1zHs08Xyq8k2+0mDZ3NPke5N25Pei/X2dql33u9dt42PZ0xpUOrGcW4/WJN967I639lnxwAAAAAAANCfrv/sqdL9wceyaMNbgVlfWqbzdBld1i+Wa6VNAVWsCaB6e7tcv0nk7tunmLaLh693/rPH3eVCC7mObb/vkW2XVphlot8vltmdr2XMhGp8+Fn5+85T5N++7643+v3PyFXv73Q7XN+x3zT/i5W//FLO/VYBAAAAAACgd/51y/vmCYL/87dv25JUOk+X0WX93GaAAAAAAAAAgCMfzQD7gmAVAAAAAAAACkZql+sAAAAAAADAUUKwCgAAAAAAAAWDYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMCJ79+6N2nEAAAAAAADgqCKzCgAAAAAAAAWDYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMAhWAQAAAAAAoGAQrAIAAAAAAEDBIFgVYNmyZVJUVGSnAAAAAAAAMFD6PVj12GOPSTQaTRm0PB82bNgg7733nrzwwgvy0ksvmbIdO3bImjVr5Omnn5bNmzfHygEAAAAAAFDYInv37o3acRPwUZMmTTJ/VVBZrjQwNXfuXPnZz35mxr/85S/LV7/6VXn88cflsssuM8uceuqp5m+u9P3df//9cvbZZ8uMGTPkww8/NOO/+c1vzPTzzz8v11xzjV06HM2s+uY3vymHDx+2JcFmzZplx3Kzbt06OwYAAAAAAAC/WGaVBn00IHXBKXvN9JZ/LjZ/dVrLvaBVrjSLSgNVSgNUGqjSgJUGrrR837590tPTI6tWrZKdO3ea5XLx2muvySWXXGKyqDSjauLEibJixQqZMmWKnHPOOVJRUWH+v96sGwAAAAAAAAMroRngh29sls6ff0V2b2uRURdcbP7qtJYrzTTKlm0U5Oqrr44NXvM/L2A1btw42b59uxw8eLBXQasvfOELUlpaagJhP/nJT+T222+XadOmyfDhw+XrX/+6LF68WEaOHCkfffQRQSsAAAAAAIACl9AMUJlA1XkXS9HIk+Xw/j0mUDV6wjQzb9euXebvu+++KyUlJaE6IdfMKg1SBfGaA77//vum6Z0Gq2bPni1lZWVm/IorrsjaPFCDUC0tLabp37333itHjhyRH/7wh/L666+bzCr1yCOPmOnrrrvOZIk988wzpvlhunXn0gxwzeon7FQ418y5mmaAAAAAAAAAaSRkVmnTv3ee+akJVCn9++EbT8sHLzwuGzduNAEcHf70pz/Jnj17pLOzM1Sm1RNPPBEbNEClvECVvn7UqFEmA+qee+4xfUz96Ec/MplWGmDKRJv9bdq0yWROfe9735Pp06fLggULpL6+3mRcaUBt/PjxZr3f/va35Xe/+10s00rXDwAAAAAAgMKSEKyack+PnPmFr5mMKs+2yFT51o/WynPP/VHu/aclZtBxf9Aqk+eee046OjrMeHIH6xqoOnTokJl34MABE/x68803TQbXww8/LKeddpqZl86wYcPMkwCXL18uVVVVsnDhQpOZ9Y1vfMMEvHS+0sCUrlvfry6vHbKfccYZZl4+aLaUDv7xoAEAAAAAAACZxZoBvvjii3LeqI9MH1VlN/27tHV9ZAJGEydOkuvmXxcL7mgTwF+u+qVs3PhrM52tSZsGszRzKpkXqNIg1a9//Wt59NFHY80MPStXrpRzzz3XTqXS11977bVSXl4udXV1Jsvq0ksvlRNOOEFefvllk6WlTRBvu+02eeedd+yrXPq+I5GInUpEM0AAAAAAAICjIxas8p4GqH1UaZ9VGohRl19+hQlWKX+QypMt8KKZUjU1NXbKNWbMGBNkUkFBKk+2YJX2h+W9Vvur0gCV9kOlmVvnn3++TJgwQU466SRZv3693HfffWY5Tz6DVV7WlH88iDefYBUAAAAAAECwhA7WNWClNGjlBauy6U2wKqwwwaqbbrrJdLL+8ccf29I4bUboNQXUjDC/fAarckGwCgAAAAAAIL2EPqs0SKXDYPLBBx8EBqqUPmVQg1TJgap80wCUl1HljQcNAAAAAAAAyCwhWJWLM888U+6+++60Tfj64nOf+5x5at/mzZttSf5ccsklpkngk08+aUv6TrOrvAwrbzxoAAAAAAAAQGaBwSoNQGkgSgNSybwglT5t75xzzpGTTz7ZzgmmAScNPGkAKhsvSDVlyhQ57rjjYv1apaMBJw08aQAqGy9IVVlZabKxZs6caecAAAAAAACgUCT0WeXRvpq6u7vNEwDb29vNUwHVjTfeKBUVFaZZXUlJiRQVFZnybDRgpX1XjR07VtauXSt//OMf7RyXBqmuuuoq2bFjh+mj6uKLL7ZzstN179y5U0pLS+UXv/iF/OEPf7BzXBqkuuGGG6Srq8t0vh5m3bn0WdUb9FkFAAAAAAAQLDBY5fEHrVSuQapkyUEr1dsgVbLkoJXKNUjlCRusAgAAAAAAQH5lDFZ5vKBNb4NUybygleprkCqZF7RSuQapPASrAAAAAAAAjo5QwapjDcEqAAAAAACAo4NgFQAAAAAAAApG4NMAAQAAAAAAgKOBYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMCJNj63laYAAAAAAAAAoCJGow44DQJ9s375dxo0bZ6dQCNgmA4fvGgAwVHGOA+A3EMcEmgECAAAAAACgYBCsAgAAAAAAQMEgWAUAAAAAAICCQbAKAAAAAAAABYNgFQAAAAAAAAoGwSoAAAAAAAAUDIJVAAAAAAAAKBgZg1XrF0QkEpkqy7ptgU/3sqkSWbDeTgFAOO5xxTdwHDmqzLHcvz3sMDXowI9eM7/7NL/1TPP8dDm2CwCgEAXXJ4KvIwuVW0ddINRMgcIQIrOqVWpvXiZUjwH0TbcsmxqRWbJOotFobFhXvo3jy9FWk7hNotF1MrG2NPcK2/oFEpnax/NFPtZRgGZeUyOyck3A97le1qx0NsE1M+00AACDVEp9YpPcWWLnDQIzH9T3/KBwRgYKQ9ZgVVVDg9S01srN3M0F0BfdzbKqtUoa6hKrADPvvFMGUT3mGDFTHox2SUPVSplF5lt+zLxGamSlrEn+OtevcUprhFgVAAAAEBcis2q2PLiuRlprl2a+w969TKb60z6T7oy7zRfWm8wKbxlzDZTwutS7+IkppYMrlRSAT8kEmSit0tFlp9NITiP3x0pSUsyTAileM6mE5QKydDiuhFEidy5OygbKcJw3qfOzVopzspBSnedtmyznBr+gdZiypO1stp9dz+DZ5jPFTa5K+s26aVXuXdwcvivnlbIg+XOY1yeeR/mtAwCONvdc5D8/udn23vk9+7ncXX7Bej336fz4ujKe5zRbO2hemnLvffglrt8ZEuok3vuynydpfQD6JlwH6zMflHU1me+wdzd3yPwuL+WzSxrEudhIWr61donIQ+4yXQ1VsnKWs0PfrEX2NUl38fXgULpqvnR5qaTrJkptaY7NUgAUiJlSZ/f7dP3umH2+dqKs8/b5rgYpTzdPjxlbZ6UEMlprS+VmeSi+TNKxiONKDkrLpUq2yja7uTId503q/LoaTcd1v9sH3VShMOcGT9A6TPO5rf6mot3SvKpVahbHM/IGyzZPbQrYLdu2xpsA5vJdhcFvHQBQCErufMhc5y2x9b/uZTc7ZzjnXG/rCirbuVxtXbJGys150m2ql/E8pzdwZm2VBu+8um6+lqYvDxC27rlylrmgNcusq6ELHSBvnJ0qLeeaIVrl7MlGV0O0Sqqi8cmqqNQ4u24662qizgVH1C5u1pW4/LqoU22PJhb5X6Pz4/+fqyvqXOsmvgZAwXjrrbfsWAbmWOIcD5whdnwxAo4JMUHHA4dZV40z15V6nHEkHLuOveNKtm2S+Vie5nv3JB3nU6aDZFsmZX7SeyjgbZ7995/5s6RI+i4SzslBnythfQP3uQEAQ1+o+oSt38UG//k8do5KPT9lP5e756/UemOG81y6c2yGc2/W86xKeH3A+8qwfmAoCXXd10fhMqtUyZ3yUINkjBRr9DmWIqlNOZJUlZfaMU+VpBR5TD8erVJb6qVU6lAqta12PoDByTmWbDJ3srR5cWn87lSmvnvMvIkyIblzK9O0MJ75o1KOM2YZi+NKbrq3Od9uomzH+SC9eU2cNp9rlVXN9m5s8ypp9ZrNWYNnm2f/LH37rnz4rQMABlpyB+ubfP2SOvW/xdpSJzJLVtYsTul4PeO53JrorwhmO8+VzJb5Vfr/JXYpkbY8WQ51z4T3ZSTOB9A74YNVjpI7F6fpbN1tP5yYhllj5/VFjS/tMj74MkYBDFYzHzTN/KpWLhngtv0cV0Lr6pDWqvky29TBenOcz8+5QZvPta5qlm6vCWDOvZEXzjZP/1n64zzKbx0AUDhKy6vM39QEht7KdJ4rkTs3OdNOXXOrdj0T6+cqXTmAQpNTsErvCnudrTfbEsPcfXcOFr7oebd2xNEXSX2lABiCzN0p2+l6pn0+3Txz7Em869Wa3IO7/84Yx5UcrJcFs1bG+4bqzXE+X+cGfZJe6yppXq9PlEzNvhtU2zzdZ8nHd6XBRTvKbx0AUFC6l8nN2v9Tl2mqk3KjMuO5PEjY85zJ6O9K6DPLSFfuyaHuCaB/5BisctjO1mtT2hL4dmZzMOpjWwOTKqqpnf5od7csW0CHdcCgpB1aJuVbdy9b4lRE7AV70D7vvGaZTqQ7HtxcK9JQl9CMSlbO8qV1uwGXKm8Zjivh6LYyafrrkrJwQhznWzsksbrZi3NDyjps87klqc3mjEG1zd3PUjurNuCz5PJdlUp5lbOepd6ncj93DL91AEDB8NXZnPNTYNcymc7lQbKd59YvSGnmZ5rrpStPlm79QXVPAP0i92CVY2Zdg7hJnJZ30PHaDOsDEfLQDFCfDGWeQqjrNEOprCqfHbvrDGAQ0SwqpyIS71cgYp+w4j7RRaXs86Wr9Jo8Nq+rYWvi8WB+l2xK6vSgqmGdlC/xlnEDLv5lOK4ESNoukdIOWayp9P5IVZjj/Mw696muOl9rgr05NySvw9LzjqYNNdSlVg8H2zY3TwV0JDRnzPm70mYM66Qmtu3WyDXarNbOVfzWAQADKrk+4Qx6Kl+/oNQ8/e8he24O6lom27k8SMbzXGm5beZny506o6nWpCsPELbuCaB/RKLasBcA8mD79u0ybtw4OzXw1i+IyJJyKhF+R3ub5M36BRJZUi5d/s5aHYW0zYfMdw0AQJL+PMdRfwMGn4Go9/YqswoAgIHTLcuWrJSq+WQFAQAAAMcCglUAgIKld1s17b52YvbmAAAAAACGBpoBAsgbmkEVHrbJwOG7BgAMVZzjAPjRDBAAAAAAAADHFIJVAAAAAAAAKBgEqwAAAAAAAFAwIrt3746OHj1anL/S338BAAAAAACATEywyo4DAAAAAAAAR9WABKvIrAIAAAAAABg6Nm7caMfyj8wqAAAAAAAA5ESDVVOmTLFT+bNly5aB6WBdM6sAAAAAAACAbAYkWEUTQAAAAAAAAIQRKlj1w5Y37VjvkFkFAAAAAACAMLIGqzRQNfK08/oUsCKzCgAAAAAAAGFkDFZpgOrE08+XokjE/O1twCpsZlVL7Whn2emyoscWpGiRWmddo2tb7HR6Zl1plss0Lxv3PdY67yQcXX56+g9khFkGGErc/cg/ZNrvw+qRFdNHSy937TwrpPcSXsp26cUHyPUYeWxzfyejp69wxlL1rJieuD2cId25InVZtgEA4ChrqU06NzlDmnOef1m3+pGhLqXLpltPP3HrN1ynZpSyDYG+SRus0sDU6LPOl+OLJDbodG8CVrllVrXJ6qeCd4ieFUulo7LSTmU2bXa1SGNzwM7aIs2NItWzp9np3Exr2O18ngbp3asBeCrr282xQYf2epFFFfkIWB19bkWhQha12YJBwa0QzpOm2DbRoamsO14RDFkx5BiZg56nZLVUSmXbaklz2nNOVr5t4u4oSRVAd9tVLCqXJt+2290k0kxFEQBwVNibMUvLpN1/btKhrlMq0gUz7DmvoWArEVynZjStwWy/JufjAfkQGKzSgNTp4y6Q44dFUgYtzzVgpdHVsCqdnbxt0fKAnbdHnlqdw9XftNlSLY2plfWWZqe0Wnp5DADQD4oXPiD1lekrAINGS63Ma6yWpt1NzlFmENGgSVul1N+ReGCctnChFNtx5F/L8kUicx6Quuo2WbQ8RGSpeKGzrNZv48v2rLhVFkm9czGQVDl1KoyFW9kHAAxlLbUVsnpOu+zeEFCP0IBGe710zBt8Nym5TgUGVkqwSgNRZ59bLMOLhqUddP70f2y3r8hOI6yhzalzLlqDdt7lpkJeN8dOO4LSJE1TCHP3f5q4QevE+S1uuNqt1PeskOk2VdEMCVkDXuqpTem0KZUpqZAZ1xGX0EQjRHZCYpOOoZFxAoQSYp9KbvIUnGps7+p56dAh1utmRcXnt+j/E3SMia0nad80d5QGYVZRcYmUS5t0vmKnk5jvZZ5z7GxbZO6Gut9JmGOkt4y3LQK+M0eY733o0bunlTJnRrFMu6NeKgPvsAarLBtvx1pk+aI2qa4jqAgAKBB6466jXh5Y6J6Z/PWm2tpat45QvFAe0GThMDdqwvA1P0uuZ6SvtwXUY0xd0S7jH/dwnWpkrAsDeZQQrNJA1acuGC/DiyJy8rvPSumRV6XkSI+UHHrF+fuqlMnrcv7HXXLOvk757rVj5Oe/arWvzEx/yOGNlxlzKqVxaeKOojtv5ZwZztw4k0LZ4Wum4oxpVNuruKemWPZId0c8tbLnqU6Z0+6lpbY7hxjnQizpoNKxtFnKzDLBF6Bh1tG2qEJulQcyLuOnB4CK1XPiabNN5bKowl5wA0NYeUlx1n3K7B/+Jk/t9c6xKZXe1fNnnGRbr57gtXIV2+/qOmVeUlu+obtvTpM76p3j7rzgfglMWrnmdFfa78eXspPtGKka590q8oD7nTVpFtGt8eN7mO99SNK7p5VzZIaerIpnyJygym8ym7lXZy8AuAMLACg03jWbnqkS603tUtbRaOp6qnjGHKlMuI7rJQ3IzOuQeq+O1xSPGIWpt4Wpx8Rxncp1KgZSLFilgaoLx5fIiKKIGc447RT52y9+Ri7/4kS5fOok5+9npOzcU+TKL31OZv/NZJn5pYukKHLAvjoz/SHnonhhnVT7+/BwDkJL/RV0j6ZQJiynTVl8FXeTYtkh3WnmFy9skPgqi2Whtq9IPmjOucO3TKpQ66hukg2xhZxlHtC76EvTRKH1TrlI/QO+O+XT7giO4gNDhAks2X0z8z5lM0mafCfl4oWyMOkMHQuA+NLPs61Xs1wS97uGpDb3Q3vfLF64IdYnkt5gCApaBcpyjFSV9Q/EljFZRG2d4iZxhfnehyZ/ZV5/j6byG/RDapwXv3s5rzHxtw8AQEHRgIubNazjT63215uKpaTcjPSDcrExMKce4dQLzXjIepu/HuPUKTfs3uBO+8d9uE7lOhUDJxasGrP/TXn5lW4ZflzEDEeOHLFzRA4ePCT33HOPXDNnrmxu2yJRX3kYuWVWKU2NjPdf0+Mc6dq8lMgE2ZbLvh6NDvsvBJJ50f9Msq0j3mTDMk1u0jB3ytuc60W7PjMMts6agez0To73G3cza+IX4Wn3qRCZJB1Lp7v9RgX0k5B2vT3dTnXBV9Gxxpf5Oso8FvZNUzHTu2TV7vbJcGfNE+YYmbqMrZyF+d6HIlOx9SrzLnOHOahy6O9gXe9KL3V+dyG2CwAAhcUNZMUui17plLbykpS6Ws5sdvI8p16WcHoMWW8LU49JxHUq16kYKLFg1YHDx8uJf3lbnu/sMs0AozYitXPnLln6L/8i3c6VxaqmR+Wcc86Tg4fFBqwi5t9scs2sUnr3XUwHdjYqn9Txr0dTKNtWP+UsZVMrk65i08932/gmpjHmejs/H+sIoh002/X5BjrLxVDifxpgvAPOfO1TvjtVRpb1aoXJjmZ2jOybtvPT9HfW8iT09z60mAppcmWvYpEp8yqtwZLueI4vk8qU3zoAAEeLZk/5+8D0jWu/Tm3edI+sWNqYct0WpCPrSc45N25w6mOm03Y9p/qbpPVPvY3rVLs+38B1KvpDLFi19/AIM0T27JItHdskaqNVBw4ckGe2/Kfs27dPRp9yspw97gx5480/yUGNWIWLVZmKeM68PjxqtcM6269HEC/FsiUptdKTbr65o5+YfdGjDYVzEXIdbcm9FpuodGo2gcHFB45l2fapEPtHed0GcVuz+Tp87OV6X+n0hVKOtX0zS6freRHmex9y3AppQrDWDu31lbbSmo09f5jzZFv+OqgFAKCPNADjNmt3b7C4ASRnaJ5tgiXaP6Zm43TWZQtwuE3kU66jHKYj8uSsLJMd3m6apC3VCmB/1tu4TgUGRCxYtWPfGfKXgyPNsPeDfbHMqrPOOlMmfXaSXP+V/yoNDcvk+/X/Sx5d9UvZs+cvMmxY7OUZaSU8d2672sZGf78eQWwK5dLMKZiL5i0KmO/b2XpWyK29ymEMsY7Geb601Bapned8pvo7At6rwznQmseYJ3RU1yMrarM/mQEYGjLsU0H7h7PMiqRrde1/yQ1Y+fejTOu1F/2+jr/dzqztuBrK+6bzfUxPalrWs2KpU1lJqljF+prKkzDf+1Bj+qRIbALoMU0B2xZJ+tiT83u71X8u07vJTVKt/VolP73H+R5pLQgAGHDah1GHvfbxuhfQQSNT5qnJ7nSYTBy3ibz/Osph6gmV8WymgPOdaR7Xm3qb1ocyPQ0whuvU0N8p0AexaNPSG8+SnftHxQJWR6Jisqv+su+AtG3eLJ848UQZVnScLGv4sdzytW/ImDEny6FDh+2rM+tVZpUyHc8FdFiXxKRiOvtephRMlZB66exs5pGpXjMMfVhVrqmRIddRWd/k9jOiy4yeJ40JHdml0idvNVW7ba/d11TI6rJMB0JgiAixT6XsHxWrJeHxK5YGrLzlal/Jtl696LdPQPHW2zzbZLr4Ddl9U7Oo/B15O4P7xEVfZ962A03z2fMWBQn3vQ8lLcudCqn3FMBkJninDwfyfb8J26VCFpU3JTyN0dkw0uA9vSe2nDMsLZM0p0QAAPqReyPFqTAE1hdaatMFgAI49cINseZ9djBP/vN1fD6+zDffqZfNaY8Fwvq13sZ1qn0N16kI8NpPZe75c+Wnr2UYDyGye/dum0PluqtxhxyKFslNlQflwvNOkdtu+29SWflF+fyUCjlp1Bh57733ZPjwEXLl9Mvl/sbH5JZrr7CvPIpaak3F3P/kLwDoK32q4NKy9ownbeQf3zsAAIOfdu5dkZzNow8OCUqr0us5bSoYJuVqMDkGr1O1Htc8m36sjhUbN26UKVOm2ClLg1KX/of8l98+Ll+TNOMX2GXT2LJlS2qwSmnA6rrPH5QZfzVJtr74spSUTJCRI+JN/vQF2l3V8sY1cvOcy0xZJhp11XTP/tEjK6a7UXQubADkjVYu5klidhH6H987AADHHnP+d/sBqG4aKoGOY+w6dUhuQ2QTGKzKg7TBKvXzX7XKcZGDEhlWJAcPHpRDh90mf2Zh55+iomHS9eobsuSbOaYk5pFGbc3+kC5CDwAhxY4nMdUETAYA3zsAABhquE7FseKoBKvyqX8zqwAAAAAAADCQ+jNYFe5xfn1EoAoAAAAAAABhDEiwSjOrAAAAAAAAgGwGpBkgAAAAAAAAhg5tBthf6LMKAAAAAAAABWOY10SvP/8SqAIAAAAAAEAYNAMEAAAAAABAwSBYBQAAAAAAgJz0X59VIv8fGun9aikQPK0AAAAASUVORK5CYII=

Has anyone ever seen coding like this before?

There are a lot of Script Component transformations in a group of Data Flow tasks (Given their position at the end of the precedence flow, I think they're Destination instead of Source or Transformation types). I'm not sure if that has anything to do with it. But I'm really weirded out by this. It seems to be a lot of ridiculous redundancy to my eyes.

Thoughts?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (194K reputation)SSC Guru (194K reputation)SSC Guru (194K reputation)SSC Guru (194K reputation)SSC Guru (194K reputation)SSC Guru (194K reputation)SSC Guru (194K reputation)SSC Guru (194K reputation)

Group: General Forum Members
Points: 194915 Visits: 23765
Brandie Tarvin - Friday, February 23, 2018 7:52 AM
We have an SSIS package that is totally hosed (got corrupted somehow) so I'm trying to rebuild it from scratch. This package was built several years ago by a vendor that we no longer have ties to. As we started looking into it, we found a lot of strange things and I'm wondering if any of you have seen this sort of thing before.

1) Native SQL OLE DB / ADO Connection managers have expressions attached to them on the ConnectionString that is the same exact information as the CM would contain if it didn't have an expression attached. For instance, a regular connection string in the properties might be "Data Source=MyServerDev;Initial Catalog=MyDB;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;". And then when I scroll down to Expressions, there's an expression attached to the ConnectionString property that is that exact same information verbatim.

2) Variables have expressions referencing themselves.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABKsAAAB0CAYAAABKWbFhAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAACLmSURBVHhe7d0NeBT1vejx3xIFrKJgfQNfGxJiU2glpdGGc+rxKCBwPQoVtFetsacNcj1qrM3Th8q5tz1ymnsPfQnofVCe057Y2udYooLlBJSUe/tyiSVyolWMhsT4VsFXoGgBeds7v//8Z3d2d3Z3NtmETfh+nmfIzH9mh92dnZn//Ob3/09EvrMlKgAAAAAAAEABGGb/AgAAAAAAAEcdwSoAAAAAAAAUDIJVAAAAAAAAKBgEqwAAAAAAAFAwCFYBAAAAAACgYPA0QAAAAAAAAMj//foE+ZtPjbJTcY3tH8gtj71mp/ofmVUAAAAAAAAwnty2Ry77121mePvDg7Z0YA07fOMYO5qo+sbJkm5eNua19xZLdTRc0pYu33nlSDsVLMwyAAAAAAAA6L23Pzoov3n1QzPsP9T7xng/nn2uRP/58/L7mjI5aXhqrpSW6TxdRpf1GyZlY1KDStExMrdMpPnFnbYgN40PPytF/9gjjZGILQEAAAAAAMCx4q7mN6Wh9V35q/NPkvXVpQkBKx3XMp2ny+iyfsOa5RSZW2GnPBVjZLb8WR5vt9PHmPkTx8jpJx5vp1yUUaYoo0xRRpmijDJFGWWKMsoUZZQpyihTfSkLy8tayjQkZysdDUEBq2yBKlU04vr/8d1vnfGx/NPz+22RSPUVF8jVH7wtc19wys4aJ53fLpH7rjhbvnv5OPnvn43I2qf3yNuaNRUdKT+4a5L8w8cfy1du+7Q8/LefkDf+z0656KYK+eW43XJ/9yF3hZnW4bjos2Plr/e+L5tKJsiOW87LuExsnY7JV5bHl79sjJz80ruy4SObzTW5WKK3FwfPy2L3/sOya98hOeKMR+z/TxlllFFGGWWUUUYZZZRRRhlllFHWn2VhPdW1R0afcJxccu6JtiRRuiBQNtUVnzTv64mXdpvp2qoznf+nSJ7bsS9Wlivvvc6fNEa+9KlRcuNFn8wYqFIRadoZPTxX5O8Xv+I22zMBqE/LhN+2y989G5HJVxbLDc+9It96Oz7vrvdfk6KHd8Wmr5I/y9pH7DIO7V9q0fsvSdmTbgAs4zocuvy/fXqYbPv9i+5r0iyTuM5y2XLhbpny47fkWX3fk4sl9jnGni2dt42Wtf/7Rff/nDxOfrDjrdj7C2uMs0FGHlckOz48YEsoU5RRpiijTFFGmaKMMkUZZYoyyhRllCnK+lYWlmZP1VadYadcvQ1UKX0a4Gu7DsSe/PfqtybJBWOG5+VpgPddda78wyXue73/D+/K7WvTv8dh0r5LmmWkTBxrS8aeKld9Mt4E8Nkne+JBnsh++dZv/yxy2gky2d/P1cvbMwaCwqzjyEs9sUCUWeaRd6S7bKz84KyAzryiY+R7U52N8ogNVKn27fLjD/xNGvfL1h129NnM7y+dk0ccJ6efWOSMxd8DZZQpyihTlFGmKKNMUUaZoowyRRllijLKVF/KwvKa2Xn6EqjSrKqzTjpeSj45wozrcNIIt58pr6y3tOnfRWM/YafEjPv7sEoWke9sifqzlkzG0mk7YhlNSsva//oEOyVy5L0dbkaTnJCQheVJzoJSadcRiQQurwGpXy0ZK9tsdlTCMtrE79rgJxWufXSL/F27+77uPn2YO+17b2Gc+oki2fPxEefLESly3t/+Q0coo4wyyiijjDLKKKOMMsooo4wyyvq1rLe8/ql6G6hS2s9VNpF7/tOOhZfcR5XSbLD/9/pHMrOxSz46kPq5TRir8cU/S8mFp8rk6Ei54cIR8acAasDo3smmuV3Fd7aYNxV5NB7ECiUf6whw5MguucVbn28wgSnNzGp4ViL37ZCyuRVy+N7i1CceZjBl3IkyaniRHDwcjf1YKKOMMsooo4wyyiijjDLKKKOMMsr6s6y3NEjVl0CV8sdWPvWDF0yZ/vWX5yqoM3UddNzf6Xoyk1kVy2J6fLdcNXek1Hv9V2nH6Lf5ph0JfUWFyazKtg6nTJf/icT7pzL8fVDZZRLX6euTKhOvX62XkzK3AAAAAAAAkEL7qdL+qjRYpX1Y9UZQoMrP628rKMPKDV9FdsnjnSPk7mvHSknnrlhQyeXrz+qscfLI1BF2IhfZ1zHs08Xyq8k2+0mDZ3NPke5N25Pei/X2dql33u9dt42PZ0xpUOrGcW4/WJN967I639lnxwAAAAAAANCfrv/sqdL9wceyaMNbgVlfWqbzdBld1i+Wa6VNAVWsCaB6e7tcv0nk7tunmLaLh693/rPH3eVCC7mObb/vkW2XVphlot8vltmdr2XMhGp8+Fn5+85T5N++7643+v3PyFXv73Q7XN+x3zT/i5W//FLO/VYBAAAAAACgd/51y/vmCYL/87dv25JUOk+X0WX93GaAAAAAAAAAgCMfzQD7gmAVAAAAAAAACkZql+sAAAAAAADAUUKwCgAAAAAAAAWDYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMCJ79+6N2nEAAAAAAADgqCKzCgAAAAAAAAWDYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMAhWAQAAAAAAoGAQrAIAAAAAAEDBIFgVYNmyZVJUVGSnAAAAAAAAMFD6PVj12GOPSTQaTRm0PB82bNgg7733nrzwwgvy0ksvmbIdO3bImjVr5Omnn5bNmzfHygEAAAAAAFDYInv37o3acRPwUZMmTTJ/VVBZrjQwNXfuXPnZz35mxr/85S/LV7/6VXn88cflsssuM8uceuqp5m+u9P3df//9cvbZZ8uMGTPkww8/NOO/+c1vzPTzzz8v11xzjV06HM2s+uY3vymHDx+2JcFmzZplx3Kzbt06OwYAAAAAAAC/WGaVBn00IHXBKXvN9JZ/LjZ/dVrLvaBVrjSLSgNVSgNUGqjSgJUGrrR837590tPTI6tWrZKdO3ea5XLx2muvySWXXGKyqDSjauLEibJixQqZMmWKnHPOOVJRUWH+v96sGwAAAAAAAAMroRngh29sls6ff0V2b2uRURdcbP7qtJYrzTTKlm0U5Oqrr44NXvM/L2A1btw42b59uxw8eLBXQasvfOELUlpaagJhP/nJT+T222+XadOmyfDhw+XrX/+6LF68WEaOHCkfffQRQSsAAAAAAIACl9AMUJlA1XkXS9HIk+Xw/j0mUDV6wjQzb9euXebvu+++KyUlJaE6IdfMKg1SBfGaA77//vum6Z0Gq2bPni1lZWVm/IorrsjaPFCDUC0tLabp37333itHjhyRH/7wh/L666+bzCr1yCOPmOnrrrvOZIk988wzpvlhunXn0gxwzeon7FQ418y5mmaAAAAAAAAAaSRkVmnTv3ee+akJVCn9++EbT8sHLzwuGzduNAEcHf70pz/Jnj17pLOzM1Sm1RNPPBEbNEClvECVvn7UqFEmA+qee+4xfUz96Ec/MplWGmDKRJv9bdq0yWROfe9735Pp06fLggULpL6+3mRcaUBt/PjxZr3f/va35Xe/+10s00rXDwAAAAAAgMKSEKyack+PnPmFr5mMKs+2yFT51o/WynPP/VHu/aclZtBxf9Aqk+eee046OjrMeHIH6xqoOnTokJl34MABE/x68803TQbXww8/LKeddpqZl86wYcPMkwCXL18uVVVVsnDhQpOZ9Y1vfMMEvHS+0sCUrlvfry6vHbKfccYZZl4+aLaUDv7xoAEAAAAAAACZxZoBvvjii3LeqI9MH1VlN/27tHV9ZAJGEydOkuvmXxcL7mgTwF+u+qVs3PhrM52tSZsGszRzKpkXqNIg1a9//Wt59NFHY80MPStXrpRzzz3XTqXS11977bVSXl4udXV1Jsvq0ksvlRNOOEFefvllk6WlTRBvu+02eeedd+yrXPq+I5GInUpEM0AAAAAAAICjIxas8p4GqH1UaZ9VGohRl19+hQlWKX+QypMt8KKZUjU1NXbKNWbMGBNkUkFBKk+2YJX2h+W9Vvur0gCV9kOlmVvnn3++TJgwQU466SRZv3693HfffWY5Tz6DVV7WlH88iDefYBUAAAAAAECwhA7WNWClNGjlBauy6U2wKqwwwaqbbrrJdLL+8ccf29I4bUboNQXUjDC/fAarckGwCgAAAAAAIL2EPqs0SKXDYPLBBx8EBqqUPmVQg1TJgap80wCUl1HljQcNAAAAAAAAyCwhWJWLM888U+6+++60Tfj64nOf+5x5at/mzZttSf5ccsklpkngk08+aUv6TrOrvAwrbzxoAAAAAAAAQGaBwSoNQGkgSgNSybwglT5t75xzzpGTTz7ZzgmmAScNPGkAKhsvSDVlyhQ57rjjYv1apaMBJw08aQAqGy9IVVlZabKxZs6caecAAAAAAACgUCT0WeXRvpq6u7vNEwDb29vNUwHVjTfeKBUVFaZZXUlJiRQVFZnybDRgpX1XjR07VtauXSt//OMf7RyXBqmuuuoq2bFjh+mj6uKLL7ZzstN179y5U0pLS+UXv/iF/OEPf7BzXBqkuuGGG6Srq8t0vh5m3bn0WdUb9FkFAAAAAAAQLDBY5fEHrVSuQapkyUEr1dsgVbLkoJXKNUjlCRusAgAAAAAAQH5lDFZ5vKBNb4NUybygleprkCqZF7RSuQapPASrAAAAAAAAjo5QwapjDcEqAAAAAACAo4NgFQAAAAAAAApG4NMAAQAAAAAAgKOBYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMCJNj63laYAAAAAAAAAoCJGow44DQJ9s375dxo0bZ6dQCNgmA4fvGgAwVHGOA+A3EMcEmgECAAAAAACgYBCsAgAAAAAAQMEgWAUAAAAAAICCQbAKAAAAAAAABYNgFQAAAAAAAAoGwSoAAAAAAAAUDIJVAAAAAAAAKBgZg1XrF0QkEpkqy7ptgU/3sqkSWbDeTgFAOO5xxTdwHDmqzLHcvz3sMDXowI9eM7/7NL/1TPP8dDm2CwCgEAXXJ4KvIwuVW0ddINRMgcIQIrOqVWpvXiZUjwH0TbcsmxqRWbJOotFobFhXvo3jy9FWk7hNotF1MrG2NPcK2/oFEpnax/NFPtZRgGZeUyOyck3A97le1qx0NsE1M+00AACDVEp9YpPcWWLnDQIzH9T3/KBwRgYKQ9ZgVVVDg9S01srN3M0F0BfdzbKqtUoa6hKrADPvvFMGUT3mGDFTHox2SUPVSplF5lt+zLxGamSlrEn+OtevcUprhFgVAAAAEBcis2q2PLiuRlprl2a+w969TKb60z6T7oy7zRfWm8wKbxlzDZTwutS7+IkppYMrlRSAT8kEmSit0tFlp9NITiP3x0pSUsyTAileM6mE5QKydDiuhFEidy5OygbKcJw3qfOzVopzspBSnedtmyznBr+gdZiypO1stp9dz+DZ5jPFTa5K+s26aVXuXdwcvivnlbIg+XOY1yeeR/mtAwCONvdc5D8/udn23vk9+7ncXX7Bej336fz4ujKe5zRbO2hemnLvffglrt8ZEuok3vuynydpfQD6JlwH6zMflHU1me+wdzd3yPwuL+WzSxrEudhIWr61donIQ+4yXQ1VsnKWs0PfrEX2NUl38fXgULpqvnR5qaTrJkptaY7NUgAUiJlSZ/f7dP3umH2+dqKs8/b5rgYpTzdPjxlbZ6UEMlprS+VmeSi+TNKxiONKDkrLpUq2yja7uTId503q/LoaTcd1v9sH3VShMOcGT9A6TPO5rf6mot3SvKpVahbHM/IGyzZPbQrYLdu2xpsA5vJdhcFvHQBQCErufMhc5y2x9b/uZTc7ZzjnXG/rCirbuVxtXbJGys150m2ql/E8pzdwZm2VBu+8um6+lqYvDxC27rlylrmgNcusq6ELHSBvnJ0qLeeaIVrl7MlGV0O0Sqqi8cmqqNQ4u24662qizgVH1C5u1pW4/LqoU22PJhb5X6Pz4/+fqyvqXOsmvgZAwXjrrbfsWAbmWOIcD5whdnwxAo4JMUHHA4dZV40z15V6nHEkHLuOveNKtm2S+Vie5nv3JB3nU6aDZFsmZX7SeyjgbZ7995/5s6RI+i4SzslBnythfQP3uQEAQ1+o+oSt38UG//k8do5KPT9lP5e756/UemOG81y6c2yGc2/W86xKeH3A+8qwfmAoCXXd10fhMqtUyZ3yUINkjBRr9DmWIqlNOZJUlZfaMU+VpBR5TD8erVJb6qVU6lAqta12PoDByTmWbDJ3srR5cWn87lSmvnvMvIkyIblzK9O0MJ75o1KOM2YZi+NKbrq3Od9uomzH+SC9eU2cNp9rlVXN9m5s8ypp9ZrNWYNnm2f/LH37rnz4rQMABlpyB+ubfP2SOvW/xdpSJzJLVtYsTul4PeO53JrorwhmO8+VzJb5Vfr/JXYpkbY8WQ51z4T3ZSTOB9A74YNVjpI7F6fpbN1tP5yYhllj5/VFjS/tMj74MkYBDFYzHzTN/KpWLhngtv0cV0Lr6pDWqvky29TBenOcz8+5QZvPta5qlm6vCWDOvZEXzjZP/1n64zzKbx0AUDhKy6vM39QEht7KdJ4rkTs3OdNOXXOrdj0T6+cqXTmAQpNTsErvCnudrTfbEsPcfXcOFr7oebd2xNEXSX2lABiCzN0p2+l6pn0+3Txz7Em869Wa3IO7/84Yx5UcrJcFs1bG+4bqzXE+X+cGfZJe6yppXq9PlEzNvhtU2zzdZ8nHd6XBRTvKbx0AUFC6l8nN2v9Tl2mqk3KjMuO5PEjY85zJ6O9K6DPLSFfuyaHuCaB/5BisctjO1mtT2hL4dmZzMOpjWwOTKqqpnf5od7csW0CHdcCgpB1aJuVbdy9b4lRE7AV70D7vvGaZTqQ7HtxcK9JQl9CMSlbO8qV1uwGXKm8Zjivh6LYyafrrkrJwQhznWzsksbrZi3NDyjps87klqc3mjEG1zd3PUjurNuCz5PJdlUp5lbOepd6ncj93DL91AEDB8NXZnPNTYNcymc7lQbKd59YvSGnmZ5rrpStPlm79QXVPAP0i92CVY2Zdg7hJnJZ30PHaDOsDEfLQDFCfDGWeQqjrNEOprCqfHbvrDGAQ0SwqpyIS71cgYp+w4j7RRaXs86Wr9Jo8Nq+rYWvi8WB+l2xK6vSgqmGdlC/xlnEDLv5lOK4ESNoukdIOWayp9P5IVZjj/Mw696muOl9rgr05NySvw9LzjqYNNdSlVg8H2zY3TwV0JDRnzPm70mYM66Qmtu3WyDXarNbOVfzWAQADKrk+4Qx6Kl+/oNQ8/e8he24O6lom27k8SMbzXGm5beZny506o6nWpCsPELbuCaB/RKLasBcA8mD79u0ybtw4OzXw1i+IyJJyKhF+R3ub5M36BRJZUi5d/s5aHYW0zYfMdw0AQJL+PMdRfwMGn4Go9/YqswoAgIHTLcuWrJSq+WQFAQAAAMcCglUAgIKld1s17b52YvbmAAAAAACGBpoBAsgbmkEVHrbJwOG7BgAMVZzjAPjRDBAAAAAAAADHFIJVAAAAAAAAKBgEqwAAAAAAAFAwIrt3746OHj1anL/S338BAAAAAACATEywyo4DAAAAAAAAR9WABKvIrAIAAAAAABg6Nm7caMfyj8wqAAAAAAAA5ESDVVOmTLFT+bNly5aB6WBdM6sAAAAAAACAbAYkWEUTQAAAAAAAAIQRKlj1w5Y37VjvkFkFAAAAAACAMLIGqzRQNfK08/oUsCKzCgAAAAAAAGFkDFZpgOrE08+XokjE/O1twCpsZlVL7Whn2emyoscWpGiRWmddo2tb7HR6Zl1plss0Lxv3PdY67yQcXX56+g9khFkGGErc/cg/ZNrvw+qRFdNHSy937TwrpPcSXsp26cUHyPUYeWxzfyejp69wxlL1rJieuD2cId25InVZtgEA4ChrqU06NzlDmnOef1m3+pGhLqXLpltPP3HrN1ynZpSyDYG+SRus0sDU6LPOl+OLJDbodG8CVrllVrXJ6qeCd4ieFUulo7LSTmU2bXa1SGNzwM7aIs2NItWzp9np3Exr2O18ngbp3asBeCrr282xQYf2epFFFfkIWB19bkWhQha12YJBwa0QzpOm2DbRoamsO14RDFkx5BiZg56nZLVUSmXbaklz2nNOVr5t4u4oSRVAd9tVLCqXJt+2290k0kxFEQBwVNibMUvLpN1/btKhrlMq0gUz7DmvoWArEVynZjStwWy/JufjAfkQGKzSgNTp4y6Q44dFUgYtzzVgpdHVsCqdnbxt0fKAnbdHnlqdw9XftNlSLY2plfWWZqe0Wnp5DADQD4oXPiD1lekrAINGS63Ma6yWpt1NzlFmENGgSVul1N+ReGCctnChFNtx5F/L8kUicx6Quuo2WbQ8RGSpeKGzrNZv48v2rLhVFkm9czGQVDl1KoyFW9kHAAxlLbUVsnpOu+zeEFCP0IBGe710zBt8Nym5TgUGVkqwSgNRZ59bLMOLhqUddP70f2y3r8hOI6yhzalzLlqDdt7lpkJeN8dOO4LSJE1TCHP3f5q4QevE+S1uuNqt1PeskOk2VdEMCVkDXuqpTem0KZUpqZAZ1xGX0EQjRHZCYpOOoZFxAoQSYp9KbvIUnGps7+p56dAh1utmRcXnt+j/E3SMia0nad80d5QGYVZRcYmUS5t0vmKnk5jvZZ5z7GxbZO6Gut9JmGOkt4y3LQK+M0eY733o0bunlTJnRrFMu6NeKgPvsAarLBtvx1pk+aI2qa4jqAgAKBB6466jXh5Y6J6Z/PWm2tpat45QvFAe0GThMDdqwvA1P0uuZ6SvtwXUY0xd0S7jH/dwnWpkrAsDeZQQrNJA1acuGC/DiyJy8rvPSumRV6XkSI+UHHrF+fuqlMnrcv7HXXLOvk757rVj5Oe/arWvzEx/yOGNlxlzKqVxaeKOojtv5ZwZztw4k0LZ4Wum4oxpVNuruKemWPZId0c8tbLnqU6Z0+6lpbY7hxjnQizpoNKxtFnKzDLBF6Bh1tG2qEJulQcyLuOnB4CK1XPiabNN5bKowl5wA0NYeUlx1n3K7B/+Jk/t9c6xKZXe1fNnnGRbr57gtXIV2+/qOmVeUlu+obtvTpM76p3j7rzgfglMWrnmdFfa78eXspPtGKka590q8oD7nTVpFtGt8eN7mO99SNK7p5VzZIaerIpnyJygym8ym7lXZy8AuAMLACg03jWbnqkS603tUtbRaOp6qnjGHKlMuI7rJQ3IzOuQeq+O1xSPGIWpt4Wpx8Rxncp1KgZSLFilgaoLx5fIiKKIGc447RT52y9+Ri7/4kS5fOok5+9npOzcU+TKL31OZv/NZJn5pYukKHLAvjoz/SHnonhhnVT7+/BwDkJL/RV0j6ZQJiynTVl8FXeTYtkh3WnmFy9skPgqi2Whtq9IPmjOucO3TKpQ66hukg2xhZxlHtC76EvTRKH1TrlI/QO+O+XT7giO4gNDhAks2X0z8z5lM0mafCfl4oWyMOkMHQuA+NLPs61Xs1wS97uGpDb3Q3vfLF64IdYnkt5gCApaBcpyjFSV9Q/EljFZRG2d4iZxhfnehyZ/ZV5/j6byG/RDapwXv3s5rzHxtw8AQEHRgIubNazjT63215uKpaTcjPSDcrExMKce4dQLzXjIepu/HuPUKTfs3uBO+8d9uE7lOhUDJxasGrP/TXn5lW4ZflzEDEeOHLFzRA4ePCT33HOPXDNnrmxu2yJRX3kYuWVWKU2NjPdf0+Mc6dq8lMgE2ZbLvh6NDvsvBJJ50f9Msq0j3mTDMk1u0jB3ytuc60W7PjMMts6agez0To73G3cza+IX4Wn3qRCZJB1Lp7v9RgX0k5B2vT3dTnXBV9Gxxpf5Oso8FvZNUzHTu2TV7vbJcGfNE+YYmbqMrZyF+d6HIlOx9SrzLnOHOahy6O9gXe9KL3V+dyG2CwAAhcUNZMUui17plLbykpS6Ws5sdvI8p16WcHoMWW8LU49JxHUq16kYKLFg1YHDx8uJf3lbnu/sMs0AozYitXPnLln6L/8i3c6VxaqmR+Wcc86Tg4fFBqwi5t9scs2sUnr3XUwHdjYqn9Txr0dTKNtWP+UsZVMrk65i08932/gmpjHmejs/H+sIoh002/X5BjrLxVDifxpgvAPOfO1TvjtVRpb1aoXJjmZ2jOybtvPT9HfW8iT09z60mAppcmWvYpEp8yqtwZLueI4vk8qU3zoAAEeLZk/5+8D0jWu/Tm3edI+sWNqYct0WpCPrSc45N25w6mOm03Y9p/qbpPVPvY3rVLs+38B1KvpDLFi19/AIM0T27JItHdskaqNVBw4ckGe2/Kfs27dPRp9yspw97gx5480/yUGNWIWLVZmKeM68PjxqtcM6269HEC/FsiUptdKTbr65o5+YfdGjDYVzEXIdbcm9FpuodGo2gcHFB45l2fapEPtHed0GcVuz+Tp87OV6X+n0hVKOtX0zS6freRHmex9y3AppQrDWDu31lbbSmo09f5jzZFv+OqgFAKCPNADjNmt3b7C4ASRnaJ5tgiXaP6Zm43TWZQtwuE3kU66jHKYj8uSsLJMd3m6apC3VCmB/1tu4TgUGRCxYtWPfGfKXgyPNsPeDfbHMqrPOOlMmfXaSXP+V/yoNDcvk+/X/Sx5d9UvZs+cvMmxY7OUZaSU8d2672sZGf78eQWwK5dLMKZiL5i0KmO/b2XpWyK29ymEMsY7Geb601Bapned8pvo7At6rwznQmseYJ3RU1yMrarM/mQEYGjLsU0H7h7PMiqRrde1/yQ1Y+fejTOu1F/2+jr/dzqztuBrK+6bzfUxPalrWs2KpU1lJqljF+prKkzDf+1Bj+qRIbALoMU0B2xZJ+tiT83u71X8u07vJTVKt/VolP73H+R5pLQgAGHDah1GHvfbxuhfQQSNT5qnJ7nSYTBy3ibz/Osph6gmV8WymgPOdaR7Xm3qb1ocyPQ0whuvU0N8p0AexaNPSG8+SnftHxQJWR6Jisqv+su+AtG3eLJ848UQZVnScLGv4sdzytW/ImDEny6FDh+2rM+tVZpUyHc8FdFiXxKRiOvtephRMlZB66exs5pGpXjMMfVhVrqmRIddRWd/k9jOiy4yeJ40JHdml0idvNVW7ba/d11TI6rJMB0JgiAixT6XsHxWrJeHxK5YGrLzlal/Jtl696LdPQPHW2zzbZLr4Ddl9U7Oo/B15O4P7xEVfZ962A03z2fMWBQn3vQ8lLcudCqn3FMBkJninDwfyfb8J26VCFpU3JTyN0dkw0uA9vSe2nDMsLZM0p0QAAPqReyPFqTAE1hdaatMFgAI49cINseZ9djBP/vN1fD6+zDffqZfNaY8Fwvq13sZ1qn0N16kI8NpPZe75c+Wnr2UYDyGye/dum0PluqtxhxyKFslNlQflwvNOkdtu+29SWflF+fyUCjlp1Bh57733ZPjwEXLl9Mvl/sbH5JZrr7CvPIpaak3F3P/kLwDoK32q4NKy9ownbeQf3zsAAIOfdu5dkZzNow8OCUqr0us5bSoYJuVqMDkGr1O1Htc8m36sjhUbN26UKVOm2ClLg1KX/of8l98+Ll+TNOMX2GXT2LJlS2qwSmnA6rrPH5QZfzVJtr74spSUTJCRI+JN/vQF2l3V8sY1cvOcy0xZJhp11XTP/tEjK6a7UXQubADkjVYu5klidhH6H987AADHHnP+d/sBqG4aKoGOY+w6dUhuQ2QTGKzKg7TBKvXzX7XKcZGDEhlWJAcPHpRDh90mf2Zh55+iomHS9eobsuSbOaYk5pFGbc3+kC5CDwAhxY4nMdUETAYA3zsAABhquE7FseKoBKvyqX8zqwAAAAAAADCQ+jNYFe5xfn1EoAoAAAAAAABhDEiwSjOrAAAAAAAAgGwGpBkgAAAAAAAAhg5tBthf6LMKAAAAAAAABWOY10SvP/8SqAIAAAAAAEAYNAMEAAAAAABAwSBYBQAAAAAAgJz0X59VIv8fGun9aikQPK0AAAAASUVORK5CYII=

Has anyone ever seen coding like this before?

There are a lot of Script Component transformations in a group of Data Flow tasks (Given their position at the end of the precedence flow, I think they're Destination instead of Source or Transformation types). I'm not sure if that has anything to do with it. But I'm really weirded out by this. It seems to be a lot of ridiculous redundancy to my eyes.

Thoughts?

If you understand exactly what the package was intended to do, it's probably a good idea that you build it to work the way you understand, to ensure ease of maintenance in future. You can always refer to it later if you find that your version does not work the same way as the old one.
I've seen enough weird spaghetti coding in SSIS packages to realise that different people's minds work in very different ways, so it's not necessarily anything to worry about.
I can't think of a sensible reason for things being the way you describe.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (543K reputation)SSC Guru (543K reputation)SSC Guru (543K reputation)SSC Guru (543K reputation)SSC Guru (543K reputation)SSC Guru (543K reputation)SSC Guru (543K reputation)SSC Guru (543K reputation)

Group: Administrators
Points: 543622 Visits: 20703
Never seen this, but not a deep SSIS guy. I'll ask a few others.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Martin Schoombee
Martin Schoombee
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15554 Visits: 4712
It's a lemon...might as well make lemonade :-)



Tim Mitchell
Tim Mitchell
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13001 Visits: 3160
Inheriting code is always enlightening Smile

For the issue with the expression on the connection string, there's no real value in having it set up that way if the expression is just static text. Unless that connection string is being dynamically built in the expression, it's adding some complexity without any added value.

On the variable issue - That's got to be an oversight when it was first developed. That expression doesn't really do anything.



Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices


Brandie Tarvin
Brandie Tarvin
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143735 Visits: 9617
The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter how many times we told them otherwise. I even told them they needed to put comments in their code so everyone could understand later, but usually the comments ended up being along the lines of the stored proc name with "select" or "insert" added.

So, yeah, we inherited a mess. I was going to try and assist the Devs in rebuilding the package, but I'm clueless on how this thing is working. So I guess I'm going to leave it to them to fix.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
tim.ffitch 25252
tim.ffitch 25252
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1324 Visits: 187
Brandie Tarvin - Friday, February 23, 2018 7:52 AM
We have an SSIS package that is totally hosed (got corrupted somehow) so I'm trying to rebuild it from scratch. This package was built several years ago by a vendor that we no longer have ties to. As we started looking into it, we found a lot of strange things and I'm wondering if any of you have seen this sort of thing before.

1) Native SQL OLE DB / ADO Connection managers have expressions attached to them on the ConnectionString that is the same exact information as the CM would contain if it didn't have an expression attached. For instance, a regular connection string in the properties might be "Data Source=MyServerDev;Initial Catalog=MyDB;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;". And then when I scroll down to Expressions, there's an expression attached to the ConnectionString property that is that exact same information verbatim.

2) Variables have expressions referencing themselves.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABKsAAAB0CAYAAABKWbFhAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAACLmSURBVHhe7d0NeBT1vejx3xIFrKJgfQNfGxJiU2glpdGGc+rxKCBwPQoVtFetsacNcj1qrM3Th8q5tz1ymnsPfQnofVCe057Y2udYooLlBJSUe/tyiSVyolWMhsT4VsFXoGgBeds7v//8Z3d2d3Z3NtmETfh+nmfIzH9mh92dnZn//Ob3/09EvrMlKgAAAAAAAEABGGb/AgAAAAAAAEcdwSoAAAAAAAAUDIJVAAAAAAAAKBgEqwAAAAAAAFAwCFYBAAAAAACgYPA0QAAAAAAAAMj//foE+ZtPjbJTcY3tH8gtj71mp/ofmVUAAAAAAAAwnty2Ry77121mePvDg7Z0YA07fOMYO5qo+sbJkm5eNua19xZLdTRc0pYu33nlSDsVLMwyAAAAAAAA6L23Pzoov3n1QzPsP9T7xng/nn2uRP/58/L7mjI5aXhqrpSW6TxdRpf1GyZlY1KDStExMrdMpPnFnbYgN40PPytF/9gjjZGILQEAAAAAAMCx4q7mN6Wh9V35q/NPkvXVpQkBKx3XMp2ny+iyfsOa5RSZW2GnPBVjZLb8WR5vt9PHmPkTx8jpJx5vp1yUUaYoo0xRRpmijDJFGWWKMsoUZZQpyihTfSkLy8tayjQkZysdDUEBq2yBKlU04vr/8d1vnfGx/NPz+22RSPUVF8jVH7wtc19wys4aJ53fLpH7rjhbvnv5OPnvn43I2qf3yNuaNRUdKT+4a5L8w8cfy1du+7Q8/LefkDf+z0656KYK+eW43XJ/9yF3hZnW4bjos2Plr/e+L5tKJsiOW87LuExsnY7JV5bHl79sjJz80ruy4SObzTW5WKK3FwfPy2L3/sOya98hOeKMR+z/TxlllFFGGWWUUUYZZZRRRhlllFHWn2VhPdW1R0afcJxccu6JtiRRuiBQNtUVnzTv64mXdpvp2qoznf+nSJ7bsS9Wlivvvc6fNEa+9KlRcuNFn8wYqFIRadoZPTxX5O8Xv+I22zMBqE/LhN+2y989G5HJVxbLDc+9It96Oz7vrvdfk6KHd8Wmr5I/y9pH7DIO7V9q0fsvSdmTbgAs4zocuvy/fXqYbPv9i+5r0iyTuM5y2XLhbpny47fkWX3fk4sl9jnGni2dt42Wtf/7Rff/nDxOfrDjrdj7C2uMs0FGHlckOz48YEsoU5RRpiijTFFGmaKMMkUZZYoyyhRllCnK+lYWlmZP1VadYadcvQ1UKX0a4Gu7DsSe/PfqtybJBWOG5+VpgPddda78wyXue73/D+/K7WvTv8dh0r5LmmWkTBxrS8aeKld9Mt4E8Nkne+JBnsh++dZv/yxy2gky2d/P1cvbMwaCwqzjyEs9sUCUWeaRd6S7bKz84KyAzryiY+R7U52N8ogNVKn27fLjD/xNGvfL1h129NnM7y+dk0ccJ6efWOSMxd8DZZQpyihTlFGmKKNMUUaZoowyRRllijLKVF/KwvKa2Xn6EqjSrKqzTjpeSj45wozrcNIIt58pr6y3tOnfRWM/YafEjPv7sEoWke9sifqzlkzG0mk7YhlNSsva//oEOyVy5L0dbkaTnJCQheVJzoJSadcRiQQurwGpXy0ZK9tsdlTCMtrE79rgJxWufXSL/F27+77uPn2YO+17b2Gc+oki2fPxEefLESly3t/+Q0coo4wyyiijjDLKKKOMMsooo4wyyvq1rLe8/ql6G6hS2s9VNpF7/tOOhZfcR5XSbLD/9/pHMrOxSz46kPq5TRir8cU/S8mFp8rk6Ei54cIR8acAasDo3smmuV3Fd7aYNxV5NB7ECiUf6whw5MguucVbn28wgSnNzGp4ViL37ZCyuRVy+N7i1CceZjBl3IkyaniRHDwcjf1YKKOMMsooo4wyyiijjDLKKKOMMsr6s6y3NEjVl0CV8sdWPvWDF0yZ/vWX5yqoM3UddNzf6Xoyk1kVy2J6fLdcNXek1Hv9V2nH6Lf5ph0JfUWFyazKtg6nTJf/icT7pzL8fVDZZRLX6euTKhOvX62XkzK3AAAAAAAAkEL7qdL+qjRYpX1Y9UZQoMrP628rKMPKDV9FdsnjnSPk7mvHSknnrlhQyeXrz+qscfLI1BF2IhfZ1zHs08Xyq8k2+0mDZ3NPke5N25Pei/X2dql33u9dt42PZ0xpUOrGcW4/WJN967I639lnxwAAAAAAANCfrv/sqdL9wceyaMNbgVlfWqbzdBld1i+Wa6VNAVWsCaB6e7tcv0nk7tunmLaLh693/rPH3eVCC7mObb/vkW2XVphlot8vltmdr2XMhGp8+Fn5+85T5N++7643+v3PyFXv73Q7XN+x3zT/i5W//FLO/VYBAAAAAACgd/51y/vmCYL/87dv25JUOk+X0WX93GaAAAAAAAAAgCMfzQD7gmAVAAAAAAAACkZql+sAAAAAAADAUUKwCgAAAAAAAAWDYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMCJ79+6N2nEAAAAAAADgqCKzCgAAAAAAAAWDYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMAhWAQAAAAAAoGAQrAIAAAAAAEDBIFgVYNmyZVJUVGSnAAAAAAAAMFD6PVj12GOPSTQaTRm0PB82bNgg7733nrzwwgvy0ksvmbIdO3bImjVr5Omnn5bNmzfHygEAAAAAAFDYInv37o3acRPwUZMmTTJ/VVBZrjQwNXfuXPnZz35mxr/85S/LV7/6VXn88cflsssuM8uceuqp5m+u9P3df//9cvbZZ8uMGTPkww8/NOO/+c1vzPTzzz8v11xzjV06HM2s+uY3vymHDx+2JcFmzZplx3Kzbt06OwYAAAAAAAC/WGaVBn00IHXBKXvN9JZ/LjZ/dVrLvaBVrjSLSgNVSgNUGqjSgJUGrrR837590tPTI6tWrZKdO3ea5XLx2muvySWXXGKyqDSjauLEibJixQqZMmWKnHPOOVJRUWH+v96sGwAAAAAAAAMroRngh29sls6ff0V2b2uRURdcbP7qtJYrzTTKlm0U5Oqrr44NXvM/L2A1btw42b59uxw8eLBXQasvfOELUlpaagJhP/nJT+T222+XadOmyfDhw+XrX/+6LF68WEaOHCkfffQRQSsAAAAAAIACl9AMUJlA1XkXS9HIk+Xw/j0mUDV6wjQzb9euXebvu+++KyUlJaE6IdfMKg1SBfGaA77//vum6Z0Gq2bPni1lZWVm/IorrsjaPFCDUC0tLabp37333itHjhyRH/7wh/L666+bzCr1yCOPmOnrrrvOZIk988wzpvlhunXn0gxwzeon7FQ418y5mmaAAAAAAAAAaSRkVmnTv3ee+akJVCn9++EbT8sHLzwuGzduNAEcHf70pz/Jnj17pLOzM1Sm1RNPPBEbNEClvECVvn7UqFEmA+qee+4xfUz96Ec/MplWGmDKRJv9bdq0yWROfe9735Pp06fLggULpL6+3mRcaUBt/PjxZr3f/va35Xe/+10s00rXDwAAAAAAgMKSEKyack+PnPmFr5mMKs+2yFT51o/WynPP/VHu/aclZtBxf9Aqk+eee046OjrMeHIH6xqoOnTokJl34MABE/x68803TQbXww8/LKeddpqZl86wYcPMkwCXL18uVVVVsnDhQpOZ9Y1vfMMEvHS+0sCUrlvfry6vHbKfccYZZl4+aLaUDv7xoAEAAAAAAACZxZoBvvjii3LeqI9MH1VlN/27tHV9ZAJGEydOkuvmXxcL7mgTwF+u+qVs3PhrM52tSZsGszRzKpkXqNIg1a9//Wt59NFHY80MPStXrpRzzz3XTqXS11977bVSXl4udXV1Jsvq0ksvlRNOOEFefvllk6WlTRBvu+02eeedd+yrXPq+I5GInUpEM0AAAAAAAICjIxas8p4GqH1UaZ9VGohRl19+hQlWKX+QypMt8KKZUjU1NXbKNWbMGBNkUkFBKk+2YJX2h+W9Vvur0gCV9kOlmVvnn3++TJgwQU466SRZv3693HfffWY5Tz6DVV7WlH88iDefYBUAAAAAAECwhA7WNWClNGjlBauy6U2wKqwwwaqbbrrJdLL+8ccf29I4bUboNQXUjDC/fAarckGwCgAAAAAAIL2EPqs0SKXDYPLBBx8EBqqUPmVQg1TJgap80wCUl1HljQcNAAAAAAAAyCwhWJWLM888U+6+++60Tfj64nOf+5x5at/mzZttSf5ccsklpkngk08+aUv6TrOrvAwrbzxoAAAAAAAAQGaBwSoNQGkgSgNSybwglT5t75xzzpGTTz7ZzgmmAScNPGkAKhsvSDVlyhQ57rjjYv1apaMBJw08aQAqGy9IVVlZabKxZs6caecAAAAAAACgUCT0WeXRvpq6u7vNEwDb29vNUwHVjTfeKBUVFaZZXUlJiRQVFZnybDRgpX1XjR07VtauXSt//OMf7RyXBqmuuuoq2bFjh+mj6uKLL7ZzstN179y5U0pLS+UXv/iF/OEPf7BzXBqkuuGGG6Srq8t0vh5m3bn0WdUb9FkFAAAAAAAQLDBY5fEHrVSuQapkyUEr1dsgVbLkoJXKNUjlCRusAgAAAAAAQH5lDFZ5vKBNb4NUybygleprkCqZF7RSuQapPASrAAAAAAAAjo5QwapjDcEqAAAAAACAo4NgFQAAAAAAAApG4NMAAQAAAAAAgKOBYBUAAAAAAAAKBsEqAAAAAAAAFAyCVQAAAAAAACgYBKsAAAAAAABQMCJNj63laYAAAAAAAAAoCJGow44DQJ9s375dxo0bZ6dQCNgmA4fvGgAwVHGOA+A3EMcEmgECAAAAAACgYBCsAgAAAAAAQMEgWAUAAAAAAICCQbAKAAAAAAAABYNgFQAAAAAAAAoGwSoAAAAAAAAUDIJVAAAAAAAAKBgZg1XrF0QkEpkqy7ptgU/3sqkSWbDeTgFAOO5xxTdwHDmqzLHcvz3sMDXowI9eM7/7NL/1TPP8dDm2CwCgEAXXJ4KvIwuVW0ddINRMgcIQIrOqVWpvXiZUjwH0TbcsmxqRWbJOotFobFhXvo3jy9FWk7hNotF1MrG2NPcK2/oFEpnax/NFPtZRgGZeUyOyck3A97le1qx0NsE1M+00AACDVEp9YpPcWWLnDQIzH9T3/KBwRgYKQ9ZgVVVDg9S01srN3M0F0BfdzbKqtUoa6hKrADPvvFMGUT3mGDFTHox2SUPVSplF5lt+zLxGamSlrEn+OtevcUprhFgVAAAAEBcis2q2PLiuRlprl2a+w969TKb60z6T7oy7zRfWm8wKbxlzDZTwutS7+IkppYMrlRSAT8kEmSit0tFlp9NITiP3x0pSUsyTAileM6mE5QKydDiuhFEidy5OygbKcJw3qfOzVopzspBSnedtmyznBr+gdZiypO1stp9dz+DZ5jPFTa5K+s26aVXuXdwcvivnlbIg+XOY1yeeR/mtAwCONvdc5D8/udn23vk9+7ncXX7Bej336fz4ujKe5zRbO2hemnLvffglrt8ZEuok3vuynydpfQD6JlwH6zMflHU1me+wdzd3yPwuL+WzSxrEudhIWr61donIQ+4yXQ1VsnKWs0PfrEX2NUl38fXgULpqvnR5qaTrJkptaY7NUgAUiJlSZ/f7dP3umH2+dqKs8/b5rgYpTzdPjxlbZ6UEMlprS+VmeSi+TNKxiONKDkrLpUq2yja7uTId503q/LoaTcd1v9sH3VShMOcGT9A6TPO5rf6mot3SvKpVahbHM/IGyzZPbQrYLdu2xpsA5vJdhcFvHQBQCErufMhc5y2x9b/uZTc7ZzjnXG/rCirbuVxtXbJGys150m2ql/E8pzdwZm2VBu+8um6+lqYvDxC27rlylrmgNcusq6ELHSBvnJ0qLeeaIVrl7MlGV0O0Sqqi8cmqqNQ4u24662qizgVH1C5u1pW4/LqoU22PJhb5X6Pz4/+fqyvqXOsmvgZAwXjrrbfsWAbmWOIcD5whdnwxAo4JMUHHA4dZV40z15V6nHEkHLuOveNKtm2S+Vie5nv3JB3nU6aDZFsmZX7SeyjgbZ7995/5s6RI+i4SzslBnythfQP3uQEAQ1+o+oSt38UG//k8do5KPT9lP5e756/UemOG81y6c2yGc2/W86xKeH3A+8qwfmAoCXXd10fhMqtUyZ3yUINkjBRr9DmWIqlNOZJUlZfaMU+VpBR5TD8erVJb6qVU6lAqta12PoDByTmWbDJ3srR5cWn87lSmvnvMvIkyIblzK9O0MJ75o1KOM2YZi+NKbrq3Od9uomzH+SC9eU2cNp9rlVXN9m5s8ypp9ZrNWYNnm2f/LH37rnz4rQMABlpyB+ubfP2SOvW/xdpSJzJLVtYsTul4PeO53JrorwhmO8+VzJb5Vfr/JXYpkbY8WQ51z4T3ZSTOB9A74YNVjpI7F6fpbN1tP5yYhllj5/VFjS/tMj74MkYBDFYzHzTN/KpWLhngtv0cV0Lr6pDWqvky29TBenOcz8+5QZvPta5qlm6vCWDOvZEXzjZP/1n64zzKbx0AUDhKy6vM39QEht7KdJ4rkTs3OdNOXXOrdj0T6+cqXTmAQpNTsErvCnudrTfbEsPcfXcOFr7oebd2xNEXSX2lABiCzN0p2+l6pn0+3Txz7Em869Wa3IO7/84Yx5UcrJcFs1bG+4bqzXE+X+cGfZJe6yppXq9PlEzNvhtU2zzdZ8nHd6XBRTvKbx0AUFC6l8nN2v9Tl2mqk3KjMuO5PEjY85zJ6O9K6DPLSFfuyaHuCaB/5BisctjO1mtT2hL4dmZzMOpjWwOTKqqpnf5od7csW0CHdcCgpB1aJuVbdy9b4lRE7AV70D7vvGaZTqQ7HtxcK9JQl9CMSlbO8qV1uwGXKm8Zjivh6LYyafrrkrJwQhznWzsksbrZi3NDyjps87klqc3mjEG1zd3PUjurNuCz5PJdlUp5lbOepd6ncj93DL91AEDB8NXZnPNTYNcymc7lQbKd59YvSGnmZ5rrpStPlm79QXVPAP0i92CVY2Zdg7hJnJZ30PHaDOsDEfLQDFCfDGWeQqjrNEOprCqfHbvrDGAQ0SwqpyIS71cgYp+w4j7RRaXs86Wr9Jo8Nq+rYWvi8WB+l2xK6vSgqmGdlC/xlnEDLv5lOK4ESNoukdIOWayp9P5IVZjj/Mw696muOl9rgr05NySvw9LzjqYNNdSlVg8H2zY3TwV0JDRnzPm70mYM66Qmtu3WyDXarNbOVfzWAQADKrk+4Qx6Kl+/oNQ8/e8he24O6lom27k8SMbzXGm5beZny506o6nWpCsPELbuCaB/RKLasBcA8mD79u0ybtw4OzXw1i+IyJJyKhF+R3ub5M36BRJZUi5d/s5aHYW0zYfMdw0AQJL+PMdRfwMGn4Go9/YqswoAgIHTLcuWrJSq+WQFAQAAAMcCglUAgIKld1s17b52YvbmAAAAAACGBpoBAsgbmkEVHrbJwOG7BgAMVZzjAPjRDBAAAAAAAADHFIJVAAAAAAAAKBgEqwAAAAAAAFAwIrt3746OHj1anL/S338BAAAAAACATEywyo4DAAAAAAAAR9WABKvIrAIAAAAAABg6Nm7caMfyj8wqAAAAAAAA5ESDVVOmTLFT+bNly5aB6WBdM6sAAAAAAACAbAYkWEUTQAAAAAAAAIQRKlj1w5Y37VjvkFkFAAAAAACAMLIGqzRQNfK08/oUsCKzCgAAAAAAAGFkDFZpgOrE08+XokjE/O1twCpsZlVL7Whn2emyoscWpGiRWmddo2tb7HR6Zl1plss0Lxv3PdY67yQcXX56+g9khFkGGErc/cg/ZNrvw+qRFdNHSy937TwrpPcSXsp26cUHyPUYeWxzfyejp69wxlL1rJieuD2cId25InVZtgEA4ChrqU06NzlDmnOef1m3+pGhLqXLpltPP3HrN1ynZpSyDYG+SRus0sDU6LPOl+OLJDbodG8CVrllVrXJ6qeCd4ieFUulo7LSTmU2bXa1SGNzwM7aIs2NItWzp9np3Exr2O18ngbp3asBeCrr282xQYf2epFFFfkIWB19bkWhQha12YJBwa0QzpOm2DbRoamsO14RDFkx5BiZg56nZLVUSmXbaklz2nNOVr5t4u4oSRVAd9tVLCqXJt+2290k0kxFEQBwVNibMUvLpN1/btKhrlMq0gUz7DmvoWArEVynZjStwWy/JufjAfkQGKzSgNTp4y6Q44dFUgYtzzVgpdHVsCqdnbxt0fKAnbdHnlqdw9XftNlSLY2plfWWZqe0Wnp5DADQD4oXPiD1lekrAINGS63Ma6yWpt1NzlFmENGgSVul1N+ReGCctnChFNtx5F/L8kUicx6Quuo2WbQ8RGSpeKGzrNZv48v2rLhVFkm9czGQVDl1KoyFW9kHAAxlLbUVsnpOu+zeEFCP0IBGe710zBt8Nym5TgUGVkqwSgNRZ59bLMOLhqUddP70f2y3r8hOI6yhzalzLlqDdt7lpkJeN8dOO4LSJE1TCHP3f5q4QevE+S1uuNqt1PeskOk2VdEMCVkDXuqpTem0KZUpqZAZ1xGX0EQjRHZCYpOOoZFxAoQSYp9KbvIUnGps7+p56dAh1utmRcXnt+j/E3SMia0nad80d5QGYVZRcYmUS5t0vmKnk5jvZZ5z7GxbZO6Gut9JmGOkt4y3LQK+M0eY733o0bunlTJnRrFMu6NeKgPvsAarLBtvx1pk+aI2qa4jqAgAKBB6466jXh5Y6J6Z/PWm2tpat45QvFAe0GThMDdqwvA1P0uuZ6SvtwXUY0xd0S7jH/dwnWpkrAsDeZQQrNJA1acuGC/DiyJy8rvPSumRV6XkSI+UHHrF+fuqlMnrcv7HXXLOvk757rVj5Oe/arWvzEx/yOGNlxlzKqVxaeKOojtv5ZwZztw4k0LZ4Wum4oxpVNuruKemWPZId0c8tbLnqU6Z0+6lpbY7hxjnQizpoNKxtFnKzDLBF6Bh1tG2qEJulQcyLuOnB4CK1XPiabNN5bKowl5wA0NYeUlx1n3K7B/+Jk/t9c6xKZXe1fNnnGRbr57gtXIV2+/qOmVeUlu+obtvTpM76p3j7rzgfglMWrnmdFfa78eXspPtGKka590q8oD7nTVpFtGt8eN7mO99SNK7p5VzZIaerIpnyJygym8ym7lXZy8AuAMLACg03jWbnqkS603tUtbRaOp6qnjGHKlMuI7rJQ3IzOuQeq+O1xSPGIWpt4Wpx8Rxncp1KgZSLFilgaoLx5fIiKKIGc447RT52y9+Ri7/4kS5fOok5+9npOzcU+TKL31OZv/NZJn5pYukKHLAvjoz/SHnonhhnVT7+/BwDkJL/RV0j6ZQJiynTVl8FXeTYtkh3WnmFy9skPgqi2Whtq9IPmjOucO3TKpQ66hukg2xhZxlHtC76EvTRKH1TrlI/QO+O+XT7giO4gNDhAks2X0z8z5lM0mafCfl4oWyMOkMHQuA+NLPs61Xs1wS97uGpDb3Q3vfLF64IdYnkt5gCApaBcpyjFSV9Q/EljFZRG2d4iZxhfnehyZ/ZV5/j6byG/RDapwXv3s5rzHxtw8AQEHRgIubNazjT63215uKpaTcjPSDcrExMKce4dQLzXjIepu/HuPUKTfs3uBO+8d9uE7lOhUDJxasGrP/TXn5lW4ZflzEDEeOHLFzRA4ePCT33HOPXDNnrmxu2yJRX3kYuWVWKU2NjPdf0+Mc6dq8lMgE2ZbLvh6NDvsvBJJ50f9Msq0j3mTDMk1u0jB3ytuc60W7PjMMts6agez0To73G3cza+IX4Wn3qRCZJB1Lp7v9RgX0k5B2vT3dTnXBV9Gxxpf5Oso8FvZNUzHTu2TV7vbJcGfNE+YYmbqMrZyF+d6HIlOx9SrzLnOHOahy6O9gXe9KL3V+dyG2CwAAhcUNZMUui17plLbykpS6Ws5sdvI8p16WcHoMWW8LU49JxHUq16kYKLFg1YHDx8uJf3lbnu/sMs0AozYitXPnLln6L/8i3c6VxaqmR+Wcc86Tg4fFBqwi5t9scs2sUnr3XUwHdjYqn9Txr0dTKNtWP+UsZVMrk65i08932/gmpjHmejs/H+sIoh002/X5BjrLxVDifxpgvAPOfO1TvjtVRpb1aoXJjmZ2jOybtvPT9HfW8iT09z60mAppcmWvYpEp8yqtwZLueI4vk8qU3zoAAEeLZk/5+8D0jWu/Tm3edI+sWNqYct0WpCPrSc45N25w6mOm03Y9p/qbpPVPvY3rVLs+38B1KvpDLFi19/AIM0T27JItHdskaqNVBw4ckGe2/Kfs27dPRp9yspw97gx5480/yUGNWIWLVZmKeM68PjxqtcM6269HEC/FsiUptdKTbr65o5+YfdGjDYVzEXIdbcm9FpuodGo2gcHFB45l2fapEPtHed0GcVuz+Tp87OV6X+n0hVKOtX0zS6freRHmex9y3AppQrDWDu31lbbSmo09f5jzZFv+OqgFAKCPNADjNmt3b7C4ASRnaJ5tgiXaP6Zm43TWZQtwuE3kU66jHKYj8uSsLJMd3m6apC3VCmB/1tu4TgUGRCxYtWPfGfKXgyPNsPeDfbHMqrPOOlMmfXaSXP+V/yoNDcvk+/X/Sx5d9UvZs+cvMmxY7OUZaSU8d2672sZGf78eQWwK5dLMKZiL5i0KmO/b2XpWyK29ymEMsY7Geb601Bapned8pvo7At6rwznQmseYJ3RU1yMrarM/mQEYGjLsU0H7h7PMiqRrde1/yQ1Y+fejTOu1F/2+jr/dzqztuBrK+6bzfUxPalrWs2KpU1lJqljF+prKkzDf+1Bj+qRIbALoMU0B2xZJ+tiT83u71X8u07vJTVKt/VolP73H+R5pLQgAGHDah1GHvfbxuhfQQSNT5qnJ7nSYTBy3ibz/Osph6gmV8WymgPOdaR7Xm3qb1ocyPQ0whuvU0N8p0AexaNPSG8+SnftHxQJWR6Jisqv+su+AtG3eLJ848UQZVnScLGv4sdzytW/ImDEny6FDh+2rM+tVZpUyHc8FdFiXxKRiOvtephRMlZB66exs5pGpXjMMfVhVrqmRIddRWd/k9jOiy4yeJ40JHdml0idvNVW7ba/d11TI6rJMB0JgiAixT6XsHxWrJeHxK5YGrLzlal/Jtl696LdPQPHW2zzbZLr4Ddl9U7Oo/B15O4P7xEVfZ962A03z2fMWBQn3vQ8lLcudCqn3FMBkJninDwfyfb8J26VCFpU3JTyN0dkw0uA9vSe2nDMsLZM0p0QAAPqReyPFqTAE1hdaatMFgAI49cINseZ9djBP/vN1fD6+zDffqZfNaY8Fwvq13sZ1qn0N16kI8NpPZe75c+Wnr2UYDyGye/dum0PluqtxhxyKFslNlQflwvNOkdtu+29SWflF+fyUCjlp1Bh57733ZPjwEXLl9Mvl/sbH5JZrr7CvPIpaak3F3P/kLwDoK32q4NKy9ownbeQf3zsAAIOfdu5dkZzNow8OCUqr0us5bSoYJuVqMDkGr1O1Htc8m36sjhUbN26UKVOm2ClLg1KX/of8l98+Ll+TNOMX2GXT2LJlS2qwSmnA6rrPH5QZfzVJtr74spSUTJCRI+JN/vQF2l3V8sY1cvOcy0xZJhp11XTP/tEjK6a7UXQubADkjVYu5klidhH6H987AADHHnP+d/sBqG4aKoGOY+w6dUhuQ2QTGKzKg7TBKvXzX7XKcZGDEhlWJAcPHpRDh90mf2Zh55+iomHS9eobsuSbOaYk5pFGbc3+kC5CDwAhxY4nMdUETAYA3zsAABhquE7FseKoBKvyqX8zqwAAAAAAADCQ+jNYFe5xfn1EoAoAAAAAAABhDEiwSjOrAAAAAAAAgGwGpBkgAAAAAAAAhg5tBthf6LMKAAAAAAAABWOY10SvP/8SqAIAAAAAAEAYNAMEAAAAAABAwSBYBQAAAAAAgJz0X59VIv8fGun9aikQPK0AAAAASUVORK5CYII=

Has anyone ever seen coding like this before?

There are a lot of Script Component transformations in a group of Data Flow tasks (Given their position at the end of the precedence flow, I think they're Destination instead of Source or Transformation types). I'm not sure if that has anything to do with it. But I'm really weirded out by this. It seems to be a lot of ridiculous redundancy to my eyes.

Thoughts?

The connection string expression may make sense if package reads from a parameter file to get the connection string and they have set a design default.
Variables referencing themselves is a No No! It will create a circular reference and send the package into a spin.
What version of SQL was the package originally designed in and how was it deployed? With project deployment for example used in SQL 2012 onward you can recover a lost project or package by recovering it from the SSISDB catalog.

Brandie Tarvin
Brandie Tarvin
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: General Forum Members
Points: 143735 Visits: 9617
tim.ffitch 25252 - Monday, February 26, 2018 9:35 AM

The connection string expression may make sense if package reads from a parameter file to get the connection string and they have set a design default.
Variables referencing themselves is a No No! It will create a circular reference and send the package into a spin.
What version of SQL was the package originally designed in and how was it deployed? With project deployment for example used in SQL 2012 onward you can recover a lost project or package by recovering it from the SSISDB catalog.

It was designed in SQL 2008. We've since upgraded to SQL 2012. It was deployed straight to IS via the GUI with the Import Package right-click option, but we have a history of the package in TFS.

The odd thing is, until recently the package worked fine.


Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Scott Coleman
Scott Coleman
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21890 Visits: 1905
The design-time values in an SSIS package can be overridden by package configuration, so be sure you check all the package configuration settings and understand which order they are applied in if there are conflicts. And all of these configurations could be overridden by command-line parameter settings in the SQL Agent job step (or whatever else invokes the package).

One use I can think of for the connection string expression is that if the connection manager is configured to point anywhere else when the package is loaded, the expression will override that configuration at runtime to set it back to the design value.

The self-referencing variable expression makes no sense, although you can configure the variable expression property so it is something else at runtime.

The only reason for either of these methods that I can think of is to confuse someone trying to reverse-engineer the package. The much more likely explanation is that the package authors were confused to begin with.

Never Attribute to Malice That Which Is Adequately Explained by Stupidity




Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search