//
you're reading...
ASP.NET, Database, IT-Center, SQL Server, VB.NET, Web Based

Error SSIS Variable (Cannot assign value to variable): The result of the expression “_” on property “Executable” cannot be written to the property. The expression was evaluated, but cannot be set on the property.

Stack error assign value to SSIS paramter via ASP.NET or batch file. Yesterday I’m stack in Execute Process Task to execute Batch file, that batch is setting of SSIS execute.
The First solution,
1. restart your IIS (if using ASP.NET)
always restart your IIS after changed the SSIS component and properties value
2. Change variable properties EvaluateAsExpression value is “true”
3. Expression in variable properties, assign with @[User::variable_name]
4. Value field value is dummy value from variable name ex: [your path xls]

About berbagisolusi

Berbagi merupakan sebuah bentuk simbol keikhlasan untuk membantu dan menolong, sedangkan solusi adalah cara menyelesaikan masalah. Setiap manusia pasti mengalami masalah, tetapi kita tidak perlu mengalami masalah yang sama jika orang lain pernah mengalami dan kita tahu hal tersebut.

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 9 other followers

March 2012
M T W T F S S
« Feb   Apr »
 1234
567891011
12131415161718
19202122232425
262728293031  

Archives

Web Statistic

Blog Stats

  • 149,551 hits
%d bloggers like this: