<div>
To capture the current row number you will need to use the script task and while you're there might as well concat the results for your new value instead of derived column.<br />
<br />
There are a lot of examples on the web on how to write the script
</div>


To capture the current row number you will need to use the script task and while you're there might as well concat the results for your new value instead of derived column.

There are a lot of examples on the web on how to write the script

<div>
<div class="content wysiwyg-content">
Hi I am a newbie to SSIS. I have to export an Excel file to SQL Server table but there is a column which has a certain format which need to be followed. Trying my luck to write its expression for Derived Column but in vain. The format is as follows:<br />
<br />
ABCDYYMM0001 <br />
<br />
0001 portion will be incremented depending upon the number of rows. <br />
<br />
Thanks in advance.
</div>
</div>


Hi I am a newbie to SSIS. I have to export an Excel file to SQL Server table but there is a column which has a certain format which need to be followed. Trying my luck to write its expression for Derived Column but in vain. The format is as follows:

ABCDYYMM0001 

0001 portion will be incremented depending upon the number of rows. 

Thanks in advance.

SSIS Expression for a column after importing an excel file to SQL

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

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.