This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 83%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Is it possible to get task property in script task
like
Data Flow Task -----------> Script Task ----- > Execute SQL Task
User Variable : Disable 0/1
in My Script Task, i want to set property of Execute SQL Task , Disabled = 0 or 1 based on variable
I can set property in Expressions of Execute SQL Task
but i want to do in Script Task
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 57.99999999999999%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Hi,
According to your description, it is related to SQL configuration. Please try to post the issue to SQL forum to help you better, they will be more professional on your issue.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver
Hope this helps and please help to accept as Answer if the response is useful.
Best Regards,
Carl
That's portal i always post my questions, but now i don't see SQL Server options, It used to be SQL Server under this we see SSIS, SSRS , T SQL now i don't see it
