SQL Server Performance

export a table in package

Discussion in 'SQL Server 2005 Integration Services' started by supernova122, Mar 21, 2007.

  1. supernova122 New Member

    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.
  2. supernova122 New Member

    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.
  3. MohammedU New Member

    What is destination file type?
    If it is excel then it appends so every time you need to create a new file...
    Check www.sqlis.com or www.sqldts.com for samples....


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page