Viewing 15 posts - 3,616 through 3,630 (of 3,666 total)
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2008 at 12:05 pm
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
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2008 at 11:52 am
Steve Jones - Editor (8/22/2008)
We do make mistakes on questions, and I'm...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 22, 2008 at 8:58 am
Steve, I erased my response because it did not correctly reflect what I meant.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 22, 2008 at 7:15 am
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 4:16 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 4:06 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 3:54 pm
You're welcome.
I hope they can help you resolve this one.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 3:25 pm
Try putting double quotes around C:\Program Files\WinZip\WINZIP32.EXE
Looks like the space between Program and Files is a problem.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 9:07 am
callain (8/20/2008)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 7:16 am
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 21, 2008 at 7:14 am
Are the missing stats on an unindexed column?
You could manually create the statistics in your stored procedure. I've done that many times.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 5:39 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 5:35 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 4:11 pm
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...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 20, 2008 at 4:01 pm
Viewing 15 posts - 3,616 through 3,630 (of 3,666 total)