> Hi,
>
> Is it possible to convert string data to integer in SSIS ? I tried
> using the cast -- (DT_I8) and the Data Conversion data flow item. It
> errors out saying "Failed to perform type cast". The DataConversion
> doesnt work either.
>
> Please let me know if you know how to perform this conversion.
>
> Thanks.
>

Darren Green wrote:
> Hello namratha.pavar@gmail.com,
>
> > Hi,
> >
> > Is it possible to convert string data to integer in SSIS ? I tried
> > using the cast -- (DT_I8) and the Data Conversion data flow item. It
> > errors out saying "Failed to perform type cast". The DataConversion
> > doesnt work either.
> >
> > Please let me know if you know how to perform this conversion.
> >
> > Thanks.
> >
>
> The two methods you mention shoudl work fine, so perhaps there is something
> in the string that prevents this. There are no nice format or culture modifers
> in the SSIS casts.
> If you give an example of your string then someone can probably suggest a
> suitable method.
>
> Darren