Master SSIS holding all SendMail info
-
Example
If I have 10 SSIS packages and they all use SendMail (SMTP) and one day the SMTP server changes.... I have to go into each SSIS package and change the SMTP information.
What I want
One "Master" SSIS which holds a SendMail details so I only have to change the SMTP details in one location
Or is there another way around this?
-
A Little Help Please (3/20/2009)
ExampleIf I have 10 SSIS packages and they all use SendMail (SMTP) and one day the SMTP server changes.... I have to go into each SSIS package and change the SMTP information.
What I want
One "Master" SSIS which holds a SendMail details so I only have to change the SMTP details in one location
Or is there another way around this?
You can insert your send mail setup information in SQL table and then make all your packages use this SQL table for configuration. In this way you can maintain everything in one place.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Fantastic!
Can you give me some pointers in how to set this up?
-
A Little Help Please (3/24/2009)
Fantastic!Can you give me some pointers in how to set this up?
You've got the pointers already. Now its time to grab the shovel 😉
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
Funny man!
-
Hey,
I expect apology. Do you think I was not going to check what you say?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
lol your an even bigger **** if you think your getting an apology.
And for your information, I was hoping you would read my reply.
-
I will recommend the administrators kick you out of the forum for abusing and offending people.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
ok, thanks
-
I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you like, please ask, or ignore posts. Personal attacks are not tolerated.
CrazyRoc,
I would agree that you haven't provided much detail on how to implement your advice. It's a legitimate question to ask how the data in a SQL table would make it into the SendMail task.
-
Steve Jones - Editor (3/24/2009)
I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you like, please ask, or ignore posts. Personal attacks are not tolerated.CrazyRoc,
I would agree that you haven't provided much detail on how to implement your advice. It's a legitimate question to ask how the data in a SQL table would make it into the SendMail task.
Steve,
I have provided enough information for the user to get started. He asked for pointers and this is exactly what I did. I'm not willing to provide complete solutions when the user doesn't make the least effort to understand and research the information I have posted.
Anyway I don't think I deserved to be offended, especially if you consider the fact I'm doing this on my own good faith.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
CozyRoc (3/24/2009)
Steve Jones - Editor (3/24/2009)
I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you like, please ask, or ignore posts. Personal attacks are not tolerated.CrazyRoc,
I would agree that you haven't provided much detail on how to implement your advice. It's a legitimate question to ask how the data in a SQL table would make it into the SendMail task.
Steve,
I have provided enough information for the user to get started. He asked for pointers and this is exactly what I did. I'm not willing to provide complete solutions when the user doesn't make the least effort to understand and research the information I have posted.
Anyway I don't think I deserved to be offended, especially if you consider the fact I'm doing this on my own good faith.
Your right, nobody deserves to be offended, but there is no "right" to "not be offended". It is all in how you choose to respond to the offense.
With regard to the OP, howver, did you even consider that he (or she) may not even have a clue on how to go about implementing your suggestion? You didn't even offer suggestions on where he (she) could go for more information.
-
Lynn Pettis (3/24/2009)
CozyRoc (3/24/2009)
Steve Jones - Editor (3/24/2009)
I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you like, please ask, or ignore posts. Personal attacks are not tolerated.CrazyRoc,
I would agree that you haven't provided much detail on how to implement your advice. It's a legitimate question to ask how the data in a SQL table would make it into the SendMail task.
Steve,
I have provided enough information for the user to get started. He asked for pointers and this is exactly what I did. I'm not willing to provide complete solutions when the user doesn't make the least effort to understand and research the information I have posted.
Anyway I don't think I deserved to be offended, especially if you consider the fact I'm doing this on my own good faith.
Your right, nobody deserves to be offended, but there is no "right" to "not be offended". It is all in how you choose to respond to the offense.
With regard to the OP, howver, did you even consider that he (or she) may not even have a clue on how to go about implementing your suggestion? You didn't even offer suggestions on where he (she) could go for more information.
Lynn,
I think you don't understand the situation. This "creature" called me a "twat" after I suggested he has to do a bit of research on his own. I gave enough information in my opinion to get him started and in return he calls you shit. How would you personally feel about it?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
First, I have been insulted on this forum as well, so I do understand. You have no control over what someone else says or does. You do, however, have control over how you respond. It is called being responsible (or to use Covey, response able). You need to choose how you will respond to a situation.
I have read the posts in this thread, and if I had no idea how to use a SQL Server table to handle configuration options within SSIS, I'd have no idea where to start either from your comments. We are here to help, and if you had at least provided some information, like "look in BOL (Books Online) under xxxxxx, you'll find more information there", I'd agree with you. Unfortunately, you didn't provide much in the way guidance at all.
-
Lynn Pettis (3/24/2009)
First, I have been insulted on this forum as well, so I do understand. You have no control over what someone else says or does. You do, however, have control over how you respond. It is called being responsible (or to use Covey, response able). You need to choose how you will respond to a situation.I have read the posts in this thread, and if I had no idea how to use a SQL Server table to handle configuration options within SSIS, I'd have no idea where to start either from your comments. We are here to help, and if you had at least provided some information, like "look in BOL (Books Online) under xxxxxx, you'll find more information there", I'd agree with you. Unfortunately, you didn't provide much in the way guidance at all.
After someone calls me shit, I'm not willing and "response able" to assist . I'm not paid for doing this and therefore it is up to me to decide what is appropriate. I have asked for him/her to retract his words, but he not only didn't do it. He was happily standing behind it. At that point it doesn't matter if my response was sufficient . The fact is that I'm the one helping and to get SHIT for this is not acceptable and fair.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply