Advertisement

09.23.2005 at 12:23AM PDT, ID: 21571468
[x]
Attachment Details

Importing fixed field width txt files into SQL Server using associated fdf files

Asked by drjimcook in MS SQL Server

Tags: ,

I have many ca. 1-5 Gb fixed field width txt files to analyze, and am currently attempting to import them into a MS SQL Server database. They were apparently exported from SAP, and each came with a corresponding fdf file that lists the field layout and field type information ...

PCFDF
PCFT 1
PCFO 1,1,1,1,1
PCFL YR 1 2
PCFL DIV 1 18
...
PCFL E12 2 13/3

I see no way to get MS SQL Server Enterprise Manager to use this fdf information natively. That is, once I specify fixed width txt format, the import wizard gets to a window where it wants me to click each field boundary. I have that information in the fdf files, but I don't want to go through the process of defining ~100 field spans for ~20 files. I know that the fdf files were created by SAP during the export operation, but they're apparently not being recognized by MS SQL Server Enterprise Manager as import templates.

Is there a third party app that'll do that import for MS SQL Server, properly using the fdf files? The layouts will  not necessarily be identical for all the txt files, so I really need to use the information from each txt file's corresponding fdf.

Thanks

Jim Cook
jimcook@panix.com.no.spamStart Free Trial
 
Keywords: Importing fixed field width txt files into …
Title
1 SAP Basis
2 Question about DIV ?
3 finding the width of a div with overflo…
4 div tag
5 Include div pages in breadcrumb
6 get container div to auto fit its content
 
Loading Advertisement...
 
[+][-]09.23.2005 at 12:27AM PDT, ID: 14942527

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.23.2005 at 01:47AM PDT, ID: 14942738

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.23.2005 at 03:17AM PDT, ID: 14943002

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.23.2005 at 06:25AM PDT, ID: 14943972

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.23.2005 at 07:01AM PDT, ID: 14944273

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.23.2005 at 03:42PM PDT, ID: 14948804

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.23.2005 at 06:30PM PDT, ID: 14949491

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.23.2005 at 08:08PM PDT, ID: 14949693

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.23.2005 at 09:46PM PDT, ID: 14949878

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.23.2005 at 10:56PM PDT, ID: 14950013

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.24.2005 at 02:30AM PDT, ID: 14950291

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.24.2005 at 08:57AM PDT, ID: 14951153

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.24.2005 at 02:28PM PDT, ID: 14952026

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.24.2005 at 02:56PM PDT, ID: 14952094

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2005 at 04:05AM PDT, ID: 14953566

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.25.2005 at 01:58PM PDT, ID: 14955220

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.25.2005 at 02:40PM PDT, ID: 14955320

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: import, sql
Sign Up Now!
Solution Provided By: _b_h
Participating Experts: 6
Solution Grade: A
 
 
[+][-]09.26.2005 at 04:23AM PDT, ID: 14957750

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.26.2005 at 06:01AM PDT, ID: 14958330

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.27.2005 at 01:59AM PDT, ID: 14965076

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.28.2005 at 05:08PM PDT, ID: 14980144

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]09.29.2005 at 03:23PM PDT, ID: 14988341

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.29.2005 at 03:51PM PDT, ID: 14988479

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32