October 25, 2010 at 5:57 am
Grant Fritchey (10/25/2010)
george sibbald (10/24/2010)
I'm interested, why use SSIS for backup plans? That does seem an unnecessary extra layer to me. I presume you mean outside of the maintenance plans.Whats the advantage over Sql agent jobs and/or stored procs or scripts?
On a similar point I am always surprised when I see people writing backup scripts in smo or vb or something, I have to ask myself why.
I personally wouldn't use it for backup plans. But, if you do use maintenance plans in 2008, you're using SSIS whether you want to or not. Might as well know what's going on, how they work, and how you can take better control of them.
yea, good point.
---------------------------------------------------------------------
October 25, 2010 at 6:56 am
GilaMonster (10/24/2010)
Jeff Moden (10/24/2010)
Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. Thanks to other people's posts, it seemed that you had to write some bloody damned script for just about anything complex that you wanted to do.I've been writing some reasonably complex SSIS recently and I've only once used a script, and afterwards it turned out to not even be necessary (was in my error handling)
I've used scripts a couple of times and even wrote a custom component. Of course, I think if I had understood SSIS logging and error-handling better I probably wouldn't have needed to write the custom component. Like most areas of SQL Server, I know enough about SSIS to get pretty much every job done, and afterwards I find out there's a better and probably easier way to do it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 25, 2010 at 8:05 am
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
I didn't expect this comment to generate so many posts.
My rant was intended to be less about SSIS and more about people not taking the time to learn the new technology they start using. What do many do when they reach a hurdle? Don't bother bother picking up a book; don't bother looking it up on the web; just post your questions on SSC. Someone will answer your question(s).
Why bother taking the time to learn anything when someone can answer all your questions for you? That may work for some, but it doesn't work for me and I'm pretty sure it doesn't work for the regulars in this thread.
BTW, good Monday everybody. Hope it a good week for y'all, eh.
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]
October 25, 2010 at 8:24 am
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.
October 25, 2010 at 8:29 am
Steve Jones - SSC Editor (10/25/2010)
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.
I would love a quick solution without work. Unfortunately, I've found the only way to get those is to do a lot of work the first few times.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 25, 2010 at 8:32 am
Stefan Krzywicki (10/25/2010)
Steve Jones - SSC Editor (10/25/2010)
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.I would love a quick solution without work. Unfortunately, I've found the only way to get those is to do a lot of work the first few times.
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.
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]
October 25, 2010 at 8:34 am
Alvin Ramard (10/25/2010)
Stefan Krzywicki (10/25/2010)
Steve Jones - SSC Editor (10/25/2010)
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.I would love a quick solution without work. Unfortunately, I've found the only way to get those is to do a lot of work the first few times.
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.
Seriously?? Who has time to waste on fishing when I can get it much faster somewhere else? Who cares if the fish is on ice?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 25, 2010 at 8:36 am
Alvin Ramard (10/25/2010)
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.
I think it's more like "do it for your kids so they'll stop whining or let them whine and figure out how to do it themselves"
October 25, 2010 at 8:39 am
Steve Jones - SSC Editor (10/25/2010)
Alvin Ramard (10/25/2010)
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.I think it's more like "do it for your kids so they'll stop whining or let them whine and figure out how to do it themselves"
I prefer to help them figure it out so they can do more for temselves 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]
October 25, 2010 at 8:40 am
CirquedeSQLeil (10/25/2010)
Alvin Ramard (10/25/2010)
Stefan Krzywicki (10/25/2010)
Steve Jones - SSC Editor (10/25/2010)
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.I would love a quick solution without work. Unfortunately, I've found the only way to get those is to do a lot of work the first few times.
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.
Seriously?? Who has time to waste on fishing when I can get it much faster somewhere else? Who cares if the fish is on ice?
I prefer to know how to get my own fish so I'm not stuck when the fish market is closed?
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]
October 25, 2010 at 8:44 am
Alvin Ramard (10/25/2010)
CirquedeSQLeil (10/25/2010)
Alvin Ramard (10/25/2010)
Stefan Krzywicki (10/25/2010)
Steve Jones - SSC Editor (10/25/2010)
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.I would love a quick solution without work. Unfortunately, I've found the only way to get those is to do a lot of work the first few times.
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.
Seriously?? Who has time to waste on fishing when I can get it much faster somewhere else? Who cares if the fish is on ice?
I prefer to know how to get my own fish so I'm not stuck when the fish market is closed?
If the market is closed, just steal it from a bear.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 25, 2010 at 9:02 am
I figure I can just fix the hunter's computer and let him get me a cow 🙂
October 25, 2010 at 9:03 am
CirquedeSQLeil (10/25/2010)
If the [fish] market is closed, just steal it from a bear.
I seen that movie. It did not end well.
October 25, 2010 at 9:21 am
CirquedeSQLeil (10/25/2010)
Alvin Ramard (10/25/2010)
CirquedeSQLeil (10/25/2010)
Alvin Ramard (10/25/2010)
Stefan Krzywicki (10/25/2010)
Steve Jones - SSC Editor (10/25/2010)
Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.I would love a quick solution without work. Unfortunately, I've found the only way to get those is to do a lot of work the first few times.
The old saying about give a man a fish ...... teach a man how to fish ..... just came to mind.
Seriously?? Who has time to waste on fishing when I can get it much faster somewhere else? Who cares if the fish is on ice?
I prefer to know how to get my own fish so I'm not stuck when the fish market is closed?
If the market is closed, just steal it from a bear.
You just reminded me of a commercial for smoked salmon, forget who, where the bear is fishing in the stream and a guy jumps out from behind the bushes to get "the freshest salmon possible" and ends up in some sort of cheesy kung-fu fight with the bear, ends up winning and walks off with the fish. Hilarious!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 25, 2010 at 9:22 am
Brandie Tarvin (10/25/2010)
CirquedeSQLeil (10/25/2010)
If the [fish] market is closed, just steal it from a bear.I seen that movie. It did not end well.
grizzlyman?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Viewing 15 posts - 20,776 through 20,790 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply