How Do You Code The Package Execution Progress Window In C#

Mar 25, 2008



I need to write a front end to execute our .dtsx package due to it being encrypted and not wanting to expose the password at all.
I have successfully written code to run it but I want to show something like the Package Execution Progess window and I don't know how.
This window shows up when you just double click on the .dtsx file and Execute it using the interface provided.
Can anyone help?

Here's my code so far.


using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using Microsoft.SqlServer.Dts.Runtime;



namespace RunMigration

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{



DTSExecResult pkgResults_Sql;



try

{

Cursor.Current = Cursors.WaitCursor;





Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();

app.PackagePassword = "SomePassword";



Microsoft.SqlServer.Dts.Runtime.Package pkg = new Microsoft.SqlServer.Dts.Runtime.Package();



pkg = app.LoadPackage("T:\amber\encrypt\EncryptedPHDMigration.dtsx", null);

string mypath = this.textBox1.Text.ToString();

pkg.ImportConfigurationFile(mypath);







pkgResults_Sql = pkg.Execute();

MessageBox.Show(pkgResults_Sql.ToString());

MessageBox.Show(pkg.ExecutionStatus.ToString());







foreach (Microsoft.SqlServer.Dts.Runtime.DtsError error in pkg.Errors)

{

Console.WriteLine("{0}", error.Description);

this.richOutput.Text = error.Description;

}

}

catch (System.Exception f)

{

MessageBox.Show(f.Message);

}

finally

{

Cursor.Current = Cursors.Default;

}

}

private void btnConnect_Click(object sender, EventArgs e)

{

OpenFileDialog open = new OpenFileDialog();

open.Filter = ("SSID config files|*.dtsConfig");

if (open.ShowDialog() == DialogResult.OK)

{

this.textBox1.Text = open.FileName.ToString();

}

}



}

}

View 10 Replies


ADVERTISEMENT

Package Execution Progress

Nov 13, 2007



I have a pacakage wich loads data from a .csv file into my database. When I run the package from Visual Studio there is a Progress/Execution Results tab where I see information about the progress. I would like to insert some of these messages into my database. I tried to handle the OnProgress event with an Execute SQL Task and insert the Progress descriptions, but that doesn't seem to give all the information I see on the above mentioned tab (moreover, I get different numbers of events running the package from VS and running it programmatically from c#, why is that?).

What I really would like to get are the messages from the Progress tab which look like these:

[Agreement File [11773]] Information: The processing of file "D:****files*********.csv" has started.


[Agreement File [11773]] Information: The total number of data rows processed for file "D:****files*********.csv" is 201.

[Agreement File [11773]] Information: The processing of file "D:****files*********.csv" has ended.

[DTS.Pipeline] Information: "component "OLE DB Destination" (12598)" wrote 200 rows.

Any help would be appreciated.

View 3 Replies View Related

DOS Window Could Not Close Automatically When The DTS Package Execution Complete.

Jan 21, 2002

We ran a cmd file which includes dtsrun ... The last line of the DOS window came up with "DTSrun: Package execution complete", but the cmd window could not close automatically.

View 2 Replies View Related

SSIS Package Execution From C# Code

Apr 17, 2007



Hi All,



This not a problem but here i wan to give u my some trial on package execution from C# code.

i just want to make sure whether this is right way or not?



I need to upload some processed text file into table using SSIS packages. I m calling these packages in runtime for different source text files passed to it.



I first created package on my machine and deployed packages on Sql server using default protection level. So when i m tryng to execute it from integration services it wont work giving some exception in AquireConnectionCall() , its coz all the sensitive information is stroed inside package is not available to that machine.



In C#

Now i m loading this package using LoadFromSqlServer().
I am creating connection manager object for each of source and destination type and then setting all sensitve information from my solution's config file.
Set the protection level of package and available connection managers to DontSaveSensitve.

by using this method m able to execute any package created on any machine with default protection level.



Can any one of tell me -ve aspects of this approach?



Thanks

View 5 Replies View Related

Simultaneous Execution Of The Same SSIS Package From Code

Jul 26, 2007

Hello

I am trying to call the same package with different starting parameters using asynchronous method calls.

My code is


namespace ReconHost

