Post reply

Create file with all field names but export only certain fileds

  • December 1, 2009 at 4:50 pm

    #139754

    Hey all.

    In sql 2000 I had a dts package that output all the field names in a table to a file but it also only output three of the fields data. For instance there are say 25 fields which are required as a header in the file but only three of the fields data is required(sku,qty,update) to be there for update purposes. All fields are tab delimited. Works great in dts but I can't seem to get this to happen with SSIS. Any help would be greatly appreciated.

    example attached

    Thanks

  • December 1, 2009 at 9:23 pm

    #1086249

    [font="Comic Sans MS"]

    Hello - you can use a derived column transform from the flatfile source and default the values to be NULL. Let me know if you need more elaboration ..

    [/font]

    [font="Comic Sans MS"]--
    Sabya[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply