<div>
Good comment by dsacker. &nbsp;You could also in his last step, instead of setting the CreditRating to 0 run your calculation on the existing data to get it caught up.
</div>


Good comment by dsacker.  You could also in his last step, instead of setting the CreditRating to 0 run your calculation on the existing data to get it caught up.

<div>
<div class="content wysiwyg-content">
I have a table that's already being populated by a SSIS package nightly. The table is never truncated. The table is below:<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w12/1086433/Co.png" target="_blank" title="table 1 (8 KB)"><img alt="table 1" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/03_w12/800_1086433/Co.png" /></a><br />
I want to add a new column for Credit Rating in the source code of the SSIS package. The joins are already there to support the data i want to add etc, so just adding the column would work.<br />
<br />
My question is how would this impact the existing data in the table that don't have credit rating info.<br />
<br />
Also when the job runs tonight, would it just automatically create the new column and add the info, not modifying the existing data?
</div>
</div>


Co.png

I have a table that's already being populated by a SSIS package nightly. The table is never truncated. The table is below:


I want to add a new column for Credit Rating in the source code of the SSIS package. The joins are already there to support the data i want to add etc, so just adding the column would work.

My question is how would this impact the existing data in the table that don't have credit rating info.

Also when the job runs tonight, would it just automatically create the new column and add the info, not modifying the existing data?

SQL Update Table

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

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.