I often receive data from trading partners in a tab delimited or fixed width
text file. I often receive a schema document which I use to create my DTS
package to automate the import of these files.

My question is this: How can I generate a schema document like this when I
am asked to provide a file layout to these vendors?

I'm not sure if this is the right group to ask this, but thanks in advance
for any insight.

Deborah

And what would you want it to look like?

Have you looked at BCP to create a fomat file for you?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Deborah Bohannon" <dbohannon (AT) nationalDONOTSENDHEREcareanetwork (DOT) com> wrote
in message news:ehRMP4o6DHA.2572 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

An example of what I receive, that I would like to create something similar
is this:
ClientNumber X(19)
Client_CLM_ID 9(11)
Provider_ID X(09)
Provider_Name X(50)
Provider_Add1 X(35)
Provider_City X(20)
Provider_State X(2)
Claim_TYPE X(03)
Claim_Total 9(12)

I haven't used BCP in several years. Can it create a schema of a file?

Thanks,
Deborah


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

By all accounts yes.

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\cop
rompt.chm::/cp_bcp_61et.htm

in | out | queryout | format

Specifies the direction of the bulk copy. in copies from a file into the
database table or view. out copies from the database table or view to a
file. queryout must be specified only when bulk copying data from a query.
format creates a format file based on the option specified (-n, -c, -w, -6,
or -N) and the table or view delimiters. If format is used, the -f option
must be specified as well.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Deborah Bohannon" <dbohannon (AT) nationalDONOTSENDHEREcareanetwork (DOT) com> wrote
in message news:uOrKEYp6DHA.2480 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Thanks very much for the response. I will do some practicing with BCP.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote