Solved

Where are the XML Format Files

Posted on 2011-02-27
5
338 Views
Last Modified: 2012-08-13
I do not want to have to create thirty or so XML/Text Format Files by hand. I assume the SQL Data Import utility saves the format file somewhere. Can you please help me find it or suggest another, GUI-based, quick method/script option to create a bunch of format files. I eventually intend to use the bcp utility and the format files to automate data imports. any guidance appreciated. thanks!
0
Comment
Question by:HankinCooper
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 34994943
I am not sure I am following. Are you trying to to export data from the database into a Text file?
0
 

Author Comment

by:HankinCooper
ID: 34995105
import data into the database using the bcp command line tool. My understanding is I need a format file to suppliment this inport which the import/export data seems to facilitate. I asuume those format files are stored somewhere or am hoping there is a quicker way to create a format file other than byhand...
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 35000690
See if this helps: http://support.microsoft.com/kb/67409

There is a question half way down the page that addresses your question.

Hope this helps.

P.
0
 
LVL 17

Expert Comment

by:pssandhu
ID: 35000718
What format is the data currently residing as?
0
 

Author Closing Comment

by:HankinCooper
ID: 35023793
Thanks, helped but still a manual process. thanks.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question