.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

convert nvarchar sql server data type to number in ssis

Posted By: Gurpreet     Posted Date: April 02, 2013    Points:5   Category :Sql Server
I have one column in sql server DB having nvarchar data type and i want to put this table data to excel file,but it showing text data in the excel file.my requirement is to convert the sql server nvarchar column to numeric data type in ssis so that correct format(number format) can be insert into the destination excel file.Please let me know how i can do this.i tried with this approach use data conversion transformation and select eight byte signed ineteger data type ,but its not working.Thanks in advance...

Author: Deco             
Posted Date: April 03, 2013     Points: 20   

In the nvarchar dataty pe column, if you do not have digits then the conversion will be failed.

In the dataconversion transformation please use unsigned integer.


Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend