Post reply

Binary data back

  • February 21, 2006 at 9:56 am

    #365334

    There is a table with varbinary data type. I try to use DTS to transfer this table to file and back. But instead of binary I get back varchar. Is it possible to get back varbinary (if not with DTS then how)? Thanks

  • February 21, 2006 at 2:47 pm

    #622463

    Hello Yuri,

    Yes, it is possible.

    1. If you are using DTS Import Wizard then in the window "Select Source Tables and Views" click "Transform" button and specify the data type that you need in the data type field.

    2.If you use DTS designer, then in the Transform Data Task Properties on the Destination tab either select the destination table and specify the correct field that already has a correct data type OR click CREATE button and modify SQL Statement in the window to reflect the data type you want

    Let me know if you have more questionshow to do that.

    Regards,Yelena Varsha

  • February 21, 2006 at 4:14 pm

    #622476

    Thank you, Yelena. This is what I am looking for.

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

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