oledb passing a table to sql server
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.
November 6th, 2012 1:46pm

what errors?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 6th, 2012 2:01pm

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
November 20th, 2012 4:03am

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
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2012 4:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics