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.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2013-10-29 : 22:22:23
|
| Hi Guys, Need help, Here is my sample dataLAT|BOX|5290113661|BP9744524|PHY|JAI|GREWAL|1|BI|VaccBill|MED|191.2||SHI||20131015|5024206001|||||6|116820411||LAT|BARDI|TAMMY|20020 44th|PHY|MARK|MORADI|BI|Vacc Bill|MED|183.0||SHI||20131016|50242006001|||||6|116899590||LAT|ARRE|SONIA|344 RICH|PHY|IAN|HANT|1|BI|Vacc Bill|MED|153||SHI||20131016|50242006|||||3|116786607|AND I want to be my out put in Flat file like this.LAT|BOX|5290113661|BP9744524|PHY|JAI|GREWAL|1|BI|Vacc Bill|MED|191.2||SHI||20131015|50242006001|||||6|116820411||LAT|BARDI|TAMMY|20020 44th|PHY|MARK|MORADI|BI|Vacc Bill|MED|183.0||SHI||20131016|50242006001|||||6|116899590||LAT|ARRE|SONIA|344 RICH|PHY|IAN|HANT|1|BI|Vacc Bill|MED|153||SHI||20131016|50242006|||||3|116786607|Here I want, Split in second rows Where start with "PHY",Third Row where find "BI",Fourth Row where find "MED",fifth row where find "SHI"... Please let me know if you need more information....First Step I am using to create a Store Procedure with all information and calculated what I need and my SP Out is above sample data.Second step I am using to do some steps and transfer data from SQL table to flat file, here my flat file would be like that (out sample is above). I know I can use Script Task to accomplish what I want or other way to accomplish this task. Any advise would be great...Thank You... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Urgent SSIS Help