September 9, 2008 at 10:58 am
I hope an expert will be able to resolve this quite easily as I'm quite new to SQL functions.
A string of 48 numbers in one table that need to be split during DTS to 12 sets of 4 and placed in 12 seperate existing columns in another table. There's no other tranformation necessary. It seems so simple but struggling to find solution.
Source destination is an MySQL db "dev1_data" to MSSQL db of the same name.
Any help and pointers would be greatly appreciated. 🙂
September 9, 2008 at 11:44 am
You could run the data through a proc that would split it for you. Would that solve your problem?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply