question

balanarasimhac-1495 avatar image
0 Votes"
balanarasimhac-1495 asked ZoeHui-MSFT commented

How to load numeric and string data into SQL table

Hi Team,
Have large data set in excel sheet and want to load into sql table but one of field having combination of numeric and string data.
While importing this data into table , string data coming as 'NULL'. Please help on this issue.
Sample data looks like bellow , am facing issue in Ticket No column
95991-image.png


sql-server-generalsql-server-integration-services
image.png (52.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @balanarasimhac-1495,

You may use SSIS package to load the data into SQL table.

The Data Conversion transformation could convert the data in an input column to a different data type and then copies it to a new output column.

data-conversion-transformation

You may also refer SSIS Data Conversion Transformation with Step by Step Example.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you have any updates, don't forget to tell us.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

So it is a SSIS package to load the data?
You have to define the source and target colums as string / varchar /D_STR data type.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.