{






public partial class HostContainer : Form

{



public delegate void InvokePackageHandler(

Microsoft.SqlServer.Dts.Runtime.Application app,
int var
);


Microsoft.SqlServer.Dts.Runtime.Application app;


public HostContainer()

{


InitializeComponent();





for (int i = 0; i < 2; i++)

{


app = new Microsoft.SqlServer.Dts.Runtime.Application();

InvokePackageHandler asyncInvokePackageHandler = InvokePackage;

asyncInvokePackageHandler.BeginInvoke(app, i, null, null);

}


}



public void InvokePackage(Microsoft.SqlServer.Dts.Runtime.Application app, int var)

{


Package pkg = app.LoadPackage(@"c:GRSGRSGRSTest_Async.dtsx", null);

pkg.Variables["intVar"].Value = var;

pkg.Execute();

pkg = null;

}

}





}

If I set the for loop to loop just once, the package is executed fine. Any more than once and only one instance of the package is executed.

Does anyone know what I am doing wrong? I know it is possible to execute the two package instances simultaneously because you can use DTexecUI.exe on two clients to do this.

Thanks in advance
Tomo

View 3 Replies View Related

How To Stop A SSIS Package Execution From Code?

Sep 13, 2006

Hi everyone,

After a Execute method I would need to stop a package but I don't know why:



sResultDts = pkg.Execute(Nothing, Nothing, EventsSSIS, Nothing, Nothing)



I have a Events class (EventSSIS) which implements IDTSEvents and have an OnQueryCancel event but without parameters, such so:

Function OnQueryCancel() As Boolean Implements IDTSEvents.OnQueryCancel

Return False

End Function



Let me know how to pass a boolean parameter because of I can't overloaded OnQueryCancel method

TIA-

View 1 Replies View Related

DTS Package - Provider Generated Code Execution Exception: EXCEPTION_ACCESS_VIOLATI

Feb 23, 2006

When running a step within my DTS package I'm receiving the following error - "Provider generated code execution exception: "EXCEPTION_ACCESS_VIOLATION".

I think it may be something to do with my global variable, but I'm not sure as I'm pretty certain I've set it all up correctly.

Below are screenprints showing my settings.

http://img153.imageshack.us/my.php?image=19tv1.jpg

http://img153.imageshack.us/my.php?image=25wz1.jpg

http://img153.imageshack.us/my.php?image=39pf.jpg

http://img164.imageshack.us/my.php?image=43nx.jpg

http://img164.imageshack.us/my.php?image=51ao.jpg

http://img164.imageshack.us/my.php?image=64lo.jpg

http://img164.imageshack.us/my.php?image=71yn.jpg

Any advice of fixing this would be greatly appreciated.

View 6 Replies View Related

How To Get Execution Progress ?

Sep 5, 2007

Does anyone knows how to retrieve execution progress from ssis package, that was
executed programatically.
What I am trying to do, is to launch ssis package on server
and send the progress ("percent complete") to some remote client in order to display it
in progress bar.
I want that ,while ssis package executes, it will raise some event every time the progress changes.

View 4 Replies View Related

SSIS Package Progress And Testing Using C#.net

Nov 22, 2007



How to perform testing on SSIS packages?
I need to find out how the package progress and the re-entry takes place through c#.net.
Please provide me an appropriate code.

View 1 Replies View Related

Can We Pass Form Object Like Progress Bar To An Ssis Package

Dec 11, 2006

Hi friends,

The problem that i am facing right now is that I have to show progress bar in my vb front end Application code which call my package using the

Application.LoadPackage(pakage Nothing).

What i am intending is that , I pass my progress bar instance to Package object and as the package executes, I

am changing the progress bar value to reflect the progress of execution.



Please Help ME.. with ur valuable responses



Regards

Maheswar

View 1 Replies View Related

Retrieving Native Progress Events For A 2000 Package From SSIS. Is It Possible?

Sep 28, 2006

Dear all,

AFAIK I don't think so. Let me know if possible and how.

I'm talking about a SSIS package which owns a Execute DTS 2000 Package Task and from there it calls a DTS 2000. Programatically, from our VB .Net front-end app we're seeing only SSIS events (when validate and execute methods are called) and any kind of information is provided from RCW proxy (I suppose that internally it gonna be created in order to send messages between managed and unmanaged code).

When a task inside our DTS 2000 fails we're awaring by means a "generic message" such this:

Error: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user. at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

Thanks a lot for your time and comments,

View 1 Replies View Related

How To Launch Package From Client Machine, Display Progress And Finally Results?

Oct 4, 2006

Please help. I'm completely new to SSIS, and I was hoping someone could point me in the right direction(s).

I am developing a winforms client app, and I need to be able to provide the user with the ability to import data in CSV format into our application's database.

I'd like to use SSIS if possible, as long as what I am trying to do isn't near impossible.

I'm thinking of a UI where the user can specify a flat file (CSV) to upload and be processed by an SSIS package on a remote database server.

This package will be responsible for validating the CSV file and inserting data into the database as appropriate.

Is there a way I can:

launch an SSIS package remotely, from a winforms app on the client machine that is not running SQL server (preferably asynchronously) -- and pass it some parameters, including the import file itself
(optionally) provide progress feedback to the client pc to let them know it is being processed
display a nice SSRS report on the client upon completion that tells them exactly what the success/failure of the import was (how many rows processed, which ones failed and why, etc)

Any helpful examples, links, etc would be most appreciated.



Thanks in advance!

View 1 Replies View Related

Execution Of Child Package From Parent Package In Sql Server 2005 Integration Services

May 21, 2007

Hi,

I created a package which passes some infornmations( through parameters) to its child package.

I need to do some processing in parent package based on execution status of child package.i.e.

if child fails then some operation and if child succeeds then other operation.

To determine the status of execution of child package I am using two differnt constraint ..one constraint is having value "Success" and other having value "Failure".

My problem is that when child packge is executed successfully the constraint with value = "Success" works properly but when child fails the constraint with value "Failure" does not work.

-Prashant

View 4 Replies View Related

Package Validation Error : The Package Designer Deletes The Code From Script Task.

Jun 14, 2006

While Creating a script task in Control Flow, I am getting "Package Validation Error". Here is the complete message:

Error at Validate File and Load Data: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
(Microsoft.DataTransformationServices.VsIntegration)

As mentioned in the message, I opened the script IDE and added the code I need. When I close the VSA IDE, package designer displays the same error message.

The worst part of whole story is that if I close the package designer and reopen it, I find that all the code I wrote in the script task has been deleted by the package designer. This is not at all acceptable as I saved the package the and still lost all my work. I did all the coding from scratch for that task.

Please respond if anyone faced similar problem.

Thanks in advance!

Anand

PS: If any one from Microsoft is reading this, please see what you guys are coding there. Due to the buggy software you deliver, I am loosing my credibility.<P< P>

View 5 Replies View Related

Sql Server Script File(.sql) Execution By Vb.net Code

May 20, 2005

I have a problem.
I m working on "light weight sql server"  project.
 
and i want to execute .sql file through vb.net code with the help of sqldmo library and sqlns namespace.
but i donot know any method to directly execute the .sql file.
i am successfully making the full script of select database of sql server.
 
please help me....
thanks....

View 1 Replies View Related

DTS Package Execution

May 15, 2001

I have already created package which loads a text file to database.I wanted to execute that package based on the availability of the file using Visual Basic,Perl or VBSCRIPT whichever is easier.Please advise.Thanks

View 4 Replies View Related

DTS Package Execution - When Is It Done?

Oct 30, 2000

I wrote a stored procedure that calls a DTS package that imports a file into a SQL Server table, then executes some commands on that table. How can I tell that the DTS package has completed, so that I can continue with the next command? Here is my code:

-- Run the DTS package
EXEC @Result = msdb..sp_start_job @job_name = 'MyJob'
WAITFOR DELAY '00:00:02'

-- Call the table that the package created
SELECT * FROM <imported_table> WHERE ...

I had to insert a WAITFOR statement to make this work. Any other suggestions as to how to know when to continue?

Thank you.

View 4 Replies View Related

DTS Package Execution

Mar 18, 2004

Is there a method to either:
A) Kick of a DTS package directly from a stored procedure without shelling out to the DTSRun facility.
B) Kick off a scheduled job containing a DTS task from a stored procedure?

What's the best method?

View 2 Replies View Related

Package Execution ...

Feb 11, 2008

Hi Friends,


I need help from you.
I am working on SSIS packages for ETL purpose.
The version of SQL Server i am using is SQL Server 2005.

In Brief , the working of current ETL is as follows.

In ODS database i have 2 tables i.e Table_A & Table_B which gets loaded from another 2 staging tables A & B.
And using this 2 tables data will be loaded into a target table i.e Trg_A.

The ETL packages are executed by stored procedures by creating a job within the stored procedure.

The loading of the trg table is little tricky.
Before that loading of Table_A is implemented in a single SSIS package.
and loading of Table_B is been implemented in another SSIS package.

In the trg table there are two columns which will be getting updated as and when each table is loaded.
so for the first time if i run the package which is resposible for loading Table_A, it loads values into Table_A and once done it will updates (col1) in the target table.


Once after the complete of the execution of Package1.
Now i will kick off the second ssis package which loads the data into Table_B and updates the trg table's columns (col2).

Now the actual problem what i am facing is:

For loading Table_A and updating the col1 in Trg table i will be receving more than 5 excel file every month on weekly basis.
I cannot even gather all the files and run using a For-Loop counter.
So presently i am loading data excel file per week .

Similarly loading of table_B.

For a week if i am executing both the packages which loads the Table_A and updates the Trg(col1) and Table_B and updates Trg(col2), then i am getting a Deadlock Error and the entire ETL is getting messed up.


Now my requirement is , Eventhough the 2 packages are run in parallel , there could certain milli seconds time difference while start of the execution in Job Monitor.
I need to implement a Queing Mechanism which takes care of running the packages in a sequential manner rather than in parallel. i .e i need to ensure only one SSIS package is running in Job Monitor. Only after successful execution of either one the package, then only the second package should start its execution.

If we can implement such a queing mechanism , then my problem is solvedl.

I need some suggestions on this regard in implementing the Queing mechanism in a programatic approach using SQL Server Job Related MetaData Tables.
or else is there in server parameter or initialization parameters which can be set at Database level which suffice my requirement.

Any suggestions would be greatly appreciated.
Looking for sincere comments on this regards.



Thanks in advance.

View 3 Replies View Related

DTS Package Execution Order

Nov 17, 2004

I have a package that has 12 data pump tasks all executing in parallel.

It is transferring raw data from an AS400 DW to a MSSQLSvr Staging area.

Each pump task on completion assigns values to a set of global variables, then having done this passes these as parameters to a sproc which inserts them into a table.

This seems to work for 4 or 5 of the pump tasks but, the rest of the rows in the table are all the same because the remaining pump tasks are all executing before the sprocs.

Is there a way to make sure that the entire set of job steps completes, before starting another job set of steps while still keeping them running in parallel.

I had wondered if there was a way to use the PumpComplete phase of each pump step to fire off the sproc, but can't see how you execute the step.

Any ideas would be much appreciated.

View 1 Replies View Related

DTS, Finish Execution Of The Package

Nov 25, 2004

I want to finsih the execution of a DTS package from an ActiveX task. If a condition is ok, the package would continue as normal. If not, I want to finish the package without any error. Just without executing the next tasks. Do you have any idea?

Thanks

View 1 Replies View Related

Package Execution With Custom UI

Jun 11, 2007

Hi:

I need a user to pass an input to a package from a VB form, and then want to show progress/errors in the form.

I have been able to use Application. LoadFromSqlServer and I then set pkg.Variables.(MyVariable) to the required value before calling Execute.

Works fine so far.

I dont know how to show progress. The DTSExecResult just returns a Cryptic Success /Failure status message.

Is there a way to log the errors if any to my Windows form? I have seen samples on Console Apps(see below) but I would prefer to show it in my Windows form in a text Box or something, appending each error result to the text.



TIA

Kartik




Code Snippet

Class EventListener
Inherits DefaultEvents

Public Overrides Function OnError(ByVal source As Microsoft.SqlServer.Dts.Runtime.DtsObject, _
ByVal errorCode As Integer, ByVal subComponent As String, ByVal description As String, _
ByVal helpFile As String, ByVal helpContext As Integer, _
ByVal idofInterfaceWithError As String) As Boolean

' Add application€“specific diagnostics here.
Console.WriteLine("Error in {0}/{1} : {2}", source, subComponent, description)
Return False

End Function

End Class





View 1 Replies View Related

Conditional Execution Of A Package.

Feb 28, 2008

I have basic knowledge of SSIS and will appreciate if some can suggest a way (with example if possible), to solve this problem.

I have an SSIS package that requires execution of another package, lets say B. This I am able to do using the 'Execute package' task. Now, what I really want to do is, I wish to check if a perticular table 'A' has rows that satisfy a given condition. In other words, I wish to execute Package 'B' onle if Table 'A' has rows. How can I do this?

Thanks in advance.

View 8 Replies View Related

Stop The Package Execution

Aug 2, 2006

Hello all

I want to cause the package to fail in DataFlow. I wanted use the script component for this purpose.

How I can do it?

Thanks

View 1 Replies View Related

SQL Server Package Execution

Nov 24, 2006



I tried to execute the package,which is importing the data from the Flat file(flat file from map network drive on other computer).But Packages are created and executed on Server.While i executing that package it shows error as "Package could not be found.".

Please help me ASAP.



Thanks in advance





View 2 Replies View Related

Execution Package Task-SOS

Feb 21, 2007

hello to every body.. well i have a problem.. well i created a package the task of which is to update thedimensions and the fact tables from the tables of source.

i created a configuration file with all the parameters that are nedded (connections managers; parameters of packages).this config file will include all the paremeters need for the execution of other packages

