Solved

Where are the XML Format Files

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Help - 12 60
SQL Maintenance Plan 3 29
How to SQL Trace a SPECIFIC query 24 57
SQL Server Question 5 25
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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 is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now