N/APosted on - 06/27/2011
The Bulk Insert Task in the SSIS is not getting executed and it's displaying an error regarding the execution. I have checked the configurations, it is correct. I have tried many times, but it was giving different errors during each time of execution. I don’t know what is happening with this Bulk Insert Task in SSIS. Please help…..
Issue in using Bulk Insert Task in SSIS.
I have faced the same problem with this Bulk Insert Task in SSIS. I did a lot of changes in it. No luck. In this case, you can use the Bulk Insert SQL query in the Execute SQL task. That would be better. Both the scenarios will do the same work and produce the same results. But I feel it is better to use the Bulk Insert SQL query in the Execute SQL task. But be sure about the syntax of the Bulk Insert Query.
The main issue in the Bulk Insert Task is, if you are trying to insert the data in the server database, you require full access permission of that server. Even if there is any threat in access permission, Bulk Insert Task could fail. In this case, Bulk Insert Query will be helpful.
Hope this reply would help you tackle the issue and get some idea about the Bulk Insert Task in the SSIS.