October 12, 2009 at 10:47 pm
HI can you help me out with this plz or atleast give me some kind of idea..
my company has sql express edition sp3. i have few tables in which data will be stored by means of some applications.
My role is to query the data according to the client requirement and convert the data in to xml file and save the xml file in some folder...
Is there any way to automate this process. I don't want to write the code for every time when i get the new data. .. i mean to say whenever i receive the new data the above process should be done and xml file has to be stored in a folder...
Can you plz suggest me something.......! I am really having a tough time
October 13, 2009 at 1:20 pm
sam-1083699 (10/12/2009)
...My role is to query the data according to the client requirement and convert the data in to xml file and save the xml file in some folder...
Is there any way to automate this process. ...
Standard answer: it depends.
Step 1: query the data: If the requirement doesn't change or the changes are "predictable", the query most probably can be "automated".
Step 2: To save the result as a file, look for "bcp" options in BOL (BooksOnLine).
October 13, 2009 at 2:48 pm
"For XML" should be able to do the XML conversion you need. Then (as mentioned), bcp would allow you to automate the export.
I'd need more details on table structure and data to get more specific, but those two tools will be enough to accomplish this, it's just the details that are missing.
- 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
October 14, 2009 at 5:39 am
You can use:
1. DTS (SQL Server 2000) or SSIS (SQL Server 2005/2008).
2. CLR Function
Regards,
Igor Kruk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply