June 30, 2011 at 8:25 am
Hi All,
A potential employer wants me to do a project in SSIS which I have never used before - until yesterday. This was the task I was given:
"Create an SSIS package that imports the three data files in E:\ETL\Source Data into the DataMart database on the local database server. Your package should have logging capabilities, as well as an error handling and notification mechanism. Also, please comment on the structure of the data in the resulting tables."
So far I have imported each data file, set up some control flows and data flows and logging capabilities. The issues I'm having thus far is: I don't know how to set up a notification mechanism. I tried to use a task notify and email task, but that didn't work at all. With the former it gave me an erros saying something like I have to make the DB a mail host, but when I tried to do that I didn't have the access or rights to do so. And when I tried to latter I didn't know what smpt info to put in. Is there another way of doing this?
Also, I have no idea how to enable error handling. I've read some articles on the matter (by search thru google) but I don't understand anything anyone is saying. Is there someone that can explain what I can do?
Anyone's help would be so appreciated as I really need to get this done, so I can have a job! Thank you so much!
P.S. I have attached a few screen shots of what I have so far. Thank you.
July 4, 2011 at 7:53 am
you have to declare a variable of type string let it have the value of the smtp server(IP address), use it in the mail notification task, its easy to configure...
As for the error handling you should create an errorlog table let it contain the following fields autonumber primarykey, package name, data flow name, data transformation task name, error message, error alternate key (for the codes) and an error date. There are system variables found in SSIS which you can use for columns 2,3,4 and 6.
You can also add event or errorhandlers so that when a package fails you'd get a notification on where and the reason the error occurred. use a script component and Mail task.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply