question

wondermorris avatar image
wondermorris asked

ssis import not clean

Hello SSC, I need help to perform an import from share point list to sql table. I am using SSIS for this. Sql server 2012 and Visual Studio is 2010. I have setup connection from Share Point Source to Sql Server Destination.I have tried using data conversion and derived column as well. But data appears as below in SQL table: Class Cert Discovery Complete (~130,000 pages) Inactive - Pending2dCir. Where as in share point list it is like below: College degree Discovery Complete (~130,000 pages)Inactive - Pending 2d Cir Pl let me know if I am missing something OR if I should use some tool to clean off data. Thanks in advance PS: Message is not allowing to show HTML tags in question.
ssissql-server-2012sharepoint
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
How do you want the string to read when it gets into the database table? Did you cross up some columns in SSIS or is Class Cert from a completely different part of the Sharepoint page?
0 Likes 0 ·

1 Answer

·
west007 avatar image
west007 answered
Yes, looks like concatenated from two or more fields
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.