<div>
@Author - a feedback will be appreciated :)
</div>


@Author - a feedback will be appreciated :)

<div>
<div class="content wysiwyg-content">
Hello ,<br />
<br />
I have a excel source that has values , specifically having a year and month value in 2 columns. I want to read from that spreadsheet and retireve the year and month value and use them as a parameter to be able to delete records from a SQL table using SSIS to do all of this?<br />
<br />
Thanks
</div>
</div>


Hello ,

I have a excel source that has values , specifically having a year and month value in 2 columns. I want to read from that spreadsheet and retireve the year and month value and use them as a parameter to be able to delete records from a SQL table using SSIS to do all of this?

Thanks

Retrieve a value from excel cell and use it as a Parameter in SSIS easily?

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.