Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
convert nvarchar sql server data type to number in ssis
April 02, 2013
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...
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.
To post reply
Related Questions Related Questions
Get XML Data in datagridview from SQL SERVER Table
Copying Data from SQL Server 2008 to SQL Express
How to insert data of selected checkboxlist control in database.. (sql server)
How to conenct Sql Server and Display Data of a table in WPF Windows Application
Find Maximum Length of data in sql server
Storing XML Data in SQL Server
Read data from xml using sql server
Content Type Change could not be migrated on existing custom list, which having data!
Generate Random number in SQL Server
Data Synchronization in Sql server 2008 using C#, ASP.NET
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend