Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    23

    Unhappy Unanswered: DTS Export Data Pump appending file

    Hi!!
    I've a "little" problem...
    I must generate a txt file with this structure:

    - one header
    - n details

    Header and details have different structure and i must write header before details.. I've already a table with details.. i could create table for header, but this table design it's too different than details design.. and i can't use the union statement in the output query..
    Can i write the header line and write details in append on a txt file??
    with data pump i can create and replace file.. but not append??
    I know that i could use the filesystem object to modify the file, but i would bypass it with tasks of SQL server..
    it's possible?


    Thanks!!!

    PS: I hope that you understand my problems..
    I know poor english.. ;-)
    Alx_81 =)

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: DTS Export Data Pump appending file

    Why not post your DDL and DML...

    Check out

    Code:
    SELECT Data_Row FROM (
        SELECT '"Owner","Job"' As Data_Row, 1 AS Row_Group
     UNION ALL
        SELECT '"' + l.Name+ '","' + j.Name + '"', 2 AS Row_Group 
          FROM msdb..sysjobs j
    INNER JOIN master..syslogins l 
            ON l.sid = j.owner_sid
    ) AS XXX
    ORDER BY Row_Group
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2003
    Posts
    23

    thanks

    thanks..
    i've already done in that mode... ;-)
    Alx_81 =)

Posting Permissions

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