If you provide the DDL (create statements) for your tables, sample data for the source table (as insert statements that can be cut, paste, and executed in SSMS) to load that is representative of the entire data set, we can see what is needed to be done.

If you have questions on how to do all this, it is in the article I pointed you toward in my last post.