<div>
Please attach an image of your SQLStatement as it appears in the SQL Task editor and the Result Set tab or at least double check them to make sure the column name / alias match the Result Name column in the Result Set tab.
</div>


Please attach an image of your SQLStatement as it appears in the SQL Task editor and the Result Set tab or at least double check them to make sure the column name / alias match the Result Name column in the Result Set tab.

<div>
<div class="content wysiwyg-content">
I created a script task in the control flow for getting the recent date of the job from DB. It was working previously when i ran the package but now its throwing an error as mentioned in the title.<br />
<br />
Can someone help me on this one ?
</div>
</div>


I created a script task in the control flow for getting the recent date of the job from DB. It was working previously when i ran the package but now its throwing an error as mentioned in the title.

Can someone help me on this one ?

Execute SQL Task: An error occurred while assigning a value to variable &quot;RecentPackageExecutionDate&quot;: &quot;Unable to find column LastTimeJobRunDateandTime in the result set.&quot;.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Execute SQL Task: An error occurred while assigning a value to variable &quot;RecentPackageExecutionDate&quot;: &quot;Unable to find column LastTimeJobRunDateandTime in the result set.&quot;.

Execute SQL Task: An error occurred while assigning a value to variable "RecentPackageExecutionDate": "Unable to find column LastTimeJobRunDateandTime in the result set.".