Having searched the forum, this one clearly has form... However beyond assisting those who have fallen at the first hurdle (i.e. forgetting/not knowing that they cannot execute the package remotely to the instance of SQL Server into which they are inserting), the issues raised by others have not been addressed. Thus I am bringing nothing newÃÂ to the table hereÃÂ - just providing an executive summary of problems which others have run into, written about, but not received answers for.
First the complete error:
Description: Unable to prepare the SSIS bulk insert for data insertion.ÃÂ End ErrorÃÂ Error: 2008-01-15 04:55:27.58ÃÂ ÃÂ ÃÂ ÃÂ Code: 0xC004701AÃÂ ÃÂ ÃÂ ÃÂ Source:ÃÂ <xxx> DTS.PipelineÃÂ ÃÂ ÃÂ ÃÂ Description: component "<xxx> failed the pre-execute phase and returned error code 0xC0202071.ÃÂ End ErrorÃÂ DTExec: The package execution returned DTSER_FAILURE (1).ÃÂ Started:ÃÂ 4:53:34 AMÃÂ Finished: 5:00:00 AMÃÂ Elapsed:ÃÂ 385.384 seconds.ÃÂ The package execution failed.ÃÂ The step failed.
It mostly works - It produces no error more than 9 times out of 10.
It fails on random dataflows - My package has several dataflows, (mostly) executing concurrently. Where the error occurs it does not do so on the same dataflow each time: on one run it'll fail on dataflow AÃÂ whilst B,C,D and E succeed, then A-E will all succeed (and continue doing so for the nextÃÂ ten runs thereafter), and
View Complete Post