Package Parts – First Impressions

  • shubhankarthatte

    Mr or Mrs. 500

    Points: 579

    Comments posted to this topic are about the item Package Parts – First Impressions

  • Dave Pendleton

    Old Hand

    Points: 392

    The inability to access package variables renders Package Parts pretty useless, actually.

  • RonKyle

    SSC-Dedicated

    Points: 31468

    it has few shortcomings

    --from article

    The inability to access package variables renders Package Parts pretty useless, actually

    --reader comment

    I think you meant to say, it has a few shortcomings.  And that is generous.  Microsoft has at least recognized the need.  But the reader comment hits it exactly--without the ability to use package variables, I can't think of a single practical use for it.  If it did work with package variables, I would have lots of uses for it.  Hopefully the wait won't be too long.

  • Luxgilby

    SSCrazy

    Points: 2097

    The inability to access package variables renders Package Parts pretty useless, actually

    I haven't used SSIS for a while but I remember similar behaviour from elder versions (SQL Server 2003). It wasn't possible to assign values to package variables at runtime directly. However it has always been possible to assign values via a script task. I'm convinced that a script task can pass package variables to exposed package part variables.

    You should give that a try. If it was possible 10+ year ago, why should it not be possible nowadays?

  • RonKyle

    SSC-Dedicated

    Points: 31468

    from elder versions (SQL Server 2003).

    SSIS changed A LOT in the 2005 version.  There is no more activeX script.  I used to be able to do a lot of things using ActiveX script that I still can't do in VB.Net.  In any case, that's quite a leap.  You need to be able to access properties to assign values.  It might be possible, but it wouldn't be safe to assume that because it was possible in 2003 should mean that it's possible now.

  • BrainDonor

    SSCoach

    Points: 19212

    An interesting article - thank you for posting it.
    As already said though, until you can access package variables the use of it is very limited.
    However, at least I now know this feature exists and can keep a track of the future development.

    Steve Hall
    Linkedin
    Blog Site

  • Luxgilby

    SSCrazy

    Points: 2097

    There is no more activeX script

    That is true. However I (for whatever reason) never used 'ActiveX script task' but the plain 'Script task' with underlying C# code.

    Simple exercise:
    Create 2 variables of type String: TestSource and TestTarget. Assign a value to TestSource and nothing to TestTarget
    Create a 'Script Task' on the package. You need to define read-only and read-write variables on the task properties:
    data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAeIAAAB0CAYAAABZoTFJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAABpkSURBVHhe7d1tbFvXeQfwR3EwrIizfaplKp+aim7nMrItA0UrZQUSuKpJu4CwIQqQbVGSGhKCZZbSxYVTa8MG2JhXZa3kZgisuvbkoEWroqu2SqSjpMm61OyQVXak0kJnyR72RW9BPy1dBzSD9zzn5fJc6t4rUqZ4Rfv/AxiT9/WQuYfPOc+51Gl4/9cf3KLNdOMMPZr6Ir3zhR/S+y+n1aKp554levkV6lCvyvTas7S98xv0ycFf0JvPNZuFIcy2z4x/QGc+Z5YBAABsQfeYf8vy9r/+mL4+9JJ5VZ6bue/RO/zvJz+e1AtYR6VBWHzuFeJGw/pBmE398BvmGQAAwNZWdiD+8b+8RV98/s/om+fPmyXleTCZUv++c+zj9OjLC+q5j/SYP3QvbTcPtU3Jsu0fepampJdr19vn3LP2tnvkDN3kw009dy/9wTf1oc938vLncvoFAADAFlRWIJYg/MKf99GelhazpALck50d/LR6KsHYC6bCpq0/9VWa5d7u2h7vp+lvC7I8uAf9zrXfo3O8jzr+v32RjvBxO17+gP7xC3q9pKZtOhwAAGArWjcQu0G4oaHBLK3Mg8+9rYJsMSA/TX9/w0lb/2GGHlRrSnzqMUp/1DwPYPd7MP0YfZL/fecX82o5AABAvYgMxNUIwi4JyDoY/5T+w8lSp5Lrj/sCAADciSID8ey70/Sb33xAP5u+Qv/+s2n1ePqpp8za8tx8+VnV+9UWKPf9n/K/n6aPcey1Pdnzp/X4bqXe+X5W7Wd71s98Xqehmz+ue94AAABb3ab/fOnmy79PLcck+Foy7vs2/alNOdtxYvNS/TwpnS2OHb91VKet3Z8vJf9OPfdxfh5FlKOjH/o8qdvKfMsBAAC2ls3/HfFmqOQ3xQAAAFtY2T9fAgAAgOpDIAYAAIhRfaamAQAA7hDoEQMAAMQIgRgAACBGSE0D3AHu++1t5hkA1Bv0iAEAAGKEQAwAABAjBGIAAIAY1SYQF16lF7/0vHm8StfM4rKsvkHDXxqkt1bN67L9nL67of0A6t0sjR49SkdHZ81rv5Wp03T06GmaWlEv6LR9HpfZUS4Pl/f0FEUVY3b0KJ0uLajsK+9zU96HfI5Rx1yhqdNcbil7UPm5TKNqZz5OyP8LeU92f997s59J6XKh1o3yUYv0/1N7LP862Po2PxBLIL1I9Mdf+Rr9jTxeSNBqwawrx44D1PeVY/TIDvM6FAIvQFETNS1lA4LILF2aWDTPWWMHHT9znDoazeua4yB1bpr2HzlDZ453UKO8Dgl+Lfv20+KSf8XsVd53X0vt34cK/KdoKcPlPmMeTxPNOBFwZeYK0U4u0MoyUSKgYHyM5X12/yOUmLhg3rd8JkRH1iw3gf8q0X556VhZWtSfodqnmzYwczzEqAaBeImWEwny4igH1kdS5jkAbBqudnRlpiSizV6l6f3713yRx6spME6t0ZigpumrTm9vlq5O7yeJw7XFAfHCBCU48HW75+bGQIe8Nr3ZU9zgmT7HgfPUBE1PnFrbY7bbK42UaDJP1f+jfSaYttDBw/b/YyN1HOdA271PrfEr8zOELWnblwf+8q/M882x4x765Q/G6Kfb9tGnPrLdLLRW6K2v/QWN/OA1+tHrr9EvEwcptUN6thfp2nt5+tarNynx2XvoLX793p52+sh9et17iV/TP7/0dfon3ueaOu5/8vLz9C79N93I87Hee4AOPER07fUFuq9N9jOnM659+3n62qv6nHpbuYLNsbfdpJFX/kGt08c2ZZae/V/bc95L//XK9/1lUs9lQ//r4HOx0OP51/3o9ff4M9hTbMgABPite9029QrN5OYp8UyG6Js/oXvSe/krXC+fuvA27XrsM/T+2/N0/2cepo9ulx7oBVptledmm9NfpuGxHOVyOVp9IE17G/U2M6s/ofPnb9ADcjzpEX55mMZ4m+J2YfvL4qDt5bjnaJrr7fW3czSzbRvdGP6O9zq3+gCl9UG17dvpf2a+S/O/Y445e4nON+yjp/QL532Ev4fi+/S/lhTxqfN6++J59eeoPyfZx1jJ0/ey99NnnrKfa4nGvZROt9K21d+lx158jj62ukqtL75ITz38UXIP43eTfjL2PiUf28vd6kt04/6H6WFz0u2/ukFj8/c7n4WUa5kSzv/XmUtZmsjq8s9sa/X2hfpQgzHih+jxrxynlpnTaoz4u15aWoLwaZrdc1ynrPnxuNdTXqTlnU/ysj+hT5glRYs09TrREyrNfYjo0kV6a1XO8Qzt5VZhxwu8/AmOwhE+8YRJk8s+715y0tl87OW9et2TrbR8acqMZ3NwfWmSdj6p93uCrnLQL0/wuaKOJ+uuUou8D1UOojfeLOnVAJSlhfbtn6artgu5MkNXqJX2BEYPIQHsFF1pPWFSnG6Pb5GWEk+btCcHMe7lSY9QbXfiMC2dM+lkDo4TiSMl+4dt30LdZ45w77yJDp84Q8c7Onyvz/i6m6KR9rQ20dKyrg9eWrpUYBmitXSbssn5p4NS+iWaEsFB2LNCS7STt1khDpnrbCsNgXO0dPjgBlPKpqdsyl9MZUO9qM3NWnyhPPI8BxUOnMsXTTBe/TnNLrXSgUeDLtEmakmFXbocbP/oAH1Ynu44QAf2LhI3OCvj3TwmvWgXH1u60iK1lwP7sj72KlemxCF61DQUPvzoQV5XpqBzRR1P1kmD4CVzc9vFK7S8jIFv2JiWgxz0sjolOnuJg2FGxmFDSKBe3E+ZwIHWJmq1EXxlmYOMkxJu7KDMfg7UchKVPj5HvhuMoravUOOeVsnT8vvherIUko4NKsN6vJujpIdehsUl9ZmuJY0Zcxwuw9Gjp2hieoJO8bGD79fS22cTJ7ghEvp/pgLS+FpcOyQBW1qNArHBgfOJg0307uzPzYLbtSJxqzK+m8eOU0fCLN8MGz5Xa/HmNnms08MHCNW4h6+mKzQzO0XZpcN0cGNdrvKpm6bO0NN0QQW2kJuFN857PxG9+0rLIGlz7+aoE3TYjtWGkTI0OZkGH907PcEHUTdPHeH+/WGdYVjbM5cgfIHoackGFN9I486E76a0leUl7oBXFqQTcpMY1I3ND8SFN5zU7woVZhZp584dHJQfopbElQ2kXRdptmD2Mb3qVCU3f7k3j6n91dJoOxpp59IkvWnS6u+9ecnpSe+gHQmnV1541+n5hpwr6niyjr9ikI6G6uDAkEnQxLkJbt/tCe8NCxNgsuv1JBt3UoL7jcWUNwf5kpumGjuOq2Ck0shlbF8+SU9TWe/HVwbeMtHk9MLlhijzlFaWaNGmmlVWQC2NIJ/pfnUjli/I8/uaMq/5kKq3LkE0NCiqFHpm7Z3evpvS5C53eatR79ShPlvcuFVvNj8Qpxpp1aZZv3SaphqfoT6VjpZ09TO085IeO5ZHcfw4ShPtXL6o91HjrHYc+SFK7TUp3W/bHreT4uXHsAS3VAd10CR9VZZ9a4m48VmGh+jxJ1vp3Yv6ON+mfU5qmt/HZ4vrXuTa460LPVfU8XidGvsufi7F9wOwAS0HuZcXlnJ2SW9OxhhPqZ5keG+yhbrVOK/e5ugp7pueMD+ZcX7/emoiYc4Zsf0aOrU6cYq3C+nKSnq6yU2VlwosQzF4qnXuT4Dk8yGdPj56gQPnej1i0dJtxrrN8dS+RHvMm2rp1j+lksZA2Bi1BGkuUHF/fqh0uvTojxCdU8ukq77ez7LkxjNzDDUWX8OfcUFV1NmkD3JH8iXa8UI5vyveRJJyfmmJDgTeTLYB1T4e3HUw6QNA/artGPEd4tobk/7fRt+mah8PAADqB3rEZdE/tZryxpPlZqrb6b1W+3hwt0OPGKB+YT5igDsAAjFA/UJqGgAAIEboEQMAAMSo6oEYKTKA2vrV//4f6h1AHUNqGgAAIEYIxAAAADFCIAYAAIhRDQJxjnobGqjBefTmzKqqKz1XOw0vmFVRFoapvdxtAbY8px60D5N7Wed6y6wbuV61XTsqBcCmq1GPuI2G5m/RrVv6cTZtFoeSL5KNBsbiueaHiPq7/V9EgZr76PKty9TXbF6Hup1yAcQgP0aT3vWao/ER8xQAtow7OjXd3DdAPb4vIoC7R1tbG/83T2O2AuTGaYQbqmrxetJnVWP28vqtUwC4TTEGYtO7HNYpsGIaTJZn+AsjT/1JXq7y2Hrb3t52lVJrby9Jb0sarSQFF0iloG1qzj2G29OtpFwAW1c+laIe+XduXr1euF7g6NxFXe60oSV1wqtHbmraPG9o57pXuh0A3LYaBWITvFQl7uWQZvHyuU6dss72UL5/kNel6eytLH+BmBSzl8fOU2H3KG97mS4P9NDIePEoufER6hnoo9K2+8LwSRrhL55DagUH0mQ/pbImRT4/RIVMWJq5knIBbFWd1CmReGScr98FmhzLE6V20S69UlPDMqZO8LXOFzt1B1cK1kWjvN38EHepebtBtEUBqiKGMeKzHNIsXn7MvEp3cpAr0PXQZnYbdemIqrdVXy4iR+OFIbKHUUHUBP1kf4qyl02AXrjOR++hTrsdfwEN9OTJdBZKVFIugK0rrSMxjQ9PksThHq8COGyvOLPOADIHcbexW0ClAKiKOh0jTtOxoQKd5Ja79HoLXYecL4iwoA9wF1INSQ6aY2PcRHUaooa6izrZT1xpdI8YAGqubm/Waj7URTQ2SINjVOwpR2neRSnpGdh0GvcCTo6s/WICuLOkVXo6n1fd4ZKG6QLJsLHNNqkxZACouRjGiMv5baJ8eZh9wm6KktRyaoRGUgNl/OxIpOmsGhc25UiOUdd8pT3mMsoFsMXo9HRQWrqZ+gZknb6mu7lRCwC1V9eTPkhabbyznN8lA9y5MOkDQH2r29S0Si37btICAACoP3UYiBdouN2klkfX/mQJAACgnmA+YoA6h9Q0QH2r39Q0AADAHaDqPWIAAAAoH1LTAHUOqWmA+obUNAAAQIwQiAEAAGKEQAwAABCjGgRimcfX/FlJ86jeX4d05xE27Nyp5rH+n9O0Ao5VQv6S15rjyfkqeUNqppvo80SXZf1ywt3O1DnfnMHm9/e+aUg3gz1PwKNacxiX1PHNf08Am6tGPWJnRqRsD41kNqniSAXNFJzZl+apayxZQTCOJn+z106ybqm5kCuZOULN/3q5zL+PDVBvmqnvsq5/at5i1iYzO0l9tFOSVsIEXa+tKw1Zma6xJ2vq+C3CpFFQ72qfmt60+X25JX6Sg2LWDXL8pTA6RKQm9q+C5G5q8+ZBFjkaxwxOAJtGGrquhUmZzpGD++6kXsDSZzHdKdS32gfi3DiNtHWRN3OhnZS8JMWk5km1y93Ur7N9+/B1s5AtyMTnAUGx+RB1tdnAb9K6w8XU1tresk6t+bLN0iqXtJo6ljOVorwXZ2q54DLrc/b2tvNyeX/+1HLo+xTz7nsNabkEfn7+9GDpYQH0dVm8Rrxrz3c98cOmk0uXy7Vmeqvq2nSfRwk7fkB5pG5I51eMyKxpvKx5V0q9zveHZLpMOezD26akfAvDUh9N3Qh6b3oj33LvWKHvAWBjahSInWkQxzudFBVXPjUdoUklZ0lN9i/SZ80yXtgzctIELtm+n1JZvW6UxsjXXm7bTcV2sitPxYwyl2WOy6DO18MVurS3rKeGG/GiLZ9V0s8DUuZmOtTVRgXTnS9NSweXWeSpsHuUl69tuUft03+SaFTWzUuvvjtgXDjk88sNUn+qmLrD7FRQKteb4brjDBmpi0TXr7xN+/J115bvp6SvJWf32UgvNPz4QeWRumHTzj1S56WM6bNeyluCsS9ASrB10taynWzjK34k571JsJWytg3RvJSHH5dVqq2czwigMrUdI5aL1k3tLlynghukuRJ5Y7Bey1YqqCHbc8WwMy419w2Qb3goP0f+EVyrjYqZLC6LPUBYmlyWe+XM0bgzy1PzoS6isUluAcuk6u5xWVCZFT3xeqCIfYbspBYy93KP25gwwj4/lULPBPcYAFhytwQzfe0UA9m4vgb52lHXkwQctcLhZrM4KHoByn0eJuL4geUJ0dx3WZ2rGJB1I9WmsW3jWOqqbOE2qiM5781LgXcdMp0Go5zPCKBCtU1Nc0AZHSp4vV6th7LSsrQPafVKazRDZvk8mfoWrTRtbKmUdYp2RXw/rJWmY6acC8MnqeBWRjkP98Qnc3xcfuZLsVda5rL3kaBvnq4R8PmpG8IkY9CtvizQWAePyRqpYGa6m6pn2T5MOXOReTdXuddUFSxEHD+oPOs1I2UfHYwDGqlVkir54oh6DwAbVfMxYunFpmyatXkXpbh96Q/MbH6O8jbNrAKpWqq3z/fToAksEiSLvUiTUvbdka3TSNwFrjiNpnu+gzQ4RiW9WUlPE/Vn+LhugA4rc5TIffLc8TafS+j4d8jnZ9gvKptKh7uFNCQ5QDl1RQ1X8PXl6+GpXmzWyyolTQ/SN1yTGw4YEjHccVf3eQjbQw09fkl5hO4pFy0M9zrlWaBJVWl0Zkp+1SDs9W57te7wkc24zc9FV1CvN33S3yBY9z0AbEDtb9ZSXxIy5CkXeJrOqvFPPdajHtJ9Sx+jIeqnpLzunqOUVxd5e241qxs3eF0390jdSqsqcpYoY4/VoLqb0emyMJIOTo3QSGpgzU+NdGUsSTeHljlC5D5tlJrTPVpJf6WyQWNyIZ+fl+5uoGR/igY28v6hrkkjTDqYtq7IsIX04mxdKN4kaMZmZRhEMikyfMRLvDqU4ZZotUQcP7A8ahc9/GRv1uIwWxyKaUhy40KGvcwvJVT9l/s+dH1IcstD3rPqrEpdU5FVp5RPFtapoLasMv6rzmUaGZv9GcFdCZM+RJAvh/FO3OwEWxsmfQCobzH0iOvEwjC3mos3aQEAAGwGBOI1zG9w5WdB9q5lAACATYLUNECdQ2oaoL6hRwwAABCjqveIAQAAoHxITQPUOaSmAeobUtMAAAAxQiAGAACIEQIxAABAjGoQiHP+eUb5Ub1JCOTYem5f+StY/uMW13nkTz8GnVwmXyjddh1yvjV/Vzfs+GHKOm/A+/BErYO7l6lzvokT7BzV7t9i3wz+ubB9j9uet3czjw0Qnxr1iOXvwZpZStTfiq7+l4H8wXffdGdmikBv4gQmM6e0+eYtNOTvx94yf6+2zOAm5/OmbDRK5ydel++8AHeCZuq7rOu6nabQm6nIm4e8Aubvpuv2bZWPvRG+8gBUR+1T02FzAN8umYO3cN1rFcvMK6mhISrOjyYztZTOpHQb1Jy/ztzK/Gx8JGCGJADYMDvH8Fax1coDd4baB2KZWNudXFylZ22KqdhTLs7Gwg+3+els3z583Sxkdp5gFYl10N19aBelvGA5T3PevMS619vb227OaXvB8q/M/mIm27fnDSpj6fzH8r56Or0ZkoLLH3ZeszbsPYt5932HtGICP0t/Og8tedDk2iteF8HXOj9syrd0uVxfpndY7jSIStjxA8oj9SFj4l5x9qUQlZRbLZY66C536kbIsSoqD0AFahSITWCTi3q800kjceWTv+nspa3Jm1s3fdYs44U9IydNsJLtZUpAvW6UA687H/GulJ0gnIOumrQ/TZ09pvddEiilTIXdo3wcd3rBNJ2V89lUupp2KayMMi9xca7f0rR0cPlF0Hm1qH36TxKNyjo17aGZz9knpJwyD20qa46LmaRAy/Wa6Qbt9eJd6/2U7zHXi50G0Bdw7D5B03KuJ/z4QeWR+iBTOYoeqfNRF68a5jH7yk583G5fJXHKzY0GO0WibG/PoYWXsaLyAFSgtmPEclG76VwzjusFaW5ueuOupoWt5yc1ZPu24oxIdq5SyxsnlqCb2qWCfXI3qXHitePDJfMJh4koo8xLzAfn1vICXS/oyck9QeVXIs4bsY+dn1W+cAZ6bIPDEVZOlULPrN9TgbuKnnBfXy/etSH1Rv41c/bKPNhrps93s1lqIn8z37f7PEzE8QPLUynbk7XdVpdTbpteTun0mDm3Uc5nAFBltU1NcxAZHSp4vV6th7LS8rQPaWVKhVJz+suyeT2hdznMOHGOg67tnapgOTd5m+PDAWUUNh2em+T/lqTbKy1/2ftI0DdP1wgop+kpjFK3+mJBNu0u17abpL3Y3HdZ9xyZmki/fVjVG+HdAOVeR1UgjWERdPyg8lQSjtWwDgdNbvF7x9mIqDICbJaajxFLLzZlU6vNuyjF7U9/YGbzc5Q3Xxi0wEHONkll+3w/DZpgsjB80t9zVIGxnzJcH73eqewz0k/93vhwhcLKqEh6mqhfTth1SPdYRVj5o0Tu49z9rdYF3BQWWU5ezV90cqepTaXDnSxNx6Ql59QVNUTB11Sbe52qXqwMxWhJvpil/ZfvHyxmrXLDAcMghjsu7D4PIY3iyOOXlEf4equhbONUZ5tsMA1jj6nrgtxPUqxs65WxvPIAVKb2N2upLwkZ5pQWb5rOqjFPbgFLGkge0mVLH6MhDqhJed09Rynv2uftubWrbpTgdd0cdv1tXz1u60uf8T6dspFvfDiKbG9SvKr7GFJGQ1fcknRzaPkjRO7TRqk53aOVVn8qGzQ+F1JOL93dQMn+FA3gt1J3BWl4ScfQ1hVJ10ovz6aOizcGmrFZGfqQ7IkMH/GSjLlmGjJjavuqiDh+YHnULnr4KfrmqGbqG5CtdL3tXqfI9rNRPe+GJI3x+TzrfAbllQegMpj0AaDOYdKH2yN3UMvNW3IDFjLQEIcYesQAAFtFjgZVzr54EyhArSEQA8BdJuf8ZjlDIxyE52v1l7kAAiA1DVDnkJoGqG/oEQMAAMSo6j1iAAAAKF/DLfm1OgAAAMQCqWkAAIAYIRADAADECIEYAAAgRgjEAAAAMUIgBgAAiBECMQAAQIwQiAEAAGKEQAwAABAjBGIAAIAYIRADAADECIEYAAAgRgjEAAAAMUIgBgAAiBECMQAAQIwQiAEAAGKEQAwAABAjBGIAAIAYIRADAADECIEYAAAgRgjEAAAAMUIgBgAAiBECMQAAQIwQiAEAAGKEQAwAABAjBGIAAIDYEP0/mcJcUXgBftYAAAAASUVORK5CYII=
    In the C# code('Edit Script' button), you just add this line to your entry point method (default is Main but can be changed on the properties):

    Dts.Variables["User::TestTarget"].Value = Dts.Variables["User::TestSource"].Value;

    Run the task/package. On exit of the script task, the TestTarget value is the same as TestSource.
    You just need to remember to set variable scope correctly.

    If variables from package parts can be defined in a package, they can be accessed by package elements so that should work.

  • adelio.stevanato 21159

    SSC Enthusiast

    Points: 182

    I am trying to understand how Microsoft could introduct something so limited.
    ALL our packages are highly parameterised, this includes the database connection details plus a ton of other variables. If there is no way of passing in variables for connections or anything else then for us it is essentially useless.It would have been far better if Microsoft had produced something that was truely usefull instead of something half baked. And it seems to have quite a few issues (errors) as well.

  • Fly Girl

    SSCommitted

    Points: 1560

    Thanks to this post: https://prathy.com/2016/06/my-thoughts-on-ssis-2016-ssis-package-parts-2/  it appears that you can use the Package Parts variables in the Package but you have to manually change the scope of the variables once you pull the PP into the Package.
    However, for my organization as well, the separate connection objects are the killer shortcoming. There's no way we're going to manually change the connections on the parts when all the Package connections are being managed/changed via environments on the server.
    I'm hoping this will improve in future versions but at the moment what they have out with 2017 is not good enough to be useful.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply