Viewing 15 posts - 3,046 through 3,060 (of 3,666 total)
Read up on package configuration. It's intended to be use for situations like this.
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]
July 28, 2009 at 8:45 am
You could add a Conditional Split in the data flow to prevent unwanted records from reaching the database.
You can also add a Row Count before your database in order 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]
July 27, 2009 at 10:28 am
I see we're quickly approaching the 7000 posts count.
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]
July 27, 2009 at 10:16 am
Congratulations Roy. I had the pleasure of being the co-founder of our local chapter just a few months ago.
As far as speakers are concerned, I have to agree with...
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]
July 27, 2009 at 8:32 am
...and of course....
LMGTFY
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]
July 25, 2009 at 2:32 pm
SQLROCKS
SPWHO2
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]
July 25, 2009 at 10:32 am
dh (7/24/2009)
Thanks Alvin. But shouldn't the 'Local System' account have enough privileges to run the job?
You might expect that it should, but don't assume that it will.
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]
July 24, 2009 at 9:50 am
Was your package being run as a job? If so I suspect that the SQL Server Agent account lacks the sufficient rights. Try fixing now instead of later.
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]
July 24, 2009 at 7:22 am
Jack Corbett (7/23/2009)
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]
July 23, 2009 at 12:28 pm
M Jones (7/23/2009)
Thanks for the input. Mind to tell me how to do this stuff though? We would like to be able 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]
July 23, 2009 at 10:38 am
There's is no easy way to do what you're trying to do, at least not the way you want to do it.
You may want to try another possibility. Create...
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]
July 23, 2009 at 9:27 am
Yes, the Conditional Split is what should be using.
Try ISNULL(ProductID) == FALSE to select the rows you want.
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]
July 23, 2009 at 8:33 am
Use the Conditional Split in the data flow to filter out the records. Direct the ones you want to your table. Ignore the others.
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]
July 23, 2009 at 8:23 am
If you need to monitor the progress of a running package then I recommend that you turn on the package logging and enable at least all the error and warning...
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]
July 23, 2009 at 8:06 am
Be careful about trying to develop a package that can handle too many files changes. Such a package might be able to run "successfully" even if the order of...
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]
July 23, 2009 at 7:55 am
Viewing 15 posts - 3,046 through 3,060 (of 3,666 total)