Advertisement

07.13.2008 at 01:31PM PDT, ID: 23561208 | Points: 500
[x]
Attachment Details

Export table to Fixed Width text file with column widths.

Asked by donnie91910 in MS SQL DTS

Tags: SQL Server 2000

I need to export a table to a fixed width text file with column widths.  I have tried using DTS but it won't let me designate the column widths such as:
COLUMN                 WIDTH
AccountNo                 10
Name1                     32
Name2                     32
Name3                     32
Name4                     32
Name5                     32
Name6                     32
AccountClass              13
RepID                      6
Mgr_ID                     7

Rep_Name                  32
Bus_Street1               32
Bus_Street2               32
Bus_City                  32
Bus_State                 10
Bus_Zip                   16
MSI_Code                  10
IRAType                   10
InstitutionType           16
XRefAccountNo             14
PoolInd                    8

Match                      1
FeeSchedleNew             14
Firm_Number               12
Open Date                 12
Acct Designation          18
Master Acct               12

Acct Name Fields          18

RepCorrBD                  3

Subsidiary Number         3

Is there any way to do this?

Thanks in advance,
Donnie91910
Start Free Trial
[+][-]07.13.2008 at 01:48PM PDT, ID: 21994146

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.

 
[+][-]07.13.2008 at 01:51PM PDT, ID: 21994151

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.

 
[+][-]07.13.2008 at 04:33PM PDT, ID: 21994766

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.

 
[+][-]07.14.2008 at 01:19AM PDT, ID: 21996426

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.

 
[+][-]07.14.2008 at 05:27PM PDT, ID: 22003259

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.

 
[+][-]07.22.2008 at 04:06PM PDT, ID: 22064510

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.

 
[+][-]07.22.2008 at 04:31PM PDT, ID: 22064650

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.

 
[+][-]07.22.2008 at 07:14PM PDT, ID: 22065490

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.

 
[+][-]07.22.2008 at 08:27PM PDT, ID: 22065753

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.

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