Post reply

export table in package problem

  • March 22, 2007 at 1:24 am

    #119200

    I have created a package which export a table in SQL2k5 to a dbase file. I created a SQL native client and a MS Jet 4.0 OLE Jet DB provide. I make Source point to SQL native client connection manager and OLE DB destination point to MS Jet 4.0 OLE Jet DB provide connection manager in Data Flow specification.  When I try to run the package, it saids all the columns cannot between unicode and non-unicode string data types. Is there any setting I need to change. Please help. Thanks.

  • March 23, 2007 at 10:41 pm

    #696741

    you basically have to set column mapping and set the data type conversion as couple of datatypes as varchar are not availble in Dbase

    -Krishna

     

  • March 25, 2007 at 6:10 pm

    #696794

    What is the dbase datatype as corresponding to SQL server varchar datatype? Thanks.

  • March 29, 2007 at 6:57 pm

    #697785

    I solved the problem by adding data conversion task between source and

    destination. But this does only for append. How can I do it for overwrite?

    Thanks.

  • April 3, 2007 at 6:26 pm

    #698435

    Can anyone please help? Thanks.

  • April 3, 2007 at 9:54 pm

    #698454

    Try using Data Conversion Task.  In this task you can change the output data type that dbase will import.

     

    JL.

Viewing 6 posts - 1 through 5 (of 5 total)

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