SSIS 2008 - Back Up Database Task - Setting DestinationManualList Property Causes an Error
-
2012년 3월 23일 금요일 오후 6:11
I've tried to set the DestinationManualList property via expression. When I try to run the package I get the following error message:
Notfatal errors occurred while saving the package:
Error at PreExecution Database Backup: The result of the expression "[@User::sDBList]" on property "DestinationManualList" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
How can I set this property (if at all)? I'm looking to submit random lists of databases to the tasks.
DJ Baby Anne's Biggest Fan................
- 편집됨 Abercrombie07 2012년 3월 23일 금요일 오후 6:16
모든 응답
-
2012년 3월 23일 금요일 오후 6:39중재자That is because you use some kind of invalid characters, e.g. a // or \\
Arthur My Blog
-
2012년 3월 23일 금요일 오후 6:50Not at all. The variable is simply a database name.
DJ Baby Anne's Biggest Fan................
-
2012년 3월 23일 금요일 오후 7:00중재자Capture the run-time variable's value and post it here please
Arthur My Blog
-
2012년 3월 24일 토요일 오후 5:20
sDBName = GoofOff.
This variable has this value in it before the package starts. I even set the delayvalidation to true on both the task and package.
DJ Baby Anne's Biggest Fan................
-
2012년 3월 29일 목요일 오전 7:00중재자 Hi Abercrombie07,
According to the error message, it seems cannot set expression on the DestinationManualList Property, please try to set value on the property directly, here is a link about DestinationManualList property, please refer to: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.databasemaintenance.idbmaintenancebackuptaskinterface.destinationmanuallist(v=sql.110).aspx
Thanks,
Eileen- 답변으로 표시됨 Eileen ZhaoMicrosoft Contingent Staff, Moderator 2012년 4월 5일 목요일 오전 7:51
.png)
