Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Microsoft.SqlServer.Dts.Runtime.SqlPackageEventListener sqlListener = new SqlPackageEventListener();
- Microsoft.SqlServer.Dts.Runtime.Application sqlPackageLoader = new Application();
- Microsoft.SqlServer.Dts.Runtime.Package sqlPackage = sqlPackageLoader.LoadPackage(@"pathMigrateData.dtsx", sqlListener);
- sqlPackage.Execute(null, null, sqlListener, null, null);
- public class SqlPackageEventListener : DefaultEvents
- {
- public SqlPackageChangedHandler OnPackageError;
- public override bool OnError(DtsObject source, int errorCode, string subComponent, string description, string helpFile, int helpContext, string idofInterfaceWithError) {
- OnPackageError(this, new PackageErrorEventArgs(source, subComponent, description));
- return base.OnError(source, errorCode, subComponent, description, helpFile, helpContext, idofInterfaceWithError);
- }
- public delegate void SqlPackageChangedHandler(
- object sqlPackage,
- EventArgs packageInfo
- );
- }
- public class PackageErrorEventArgs : EventArgs
- {
- private DtsObject source;
- public DtsObject Source {
- get { return source; }
- set { source = value; }
- }
- private string subcomponent;
- public string Subcomponent {
- get { return subcomponent; }
- set { subcomponent = value; }
- }
- private string description;
- public string Description {
- get { return description; }
- set { description = value; }
- }
- public PackageErrorEventArgs(DtsObject source, string subcomponent, string description) {
- this.description = description;
- this.source = source;
- this.subcomponent = subcomponent;
- }
- }
- public class Test
- {
- SqlPackageEventListener sqlListener = new SqlPackageEventListener();
- sqlListener.OnPackageError += new SqlPackageEventListener.SqlPackageChangedHandler(sqlListener_OnPackageError);
- Microsoft.SqlServer.Dts.Runtime.Application sqlPackageLoader = new Microsoft.SqlServer.Dts.Runtime.Application();
- Microsoft.SqlServer.Dts.Runtime.Package sqlPackage = Microsoft.SqlServer.Dts.Runtime.sqlPackageLoader.LoadPackage(@"path_tofile.dtsx", sqlListener);
- sqlPackage.Execute(null, null, sqlListener, null, null)
- public void sqlListener_OnPackageError(object sender, EventArgs args) {
- //code to handle the event
- }
- }
Add Comment
Please, Sign In to add comment