Hi Phil and Elliot,

Thanks for the help. I'm now getting the Stored Proc to work. Just not getting a file so I'll have to figure out why, but...

Elliott Whitlow (6/30/2011)

---

You would have to have a variable in the package that can use the value and then you can modify the the command that executes the package to...

Hi Phil,

Thanks for the reply.

Here's the procedure that's calling the stored procedure.

ALTER procedure [dbo].[ZipCountOrderID]

@OrderID_In int

as

declare @OrderID int

select @orderid = @orderid_in

EXEC xp_cmdshell 'dtexec /sql zipcodeexport'

In the SSIS package, I have a...

No, when the Thread is quiet, it's time to...

Roy Ernest (6/24/2011)

---

My state name is Kerala. This is the official site of Kerala tourism[/url].

I will try to edit the subscription again and see if that work. 🙂

Thx Kiara...

Brandie Tarvin (6/23/2011)

---

Are any of you people going to be a GenCon, pretending to be geeky gamers?

I'm going to be running some Shadowrun events for Catalyst as well as signing...

I did. It was better than I had hoped, not as bad as I feared. They did a...

Tom.Thomson (6/10/2011)

---

Kit G (6/9/2011)

---

GilaMonster (6/9/2011)

---

Stefan Krzywicki (6/9/2011)

---

I think I'd be more worried about someone with a gladius on a subway car. A claymore is a lot of steel in a...

GilaMonster (6/9/2011)

---

It's more...

Tom.Thomson (6/9/2011)

---

Kit G (6/8/2011)

---

Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a Roman Legionaire...

Blazing Saddles!

Grant Fritchey (6/8/2011)

---

Finished my 3 mile contribution gotta go log it.

I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but I seldom wear long...

Grant Fritchey (6/7/2011)

---

WayneS (6/6/2011)

---

Jim,

If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it... he can fill you...

Daleks! Quick, hide behind the couch!

And I'll toss my own Congratulations into the stack to you, the mother and the rest of your family! Enjoy being a grandfather! 😀