That should work..

CEWII

What kind of a file?

CEWII

You can should be able to use expressions in the connection string parameters for the source and destination connectors. You will want to create variables that you manipulate either...

I would say MS doesn't want you too, so why make it easy..

CEWII

tiffanyjanetblack (9/24/2009)

---

I use procs all the time with OLEDB commands and I

always pass values to all parms. I don't think there's a

way out of it. The...

G2Know (9/22/2009)

---

Hi-

EXEC dbo.Test1 @Key1 = ?, @Key2 = ?

This will work if I use both parameters, In my case I only want to send values for second parameter alone.

On...

Again, I...

WayneS I bring up an earlier post of mine to illustrate testing it..

I had a case where I had a process that used all table variables and to see if...

Lynn Pettis (9/23/2009)

---

Jeff Moden (9/22/2009)

---

As a side bar... this is why I cringe at the idea that 2k8 actually has separate datatypes for date only and time only. Everyone...

Sorry I never use bit, I use tinyint and name the field something ending in Flag, meaning it is an effective boolean, 1 is enabled, all other values are considered...

I think your problem is that by the time it knows there is no records the destination object is already instantiated and the file created. You need to keep...

Great, I thought it would..

CEWII

As far as logical reads of a table variable.. Keep in mind that if they are not too big they will probably reside fully in memory and the reads...

Ah, so your problem was item #2 on my question list. Great. I'm glad to hear it..

CEWII

S.K. (9/23/2009)

---

Thanks everyone for the responses. Nothing is broke, I was merely looking to see if anyone polls their servers any differently. Always looking for new, and potentially...