December 16, 2008 at 8:41 am
I have a job scheduled on the SQL Server, which has a SSIS step.
In the step I have "Set values" as follows:
Property Path = \Package.Variables[User::etl_chain]
Value = [DS_HR_PAY_LOAD]
In the SSIS project, I have a project variable called etl_chain with datatype of string
In the above SSIS project I have a Script task
ReadWriteVariables = etl_chain
In the script I use
Dts.Variables("etl_chain").Value.ToString
When I run the scheduled task I get the following error:
.. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "/Package.Variables[User::etl_chain].Properties[DS_HR_PAY_LOAD]" is not valid. The command line parameters are invalid. The step failed.
Following is the command line being generated:
/SQL "\FSIT0198LT24\DTS Packages\isEdwReady" /SERVER fsit0198lt24 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /LOGGER "{59B2C6A5-663F-4C20-8863-C83F9B72E2EB}";"E:\" /SET "\Package.Variables[User::etl_chain]";"[DS_HR_PAY_LOAD]" /REPORTING E
QUESTIONS:
1. Am I on the right path believing that the Properties in SQL Jobs are passed to the SSIS job as variables?
2. What should I be setting the properties to to make this work?
3. If #1 is false, Is there a way to pass a "value" from the job to the ssis package?
Thanks in advance,
-Steve Nelligan
December 16, 2008 at 10:28 am
FYI, Found the problem.
Two problem, the logging to E: was not working (E: was subst drive done after starting SQL)
AND
The Value should not include [ ]. When I changed these it stated to work.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply