Professional Web Applications Themes

Exporting Different Tables to Same Flat File - Microsoft SQL / MS SQL Server

If you cannot find a why to do it, consider making two files and then use DOS XCOPY (or whatever) to combine them into one. Bye, Delbert Glass "Bill Knight" <crazy_legselong.com> wrote in message news:07a101c345a7$08ba2de0$a101280aphx.gbl... > Hi, > > I am resonably comfortable with bcp and DTS however I was > not able to solve this problem. I want to export two > different tables to the same flat file. The data for the > first table would appear at the top of the flat file while > the second table's data would just be appended. I thought > for ...

  1. #1

    Default Re: Exporting Different Tables to Same Flat File

    If you cannot find a why to do it,
    consider making two files and then
    use DOS XCOPY (or whatever) to combine them into one.

    Bye,
    Delbert Glass

    "Bill Knight" <crazy_legselong.com> wrote in message
    news:07a101c345a7$08ba2de0$a101280aphx.gbl...
    > Hi,
    >
    > I am resonably comfortable with bcp and DTS however I was
    > not able to solve this problem. I want to export two
    > different tables to the same flat file. The data for the
    > first table would appear at the top of the flat file while
    > the second table's data would just be appended. I thought
    > for sure bcp would have some sort of flag that would
    > append the data to the file; however it does not. Any
    > ideas would be helpful.

    Delbert Glass Guest

  2. #2

    Default Re: Exporting Different Tables to Same Flat File

    Bill,

    As you are using bcp you are already at a command prompt,
    so how about the dos copy command ?

    copy File1 +File2 File3

    does an append, you may want the /b option for binary - see Windows help.
    You won't be able to easily undo this merge for importing into the target system though.

    Regards
    AJ

    "Bill Knight" <crazy_legselong.com> wrote in message news:07a101c345a7$08ba2de0$a101280aphx.gbl...
    > Hi,
    >
    > I am resonably comfortable with bcp and DTS however I was
    > not able to solve this problem. I want to export two
    > different tables to the same flat file. The data for the
    > first table would appear at the top of the flat file while
    > the second table's data would just be appended. I thought
    > for sure bcp would have some sort of flag that would
    > append the data to the file; however it does not. Any
    > ideas would be helpful.

    Andrew John Guest

Similar Threads

  1. dataProvider is XMLList from flat-file
    By new2Flex3 in forum Macromedia Flex General Discussion
    Replies: 3
    Last Post: May 10th, 04:56 AM
  2. Inquiry on Flat File
    By Relz in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: January 29th, 09:36 PM
  3. insert flat file to database
    By chingc in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: June 22nd, 02:29 PM
  4. Exporting tables via ODBC from SQL SERVER
    By Mark in forum ASP Database
    Replies: 4
    Last Post: January 15th, 11:13 AM
  5. Undefined tables after exporting slices in MX 2004
    By RedEraser webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 2
    Last Post: October 1st, 05:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139