Welcome to Sign in | Help

Re: Problema cu OLE DB Source

  •  02-14-2011, 11:14 PM

    Re: Problema cu OLE DB Source

    @Cristian - daca ar fi o problema de conversie legata de row-urile din baza de date, nu ar trebuie sa primesc aceeasi eroare la executia procedurii stocate din sql studio express ? 

    & in sp nu se face nici o conversie de la nvarchar la integer, cum imi zice textul erorii.

    eroarea zice ca apare in faza de pre-execute - "failed to pre-execute"

    Pe MSDN la pre-execute zice asa ceva:

    " PreExecute is called before the PrimeOutput and ProcessInput methods, and is the first opportunity for a component to perform this work after the BufferManager becomes available to the component. During this method, the component should locate its columns in the buffers and store this information internally so the columns can be used in either the PrimeOutput or ProcessInput methods."

    Problema mea cea mai mare este urmatoarea:

    - de ce daca iau VM-ul de production, il transfer pe un alt server fizic....pachetul SSIS ruleaza fara nici o pb cu aceleasi date  (acelasi Windows Sever, instanta, configurari, baza de date etc.)

    - daca ar fi problema cu datele din DB nu are trebui sa imi returneze aceeasi eroare ?




View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems