SSIS File Connection makes the dtsx package think it's corrupt - by Adam Goetz

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


0
0
Sign in
to vote
ID 260973 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/2/2007 9:08:32 AM
Access Restriction Public

Description

I am setting the path for a flat file to a directory my user account does not have access to.  Everything works at runtime, when I open the dtsx package claims to be corrupted and I get errors stating  the ConnectionString cannot be written to the property.  
Sign in to post a comment.
Posted by Microsoft on 4/28/2008 at 2:35 PM
We have only been able to reproduce the problem if we enter the expression without including the double quotes (") which we believe is required for string constant.

Once we reproduced the problem, we did see an error message from BIDS saying the package "might" be corrupted. This is a general message for any package we fail to load and we do not think we need to change anything here. From the actual error list (tab), you should be able to see the real error messages and there is nothing there that says the package is corrupted. As a result, we are closing this case. If you disagree, please feel free to open a new case with us. We appreciate your time and effort and moreover, your support of SSIS.