locked
error while processing csv file RRS feed

  • Question

  • Hi,

    i get this messages while processing a csv file to load the content to database,

    [SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL;
     data flow performance counters are not available.  To resolve, run this package as an administrator, or on the system's console.

    [SSIS.Pipeline] Warning: The output column "Copy of Column 13" (842) on output "Data Conversion Output" (798) and component
     "Data Conversion" (796) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

    can someone please me with this.

    With Regards


    litu Here

    Saturday, January 4, 2014 10:49 AM

Answers

  • Hello Litu,

    Are you using: OLEDB Source and Destination ?

    Can you change the source and destination provider to ADO.NET and check if the issue still persist?

    Mark this post as "Answered" if this addresses your question. 

    Regards,

    Don Rohan [MSFT]


    Regards, Don Rohan [MSFT]

    • Proposed as answer by Mike Yin Tuesday, January 7, 2014 3:46 PM
    • Marked as answer by Mike Yin Wednesday, January 15, 2014 5:09 PM
    Monday, January 6, 2014 10:23 AM
  • See if this helps

    http://support.microsoft.com/kb/2496375/en-us


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Tuesday, January 7, 2014 3:46 PM
    • Marked as answer by Mike Yin Wednesday, January 15, 2014 5:09 PM
    Monday, January 6, 2014 11:10 AM

All replies

  • Hello Litu,

    Are you using: OLEDB Source and Destination ?

    Can you change the source and destination provider to ADO.NET and check if the issue still persist?

    Mark this post as "Answered" if this addresses your question. 

    Regards,

    Don Rohan [MSFT]


    Regards, Don Rohan [MSFT]

    • Proposed as answer by Mike Yin Tuesday, January 7, 2014 3:46 PM
    • Marked as answer by Mike Yin Wednesday, January 15, 2014 5:09 PM
    Monday, January 6, 2014 10:23 AM
  • See if this helps

    http://support.microsoft.com/kb/2496375/en-us


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Tuesday, January 7, 2014 3:46 PM
    • Marked as answer by Mike Yin Wednesday, January 15, 2014 5:09 PM
    Monday, January 6, 2014 11:10 AM