I am able to pass a table to a stored procedure using sqlconnection and sqlCommand. This is via SSIS passing a table object inside a task script. I am unable to do the same process using OLEDB I am getting errors.

what errors?Arthur My Blog

Hi Mark_Steinberg, How do you pass table to SQL Server using OLEDB? The error can occur if you assign NULL to a string variable. Please refer to the following links: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ed762aac-2f11-4010-b2c9-77dce2150acc http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/bf6c2be7-00f3-4ead-90e8-b69e2b32eb92 Thanks, EileenEileen Zhao TechNet Community Support

Hi Mark_Steinberg, How do you pass table to SQL Server using OLEDB? The error can occur if you assign NULL to a string variable. Please refer to the following links: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ed762aac-2f11-4010-b2c9-77dce2150acc http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/bf6c2be7-00f3-4ead-90e8-b69e2b32eb92 Thanks, EileenEileen Zhao TechNet Community Support