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


Package Parts – First Impressions


Package Parts – First Impressions

Author
Message
shubhankarthatte
shubhankarthatte
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 73
Comments posted to this topic are about the item Package Parts – First Impressions
Dave Pendleton
Dave Pendleton
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 165
The inability to access package variables renders Package Parts pretty useless, actually.
RonKyle
RonKyle
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2746 Visits: 3499
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
Luxgilby
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1527 Visits: 180
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
RonKyle
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2746 Visits: 3499
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.




Steve Hall
Steve Hall
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2824 Visits: 11564
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
Luxgilby
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1527 Visits: 180


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
adelio.stevanato 21159
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 46
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.
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