|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Tuesday, September 29, 2009 11:24 PM
Points: 12,
Visits: 77
|
|
Hi All,
I want to migrate a DTS structure storage file into SQL 2005 and then run it using SSIS. As i loaded the file using BIDS and it appears in Legacy under Data Transformation Services.
When i run the package in BIDS it gives me following error
[Execute SQL Task] Error: There is an invalid number of result bindings returned for ResultSetType: "ResultSetType_Rowset".
This dts package is using two connections. one with local sql 2005 and one with remote mysql Db to get data from .
Can someone tell me how to resolve this issue. I will be greatfull.
Thanks in Advance.
Regards
Asif
|
|
|
|
