<div>
Thanks for the response<br />
<br />
Sorry I think I did not describe my issue real well that resulted in misunderstanding and complicated solution. <br />
<br />
I think I was able to solve my problem just by using a derived column. I capture the value in and pass it on the derived column and then I map the derived column to the column in my database.
</div>


Thanks for the response

Sorry I think I did not describe my issue real well that resulted in misunderstanding and complicated solution.

I think I was able to solve my problem just by using a derived column. I capture the value in and pass it on the derived column and then I map the derived column to the column in my database.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an SSIS package. I want to get the value of the data source connection string and send it to a variable.<br />
I will use that variable to map to the column in the sql database as &quot;OriginalDB&quot;. The data source in an access database.<br />
<br />
Can anyone tell me how to approach this?<br />
<br />
Thanks
</div>
</div>


Hi,

I have an SSIS package. I want to get the value of the data source connection string and send it to a variable.
I will use that variable to map to the column in the sql database as "OriginalDB". The data source in an access database.

Can anyone tell me how to approach this?

Thanks

Mapping a variable to a column inside Data Flow Task 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.