Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Where are the XML Format Files

Posted on 2011-02-27
5
Medium Priority
?
355 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

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…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

609 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