February 14, 2011 at 9:01 am
Designed a basic package into SQl dest...here is error
Error: 0xC0202071 at Data Flow Task, SQL Server Destination [22]: Unable to prepare the SSIS bulk insert for data insertion.
Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "SQL Server Destination" (22) failed the pre-execute phase and returned error code 0xC0202071.
Can anyone guide me plz...Thank u
February 15, 2011 at 2:08 am
Is the package running on the same server as the SQL Server Destination?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 15, 2011 at 8:38 am
yes ...source and destination are on the same server...But i read in some forum, to replace sql dest with OLEDB dest...where it work out completly fine. But i want to know whats making these errors with sql dest..Thank you
February 15, 2011 at 11:24 am
quillis131 (2/15/2011)
yes ...source and destination are on the same server...But i read in some forum, to replace sql dest with OLEDB dest...where it work out completly fine. But i want to know whats making these errors with sql dest..Thank you
Maybe it has something to do with User Account Control?
Check out this link:
http://support.microsoft.com/kb/2009672
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply