Import Excel Text via SSIS to sql table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Import Excel Text via SSIS to sql table

Author

Topic

khorkh888
Starting Member

4 Posts

Posted - 2012-05-14 : 03:21:40

Hey All Expertises,

I am facing problem to load a batch of text in Excel into sql table using SSIS. Here is in Excel look like:

Date KPI Plant Remarks
01-04 A 1 U3 not is down
01-04 B 1
02-04 A 2 L3 is down due to
1) no material
2) no schedule
3) waiting for vendor

As you can see, the Remarks column can have "enter" value. How to load all this into SQL table with same display as in Excel?

Help needed please. Thanks.

KKH

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-14 : 23:18:57

are values still come under same cell or spanning over multiple cells?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

khorkh888
Starting Member

4 Posts

Posted - 2012-05-15 : 01:40:25

Hi Visakh,

There are total of 4 columns ( Date, KPI, Plant, Remarks). For Date, KPI & Plant is very simple. Each value is under it owns cell.
But for the Remakrs, it is description column. So, user able to input & hit the "Enter" key to get the multiple line within the same Cell.

Eg: This is only 1 record for

Date KPI Plant Remarks
---- --- ----- --------
02-04 A 2 1) No material
2) No schedule
3) waiting for vendor

Thanks for the help

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-16 : 00:12:07

so all these lines should end up in same record in table?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

khorkh888
Starting Member

4 Posts

Posted - 2012-05-16 : 02:45:07

hi Visakh.

Yes. It should be in 1 record only.

Thanks.

KKH

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-16 : 20:12:09

quote:
Originally posted by khorkh888

hi Visakh.

Yes. It should be in 1 record only.

Thanks.

KKH

is there a definite delimiter to indicate end of row?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

khorkh888
Starting Member

4 Posts

Posted - 2012-05-23 : 21:42:17

hi Visakh,

Actual is the CR/LF function at the end of the wrong.
Good news, I am able to load all the data in. Initailly, it was truncate after 255 character. So, I change it to unicode text. Now all record are loaded :-).

Thanks for the reply.

Regards .

KKH

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-24 : 16:10:53

np
glad that you sorted it out!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources