I am trying to transfer the data from flat file to sql server.When I am running the package on local server(network server) it works fine.But when I user it to transfer the data to online server it starts and shows 2771 rows transfered and remains on that only. when i stop the execution I get the following errors:
[DTS.Pipeline] Error: The pipeline received a request to cancel and is shutting down.
[Loose Diamond File ] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[DTS.Pipeline] Error: The PrimeOutput method on component "Loose Diamond File" (1) returned error code 0xC02020C4. 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.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.
Can any one help me to find what the problem is.
Thanks in advance.