Solved

Where are the XML Format Files

Posted on 2011-02-27
5
341 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 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL - Curser to do an insert based on a select 2 29
find SQL job run average duration 24 75
sql server major issue  need help 2 81
2008 to 2016 jump (SQL Server) 1 30
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…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

737 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