I have 30 Excel spreadsheets that I am merging into a SQL table. I first truncate the table than copy each spreadsheet to the table. I keep getting the following error:
"The connection is currently being used by a task. The connection can not be closed or reused"
Each time I execute the package it fails on a different spreadsheet. I am the only one accessing the spreadsheets on a development server. I have set the package property:
Limit the maximum number of tasks executed in parallel to 1.
Any ideas on what is causing the error?
"The connection is currently being used by a task. The connection can not be closed or reused"
Each time I execute the package it fails on a different spreadsheet. I am the only one accessing the spreadsheets on a development server. I have set the package property:
Limit the maximum number of tasks executed in parallel to 1.
Any ideas on what is causing the error?
