Post reply

SSIS Export to Native Format?

  • January 8, 2009 at 12:40 pm

    #195846

    I am curious about whether it's possible to export tables using SSIS into a format that bcp can use to import.

    The reason being that we export volumes of data to a client who is external, and uses bcp. Also, one can not underestimate the value of smaller files..

    We have some inscrutable problems with our bcp out, and are hoping to do the same function under tighter control.

    Thanks for any help - Jonathan

  • January 8, 2009 at 10:42 pm

    #923917

    jonathan_harley (1/8/2009)

    I am curious about whether it's possible to export tables using SSIS into a format that bcp can use to import.

    The reason being that we export volumes of data to a client who is external, and uses bcp. Also, one can not underestimate the value of smaller files..

    We have some inscrutable problems with our bcp out, and are hoping to do the same function under tighter control.

    Thanks for any help - Jonathan

    How about: export to CSV, compress, send ?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 9, 2009 at 11:25 am

    #924441

    I guess the answer is no?

    I have already explored different potential, non-bcp formatted options. We cannot force our client to switch their interface, we need a bcp compatible end result.

    Thanks for your input - Jon

  • January 9, 2009 at 11:41 am

    #924461

    jonathan_harley (1/9/2009)

    I guess the answer is no?

    I have already explored different potential, non-bcp formatted options. We cannot force our client to switch their interface, we need a bcp compatible end result.

    Thanks for your input - Jon

    Can you please explain why do you think CSV is not compatible end result? CSV can be processed by bcp, so whats wrong with that?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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