You can't persist the value IN the package from run to run. HOWEVER you could query the max id from the destination at the start of the package run...

You are welcome..

CEWII

Does your package have anything like a script task with a msgbox command. I'm thinking that this might somehow be a cause..

CEWII

How is this being run? SQL Agent Job, xp_cmdshell, or what. I assume you are coming in through remoe desktop.

CEWII

It would be interesting to know their rationale for resistance to trusted connections, since it simplifies the whole process and is usually a lot more secure.

CEWII

stricknyn (5/20/2010)

---

2 part question. I have a SSIS package which has about 15 data flow tasks. These tasks don't need the success of one another in orther to...

Most people solve this by using package configurations.

I personally NEVER save any passwords into the package.

I have seen some hybrid methods where an encrypted password is passed by...

With some effort you can get into the execution task hosts and extract out additional information, I'm not really sure about custom SSIS tasks though. I'm sure they can...

I think the long and short is HOW do you know which action is being taken?

CEWII

petehughes247 (5/19/2010)

---

Maybe I'm missing the point here but, if I develop a standard package template (connections & variables), and then I develop a dozen packages based on that template, what...

In a lot of ways I'm a lot more comfortable with an in-place upgrade from 2005 to 2008. I'm not sure I could quantify exactly why but the jump...

Agreed, I have done this a few time..

CEWII

Given the information provided there is no way to tell. There are a lot of factors. The sprocs operate on the same tables, how big are the tables?...

Good book, its companion book "The Microsoft Data Warehouse Toolkit" by Joy Mundy and Warren Thornthwaite also by the Kimball Group covers more specifically the MS tools. The Kimbal...

And even if you do then you can usually find a driver for it.

CEWII