SSIS : Acquiring dynamic metadata of spreadsheet columns for a Excel Connection (data flow destination) - by Rakesh Parida MSFT

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
1
Sign in
to vote
ID 346868 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 5/28/2008 10:38:06 PM
Access Restriction Public

Description

Currently for a data flow task in SSIS, we have the following issue with respect to a Excel destination. More often than not we work in situations where we actually create the Excel spreadsheet columns before inserting data into it. In such a scenario the SSIS package fails during the pre-validation phase as it would not be able to acquire column metadata from an absent Excel file.

Sign in to post a comment.
Posted by Microsoft on 8/10/2010 at 4:35 PM
Thank you for contacting us. After analyzing this issue and prioritizing it in the context of our current development plans, we have found regretfully that it does not meet the bar to be included in an upcoming product release. If you feel that you could provide us with more data to change that judgment, we welcome any further information. Your feedback continues to be invaluable to us and we take all your communication seriously. Please continue to contact us with any questions, suggestions and issues as they arise.

     The SSIS Team
Posted by Microsoft on 6/13/2008 at 10:11 AM
Thank you for your feedback and support of the SSIS product. This issue doesn’t currently meet the requirements for correction in SQL 2008. We're going to keep it open for triage in the next release.

Again we appreciate your time and support.