Phil, which do you prefer, hourly rate, or contract price?

🙂

Phil Parkin (9/21/2010)

---

I would use a variable that is assigned from the result of an EXECUTE SQL task along the lines of:

select count(*) from ImportTable

and then use precedence constraints (=...

Does your configuration include the connections, or just variables?

I would use a variable that I update using a Script Task.

I've done that successfully by using PsExec.

http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx

Edit: removed typo

Chris Morris-439714 (9/21/2010)

---

CirquedeSQLeil (9/21/2010)

---

My powers of divination...

dtexec has a parameter for specifying the config file to use. Shouldn't that solve your problem?

From http://msdn.microsoft.com/en-us/library/ms162810.aspx

/Conf[igFile]filespec

(Optional). Specifies a configuration file to extract values from. Using this option, you...

Is it ok if I have coffee instead of tea? 😎

jcrawf02 (9/21/2010)

---

Alvin Ramard (9/21/2010)

---

Isn't...

Isn't there a system...

GilaMonster (9/21/2010)

---

Alvin Ramard (9/21/2010)

---

Kit G (9/21/2010)

---

Admittedly, with date formats, text files have a bit of the same problem, you have to figure out what format the date has been put...

Kit G (9/21/2010)

---

Alvin Ramard (9/21/2010)

---

Greg Edwards-268690 (9/21/2010)

---

Excel can do anyhing, even word processing! 😛

It's kind of like I can record a macro, so...

Greg Edwards-268690 (9/21/2010)

---

Excel can do anyhing, even word processing! 😛

It's kind of like I can record a macro, so I can repeat anything.

Greg...

da-zero (9/20/2010)

---

In our environment they are against using stored procedures, for the simple reason that if you deploy your SSIS packages, you could forget to deploy your stored procedures. And...

Jeff Moden (9/19/2010)

---

Craig Farrell (9/19/2010)

---

My preference has, and almost always will be, SPROC if there's logic involved if I can get away with it. Primarily so that I only...