The first section introduces a suspected bug in function design when I sorted out SSIS 2012 data the other day. In script task, I can assign values to variables in the read-only list. I remember that in the previous version 2008, in order to understand the configuration, I also tested the details, obtained errors, and understood the function. But now, when I went back to test version 2008 again, I found that this feature is actually incorrect in version 2008, and I totally overturned the test results I was impressed, so it's hard to figure out whether or not I got this error. The description of the suspected feature bug defines the User-Defined variable-pv_current_date In The SSIS package and places them in readonlyvariables, according to our general understanding, these variables should be read-only in the script task and cannot be assigned to them. To read and write a variable, put the variable in readwritevariables. In the code, we can see that the variable pv_current_date is assigned a value. An error should be reported. If the package fails to be executed, the execution is successful! How can we solve or describe this problem in SSIs 2012? Test the function. Modify the variable pv_current_date to set its readonly attribute to true, indicating that it is read-only. In this case, an error occurs. Through breakpoint debugging, you will find that the cause of this error is: Error trying to write to a read-only variables, trying to write a value to the read-only variable. The only thing that can be explained is that the readonlyvariables list in SSIs 2012 can only contain readonly = true. In readwritevariables, all variables with readonly = false or readonly = true can be seen. If this is the intention, I think this design is very awkward, and readonlyvariables is easy to mislead, people think that the variables in it are read-only in the script task! On the msdn forum, I posted this question to the msdn Forum-is it a bug-SSIS 2012 readonlyvariables in script task doesn' t work to reply to two posts.
MVPBoth ssisjoost and visakh16 reproduce this problem and think it is a design bug. But in the end, I deny myself and can only say it is a suspected bug. But from this perspective, it may also be by design. Here is my personal opinion: on this question, I also mentioned it to Microsoft. I can visit SSIS 2012 readonlyvariables in script task doesn' t work to follow the final confirmation from Microsoft's technical team. For this problem, including the above two very Nb
MVPAnd the other two cool people in the post SSIS script task 'readonlyvariables 'I have dug up.
MVPArthur urz and Reza Raad share the same view of this feature as suspected bugs.
If so many people think so, even if it is not a bug, this design also has problems and defects, because it has misled many people.PS
MVPMicrosoft SQL Server 2012 integration services: an expert cookbook, other articles about script task script tasks Microsoft Bi SSIS series-use script tasks to access SMTP servers not verified by windows to send emails to Bi MVPs on the msdn Forum
- Arthur urz (MVP, mcdba, mcad, MCTs and mcitp)
- Reza Raad (MVP, MCP, MCTs and MCI by Microsoft SQL Server 2012 integration services: an expert cookbook)
- Ssisjoost (MVP, SSIS)
- Visakh16 (MVP, SSIs, SSAs, SSRs)
For more bi articles, see the Bi series Essays (SSIS, SSRS, SSAs, MDX, SQL Server, to help others quickly see these articles in the recommendation bar of the biwork blog.
Microsoft bi's SSIS series-a bug in scrip task scripts that MVPs cannot understand
