July 15, 2010 at 10:29 am
Guys I have data in sql table
Ex:
AcctNum AcctName Fname Lname transaction
123 test john doe 100
123 test john doe 150
345 test2 jack nick 50
345 test2 jack nick 300
What I need is export this data into files based on AcctNum.... if there are 5 distinct AccNum, there should be 5 flat files created with each file having info for its own acctnum. I am sure many of you have done this before... wanted to check if someone can help. Thanks!
July 15, 2010 at 10:30 am
I'm happy that you have data in a table...:hehe:
What is your specific question/problem?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
July 15, 2010 at 10:33 am
MeltonDBA (7/15/2010)
I'm happy that you have data in a table...:hehe:What is your specific question/problem?
heheheh that was accident... I pee'ed before I unzipped my pants 🙂
July 15, 2010 at 1:30 pm
http://www.sqlservercentral.com/articles/SSIS/68025/
The above tutorial has it... thanks to sqlcentral.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply