Learn more about programming SSIS packages in C# .net and VB .net from the below link:

http://www.sqllion.com/2009/05/ssis-programming-basic/

Thanks,

Dear Developer,

It seems you are trying to run individual tasks in control flow instead of whole package. In that case, ssis will not execute the Event handler section. Try running...

Obviously, there is a reason for using PackageLogID as a user defined variable for tracking the execution of the package. Below is the list:

•It’s datatype is Int, so easy for...

Yah it’s possible, I will try to find out some direct ways to do it. But for the time being, you can use one custom task to keep track of...

The column named “[PrcocedureName]” can be used to detect the procedure that causes the particular error. But I didn’t implement it in the methodology; the user can implement it in...

Hi… I checked the Expression thoroughly and it is working perfectly.

Please check the user variable, may be u didn’t created the user variable named @[User::PackageLogID].

If u have created the above...

It gives u more customization on logging mechanism. Here I mentioned a simple example, u can use ur own ideas for a more complex logging.

Thanks for ur comments

Thank u all for ur support.

I ll keep in mind ur suggestions in my next article.

My next article will be on "Faster extraction and loading in SSIS package"

Encourage me for...

Hi,

first of all thanks a lot for your comments.

I wrote this procedure as a template. You can modify it as per your need.

It suits my requirement. Hope after little modification,...