In that package i call an other package (execution package task). this package normally will take the parameters of the parent package isn't it??(i put the parameters of this package to the config file of the parent package).

i must also note that for the second package called there is also a package...

i must also note that i have 2 DWHs (a and b) for testing.

the problem is that when i execute the parent package to DWH b , the sacond package called do not take the parameters of the parent package. instaed it looks to its XML configuration file(in a different location of the config file of the parent package) which contains the connection parameters to DWH a and it calls strored procedures from the DWH a (instead of calling at SP from DHW b).

any ideas??

thnx a LOT0

View 3 Replies View Related

Execution Of DTS Package After Scheduling.

Sep 13, 2006

Hi All,

I have a problem in getting the info about the execution of a DTS Package.

I have a SQL-2000 Client installation on my Desktop to connect to SQL-2000 Server Database system to do all of my work. i had a DTS package stored in my SQL Server2000 Local Packages.  Now i have to schedule the DTS Package from my Desktop. And the DTS package is processing some files from a shared network folder. when i used to run the DTS package manually from my desktop my desktop login have access to that shared folder so there is no problem to run the package.

suppose i scheduled the DTS to execute on daily basis at 10:00 AM. Now my doubt is wher the DTS will be executed after scheduling, which starts DTS execution and is it required my Desktop to be up daily at 10:00 AM, and how the network shared folder is going to be accessed by the DTS, means where to specify the authentication to the shared folder.

somebudy plz help me out.

Thanks in advance.

View 2 Replies View Related

SSIS Package Execution

Apr 4, 2008



Hi all,

Which is the best way to execute SSIS packages? I have no problem to use dtexec command but I want it to run every night. Is this going to be done through the SQL Server (SQL Server Agent under Jobs)? Is the type going to be Operating System (CmdExec) or Transact Sql? How exactly is the command written there?

Thanks in advance.

View 6 Replies View Related

Package Execution Stability ?

Jul 13, 2007

I am running into some issue that i have found any good clue on this forum... although have seen a few threads dicussions. I have a master package which invokes a dozen of child packages.

1) If I only open master package inside IDE, I am keeping getting the following error when i run the master packages inside Visual Studio 2005 IDE.



The connection type "FLATFILE" specified for connection manager "XXXXX Flat File Destination Connection Manager" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name



2) If I opened up all child packages inside IDE, the master package run fine most of time.



Any suggestions?

View 26 Replies View Related

Package Execution Failed

May 9, 2008

Hi everyone,

I just deployed my first interface and below is the error message

failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'EUROPExxx123$'.". End Error Error: 2008-05-09 11:01:13.00 Code: 0xC020801C Source: Load New Data Into TransDat... The package execution fa... The step failed.

The interface is just to copy the data from 1 database to another based on a date. I suspect that i could have missed a step during the deployment, can someone tell me if the error is caused me forgetting to configure something during the step up of the job or is it network related

Regards
Ash

View 2 Replies View Related

Variables / Package Execution

Jul 17, 2006



I have 10 or so packages with package scope variables. I would like to create a package that not only runs all the packages but also sets the variables within the packages being executed.

A) Whats the best way to run all the packages from one (package??)?

B) Whats the best way to set the variables in the child packages, without having to change them manually everytime I run it.

Thanks,

Mardo

View 3 Replies View Related

SSIS Package Execution

Dec 21, 2006

Hi all,
I am Hazara. I am trying to call a SSIS package from a web service. But package.execute() method is returning 'failure'. Though I am able to execute the same package from a normal .Net project and it is working fine (using the same code that i have used in web service).

I have also tried to execute it through stored procedure for which firstly I created a .dll in c#(which is perfectly working) and then I registered this .dll in sqlserver-2005 using following command.


CREATE ASSEMBLY asmPackageExecuter FROM 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727PackageExecuter.dll'
WITH PERMISSION_SET = UNSAFE
GO
Now on calling the method of .dll (which is responsible to execute the package) I am getting the DTSExecResult as 'success' but data is not getting transfered from one able to other as was expected from the package.

Please help me. I have searched it everywhere on net but didn't get any solution.
I want to execute package only through web-service or stored-procedure

Thanks
Hazara.

View 3 Replies View Related

Package Execution Takes 100% CPU

Jul 24, 2007

Hi all,



I have a package which updates a table which contains a large amount of rows, when this package is runnning the process consumes 100% CPU and other services are crashing (SSAS, SPS, SSRS).



Is there any parameter which could be set to avoid SSIS to consume 100% of the CPU during the execution of this package ?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved