October 22, 2014 at 1:00 am
SOLVED
OK,we have the following an SSIS package that based on the variable Run_Type will either get:
*full:load in all the data from the archive source + load in all the data that's in the delta source,
*archive:load in all the data from the archive source,
*delta: load in all the data that's in the delta source where the data of adding was in the last 24 hours
I tested the job thoroughly and set it up,I'm using the following under the 'Set Values' tab
Property Path Value
\Package.Variables(Run_Type).Value 'delta'
Resulting in the error:
Status: Failed Ran at: ../../... 05:00:00 Executed as user: .... Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:00:00 DTExec: Could not set \Package.Variables(Run_Type).Value value to delta. Started: 5:00:00 Finished: 5:00:06 Elapsed: 5.101 seconds. The package execution failed. The step failed.
So what am I doing wrong,since I can't find a straight answer to this.
OK so the solution was simple
\Package.Variables(Run_Type).Value needs to be \Package.Variables[Run_Type].Value
I'm guessing that I made this mistake due to the font on the sites I found the information,that or I need new glasses
October 22, 2014 at 1:03 am
Try using square brackets around the variable name.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
October 22, 2014 at 1:07 am
Txn,it was that simple
October 22, 2014 at 1:12 am
Resender (10/22/2014)
Txn,it was that simple
:smooooth: Simple is good.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply