<div>
Error in attachement?<br />
<br />
You must see that all input-record have valid input. &nbsp;The IsNumeric()-function can be usefull to filter the invallid records out first. What to do with the others depends on your process: neglect with or without (I hope not) error, putting dummy 0 in the place ...
</div>


Error in attachement?

You must see that all input-record have valid input.  The IsNumeric()-function can be usefull to filter the invallid records out first. What to do with the others depends on your process: neglect with or without (I hope not) error, putting dummy 0 in the place ...

<div>
Try<br />

<pre><code id="code-20-39831394-1">Cast(replace([Salary],',','') as int) &gt; cast(20000 as int)</code></pre>
</div>


Try


Cast(replace([Salary],',','') as int) > cast(20000 as int)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp; &nbsp;I am trying to convert a salary field (coming from a comma delimited txt file) into an int so that I can compare it to 20000 in a SSIS conditional split condition. <br />
What I do in the conditional split is this:<br />
Cast([Salary] as int) &gt;&nbsp;cast(20000 as int)<br />
<br />
However, I keep getting this error in the attatchment. How can i convert my text field Salary to an int and then compare to 20K?<br />
<br />
thx
</div>
</div>


Hi,

   I am trying to convert a salary field (coming from a comma delimited txt file) into an int so that I can compare it to 20000 in a SSIS conditional split condition. 
What I do in the conditional split is this:
Cast([Salary] as int) > cast(20000 as int)

However, I keep getting this error in the attatchment. How can i convert my text field Salary to an int and then compare to 20K?

thx

Datatype conversion in SSIS

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.