SSIS "COMMA PROBLEM" - SQL Server Forums

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)

SSIS "COMMA PROBLEM"

Author

Topic

tooba111
Starting Member

22 Posts

Posted - 2010-10-25 : 22:01:46

I have source field like
"Classes" and data is
C1,C2,C3,C4,

DESTINATION TABLE FIELDS ARE:-
GRADE1,GRADE2,GRADE3,GRADE4

My question is how i can do "comma separate" my END REST should be like this
GRADE1 = C1
GRADE2 = C2
GRADE3 = C3
GRADE4 = C4

I want to done this one through SSIS. I am using SSIS TO finish my project. I believe i can use "Derived Column" transformation. Please help me solve this problem. Thanks.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-03 : 10:19:44

Try this logic
http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/csv-to-multiple-columns.aspx

Madhivanan

Failing to plan is Planning to fail

tooba111
Starting Member

22 Posts

Posted - 2010-11-04 : 00:13:26

Thanks for your reply! Is any one can help me how i do this one in SSIS?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources