none
Connection Manager on CRACK!!!!!!!

    Question

  • I have a package that  WILL Not read a particular Decrypted file even though it will read others.  I have never seen anything like this, can ANYONE PLEASE help me?!?!?!?!?!?!!!!!

    Warning: 0x80049304 at Insert Decrypted Files into Deardorff_files DB, SSIS.Pipeline: 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.

    Warning: 0x80047076 at Insert Decrypted Files into Deardorff_files DB, SSIS.Pipeline: The output column "FileName" (4261) on output "Lookup Match Output" (3275) and component "AAL3 LookUp" (3273) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.

    Error: 0xC020200E at Insert Decrypted Files into Deardorff_files DB, Flat File Source [4877]: Cannot open the datafile "C:\TempDispositions\20130213011957_sprint_AAL3.0_citi_dispositions.csv".

    Error: 0xC0047038 at Insert Decrypted Files into Deardorff_files DB, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Flat File Source" (4877) returned error code 0xC020200E.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
    Information: 0x40043008 at Insert Decrypted Files into Deardorff_files DB, SSIS.Pipeline: Post Execute phase is beginning.

    Thursday, February 14, 2013 3:01 PM

Answers

  • I just dropped and changed the Connection Manager and it was fixed!  Go FIGURE!!!  LOL!!!
    • Marked as answer by Eileen Zhao Monday, February 25, 2013 2:49 AM
    Thursday, February 14, 2013 7:24 PM

All replies

  • Best guess would be that the file is open in another application

    Chuck Pedretti | Magenic – North Region | magenic.com

    Thursday, February 14, 2013 3:04 PM
  • Thursday, February 14, 2013 3:07 PM
  • Thursday, February 14, 2013 3:08 PM
  • This is the only thing open.  I placed another File in this location and it ran fine.
    Thursday, February 14, 2013 3:21 PM
  • This is the only thing open.  I placed another File in this location and it ran fine.

    Another file being the key phrase.  See if you can rename the file you are having issues with, that will tell you if some process has it open.

    Chuck Pedretti | Magenic – North Region | magenic.com

    Thursday, February 14, 2013 3:24 PM
  • I renamed it and the rows still refuse to be seen by the connection manager, and they only show up if I go to the columns tab and press reset.  Then it only shows the rows as columns with no data.
    Thursday, February 14, 2013 3:35 PM
  • Hello Soldiefc,

    Are you using a ForEach Loop container? Why does the connection string have an *? Is the value of the ConnectionString dynamic? I think the * is the cause of the issue


    • Edited by Mayorlag Thursday, February 14, 2013 3:36 PM typo
    Thursday, February 14, 2013 3:35 PM


    • Edited by soldierfc Thursday, February 14, 2013 3:40 PM
    Thursday, February 14, 2013 3:38 PM
  • This is a MULTIFLATFILE Connection Manager.  It is not using a For Each loop Container.
    Thursday, February 14, 2013 4:13 PM
  • I renamed it and the rows still refuse to be seen by the connection manager, and they only show up if I go to the columns tab and press reset.  Then it only shows the rows as columns with no data.

    Have you opened the file in a text editor to see if there is anything odd about the format of the file?  Using something that will show you any control characters in the file would work best.  (EditPadLite is what I use)

    Chuck Pedretti | Magenic – North Region | magenic.com

    Thursday, February 14, 2013 4:24 PM
  • The odd thing is that if I save it as an MS-DOS CSV it works FINE! Is there a way I can change it in the control Flow TAB?
    Thursday, February 14, 2013 5:40 PM
  • The odd thing is that if I save it as an MS-DOS CSV it works FINE! Is there a way I can change it in the control Flow TAB?

    OK - so that one file uses a different encoding.  Are there different processes generating the files or are they something that someone may have manually opened and saved the file as an incompatible format?  Changing it on the fly would require a script task to open the file and save using a particular encoding.

    Chuck Pedretti | Magenic – North Region | magenic.com

    Thursday, February 14, 2013 7:15 PM
  • I just dropped and changed the Connection Manager and it was fixed!  Go FIGURE!!!  LOL!!!
    • Marked as answer by Eileen Zhao Monday, February 25, 2013 2:49 AM
    Thursday, February 14, 2013 7:24 PM