<div>
You will need to modify that SSIS package whether is stored inside SQL or as a file and re-do the mapping to include the newly added columns in the source query as my guess is they are just &quot;ignore&quot; now.
</div>


You will need to modify that SSIS package whether is stored inside SQL or as a file and re-do the mapping to include the newly added columns in the source query as my guess is they are just "ignore" now.

<div>
Actually I left out an important fact, and I'm sorry about that. It wouldn't populate when running from the SQL job. I had to refresh the SQL job, after I made the changes to the SSIS package and then it worked.
</div>


Actually I left out an important fact, and I'm sorry about that. It wouldn't populate when running from the SQL job. I had to refresh the SQL job, after I made the changes to the SSIS package and then it worked.

<div>
OK so you mean it is now all working as expected after refreshing the SQL Job to point to the modified package?
</div>


OK so you mean it is now all working as expected after refreshing the SQL Job to point to the modified package?

<div>
<div class="content wysiwyg-content">
I have a SQL table called ABC, that is being populated with data by a SSIS SQL task. It works fine for the original columns.<br />
<br />
I added three new columns to the ABC table.<br />
<br />
I modified the original SQL query that the SSIS SQL task is using. I first tested the new query in SSMS, and the three new columns of SQL table ABC has data.<br />
<br />
However, when I save the SSIS package with new SQL query, those 3 column show as NULL. The correct values are not there, like when I run the same query SSMS.<br />
<br />
Please advise.
</div>
</div>


I have a SQL table called ABC, that is being populated with data by a SSIS SQL task. It works fine for the original columns.

I added three new columns to the ABC table.

I modified the original SQL query that the SSIS SQL task is using. I first tested the new query in SSMS, and the three new columns of SQL table ABC has data.

However, when I save the SSIS package with new SQL query, those 3 column show as NULL. The correct values are not there, like when I run the same query SSMS.

Please advise.

SQL SSIS Package

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.