SQL Server Integration Services 2012 (RC0) Project Conversion Bugs

Question

Though I'd share a blog post regarding a large number of bugs I've found in the SSIS Conversion Wizards.

SQL Server Integration Services 2012 (RC0) Project Conversion Bugs

Associated Microsoft Connect Item: 721089

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 1

Since posting this I’ve discovered that the Int32 error discussed on my blog occurs irrespective of whether the ServerPort value is greater than 32767 i.e. even a value of 21 (the default) causes the same error.

I’ve also discovered that the following additional FTP Task properties cause the same Int32 error (irrespective of their value):

ChunkSize
Retries
Timeout

I believe this error occurs because the datatype for these properties is being stored in the configuration file as Int32 and the Integration Services Project Conversion Wizard expects them to be Int16.

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker