Creating instances of excel file

Question

Creating instances of excel file

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

rs80 SSCrazy Points: 2312 More actions · Answer 1

I spoke too soon 🙂

Phil's approach is working. But when I try to run the package thru a batch job passing variables for the template path (source) and report path (destination) the package is still referring to the values that I have set locally. I'm expecting the variables to pick up the values from the batch job. Do I have to set expressions for the source and destination properties in each of the fst?

Phil Parkin SSC Guru Points: 246965 More actions · Answer 2

rs80 (4/3/2013)
I spoke too soon 🙂
Phil's approach is working. But when I try to run the package thru a batch job passing variables for the template path (source) and report path (destination) the package is still referring to the values that I have set locally. I'm expecting the variables to pick up the values from the batch job. Do I have to set expressions for the source and destination properties in each of the fst?

Can you provide a bit more detail about this 'batch job'? How are you calling the package and how are you passing the values to it?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

rs80 SSCrazy Points: 2312 More actions · Answer 3

I'm using the DtsRunTime.package to call the package and package.Execute to run the package. In the same library, I'm using DtsRunTime.Variable to pass the variables to the package.

Does that answer your question?

Phil Parkin SSC Guru Points: 246965 More actions · Answer 4

rs80 (4/3/2013)
I'm using the DtsRunTime.package to call the package and package.Execute to run the package. In the same library, I'm using DtsRunTime.Variable to pass the variables to the package.
Does that answer your question?

Hmm, not the answer I was expecting. Is this a C# app that is calling the package?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

rs80 SSCrazy Points: 2312 More actions · Answer 5

rs80

SSCrazy

Points: 2312

April 3, 2013 at 8:47 am

#1603218

Yes, it is.

Phil Parkin SSC Guru Points: 246965 More actions · Answer 6

Right - I've never done that.

It might be worth creating another thread & posting your C# snippet, if it's not too complex.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

rs80 SSCrazy Points: 2312 More actions · Answer 7

Unfortunately, it is complex. And I think it's more of me not setting up the fst correctly. Do I need to set the source and destination properties as expressions assigned to variables?

kl25 Hall of Fame Points: 3752 More actions · Answer 8

rs80 (4/3/2013)
Unfortunately, it is complex. And I think it's more of me not setting up the fst correctly. Do I need to set the source and destination properties as expressions assigned to variables?

Anything you want changed at runtime should be set in expressions.

rs80 SSCrazy Points: 2312 More actions · Answer 9

The format of the variable being passed was incorrect. The variables were set correctly with evaluate to expression. Sorry for extending this post. It was a stupid mistake 🙂

kl25 Hall of Fame Points: 3752 More actions · Answer 10

rs80 (4/3/2013)
The format of the variable being passed was incorrect. The variables were set correctly with evaluate to expression. Sorry for extending this post. It was a stupid mistake 🙂

No problem. It happens. Glad you got it all worked out. 🙂