I would probably use a SSIS package and use a script task to read information from your table to configure the connection for reading the data.

You can loop...

It's kinda hard to answer your question without knowing what is the D drive.

Is it a local drive? Mapped drive? SAN drive? etc

Steve Jones - Editor (8/22/2008)

---

No worries, though we prefer you respond or mark an edit so the rest of the thread makes sense.

We do make mistakes on questions, and I'm...

Steve, I erased my response because it did not correctly reflect what I meant.

As far as I know, the answer is No. If you don't want a table-valued function then you're left with only the scalar function and it only allows a...

It sounds as if your app still needs to interact with the package but you killed it in your procedure.

You could try to run the app in debug mode to...

You might want to consider getting the SQL 2008 Developer Edition instead. It's the same price and is compatible with SQL 2005.

Just a thought. (Time for me...

You're welcome.

I hope they can help you resolve this one.

Try putting double quotes around C:\Program Files\WinZip\WINZIP32.EXE

Looks like the space between Program and Files is a problem.

callain (8/20/2008)

---

Thank you very much for your response...unfortunately this states that it's successful, but nothing happens...it's probably something that I'm doing wrong...where should this be located? I put it in...

I would try running the SQL code in query analyzer just to see if that makes a difference. If that works try it in a SQL task in your...

Are the missing stats on an unindexed column?

You could manually create the statistics in your stored procedure. I've done that many times.

Here's something I wrote a while back. This syntax gets used over 300 times per week so I guess it's well tested.

declare @Command as varchar(5000)

set @Command = 'C:\progra~1\winzip\winzip32 -min...

The ODS can also prevent problem related to the data changing while you build your dimensions and fact(s) since the ODS should be static at that time.

ODS also provides a...

I think your problem was passing the parameters.

Google "running winzip from command line" and look at the command line parameters and you should see the correct syntax for running winzip.

From...