title: How do I fix the multiple-step OLE DB operation errors in SSIS?
body: <p>I'm attempting to make a DTS package to transfer data between two databases on the same server and I'm getting the following errors. Iv read that the Multiple-step OLE DB operation generated error can occur when you are transferring between different database types and there is loss of precision, but this is not that case here. How do I examine the column meta data?</p>
  
  <blockquote>
    <p>Error: 0xC0202009 at Data Flow Task,
    piTech [183]: An OLE DB error has
    occurred. Error code: 0x80040E21. An
    OLE DB record is available.  Source:
    "Microsoft SQL Native Client" 
    Hresult: 0x80040E21  Description:
    "Multiple-step OLE DB operation
    generated errors. Check each OLE DB
    status value, if available. No work
    was done.".</p>
    
    <p>Error: 0xC0202025 at Data Flow Task,
    piTech [183]: Cannot create an OLE DB
    accessor. Verify that the column
    metadata is valid.</p>
    
    <p>Error: 0xC004701A at Data Flow Task,
    DTS.Pipeline: component "piTech" (183)
    failed the pre-execute phase and
    returned error code 0xC0202025.</p>
  </blockquote>