Yes, you can do this.

Basically, you can have your BAT file assign the paramters to Environment Variables, that your SSIS package can then automatically load into it's own variables when...

RBarryYoung (5/15/2012)

---

...

A theoretical upper limit is easy to set: it's the number of CPU threads plus the number of disk spindles that will be used by your service tasks....

Be forewarned Micheal, that article (and most MS Service Broker performance articles) are focused on...

Wow. This is really, really bad data-design. :-O

Check out this series of articles, here[/url]. The notoriously opinionated author never finished the series, but I think that you'll find the answers to your questions in the first...

SQLKnowItAll (5/14/2012)

---

RBarryYoung (5/14/2012)

---

I always use named instances, because I never know for sure if I may need to add another instance (permanently or temporarily) on the current server.

Since, as already...

opc.three (5/14/2012)

---

RBarryYoung (5/14/2012)

---

Really??? Jeff, I must be dense, because the initial...

Glad I could help!

GilaMonster (5/14/2012)

---

Steve Jones - SSC Editor (5/14/2012)

---

Whaaa? No backups of your laptop? None...

What are the security settings on your Linked Server definition?

What is SSIS Logging showing you?

opc.three (5/14/2012)

---

RBarryYoung (5/14/2012)

---

I cannot say for sure if it would be better for you, or by your criteria, but here[/url] is stored procedure that I wrote several years ago, that...

Isn't the second half of your UNION just a subset of the first half?

I cannot say for sure if it would be better for you, or by your criteria, but here[/url] is stored procedure that I wrote several years ago, that does this...

I always use named instances, because I never know for sure if I may need to add another instance (permanently or temporarily) on the current server.

Since, as already noted, you...