March 21, 2011 at 1:08 pm
Nonfatal errors occurred while saving the package:
Error at Desk_Updates [Connection manager "Excel Sheet"]: The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.
Error at Desk_Updates: The result of the expression "@[User::FileName]" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
I don't know why this message comes ...but i can understand that its something with the Excel Connection manager. But can someone explain me this error....as u can get it, trying to make Excel source Dynamic
March 21, 2011 at 3:25 pm
Whatever you have currently in the Filename variable on the package that's being fed into the expressions for the Excel Data source won't work. It's not compiling properly. My guess is you have it blank.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 22, 2011 at 2:21 pm
It could be due to incorrect path in the connection string. If using a relative url try to reproduce the error from local dir.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply