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


ADVERTISEMENT

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

How To Pass Pass The Parameter In SQL Command In SSIS Package

Jul 31, 2006

Hi

   We already used Oracle Datasatage Server the following Query statement for Source and Lookup.here there is parameter maping in the SQl Statement . How can achive in SSIS the Folowing Querystatment?

 

Query 1: (source View Query)
SELECT
V_RDP_GOLD_PRICE.GDR_PRODUCT_ID, V_RDP_GOLD_PRICE.ASSET_TYPE, V_RDP_GOLD_PRICE.PREFERENCE_SEQ, V_RDP_GOLD_PRICE.RDP_PRICE_SOURCE, TO_CHAR(V_RDP_GOLD_PRICE.PRICE_DATE_TIME,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(V_RDP_GOLD_PRICE.REPORT_DATE,'YYYY-MM-DD HH24:MI:SS'), V_RDP_GOLD_PRICE.SOURCE_SYSTEM_ID
FROM
V_RDP_GOLD_PRICE V_RDP_GOLD_PRICE
WHERE
REPORT_DATE = (select max(report_date) from V_RDP_GOLD_PRICE where source_system_id = 'RM' )



 

Query 2: (look up )

 


SELECT
GDR_PRODUCT_ID,
TO_CHAR(MAX(PRICE_DATE_TIME),'YYYY-MM-DD HH24:MI:SS') ,
TO_CHAR(REPORT_DATE,'YYYY-MM-DD HH24:MI:SS')
FROM
V_RDP_GOLD_PRICE
where
GDR_PRODUCT_ID = :1 and
report_date = TO_DATE(:2,'YYYY-MM-DD HH24:MI:SS')  AND
PRICE_DATE_TIME BETWEEN TO_DATE(:2,'YYYY-MM-DD HH24:MI:SS') - 7) AND TO_DATE(:2,'YYYY-MM-DD HH24:MI:SS')
GROUP BY GDR_PRODUCT_ID, TO_CHAR(REPORT_DATE,'YYYY-MM-DD HH24:MI:SS')



 

please anyone give the sample control flow  and how to pass the parameter?

 

Thanks & regards

Jeyakumar.M

 

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

Pass Dynamic Value To SSIS Package

Jun 6, 2013

I have an SSIS package that has a variable called @RUN_DATE.I would like to create a sql agent job and uses the set values tab to pass a dynamic parameter to the ssis package. for example, i would like to always set the variable to the last day of the previous month. I know that If i hardcode the date as 5-31-2013 it works fine, but i have not been able to figure out how to make the value dynamic by using an expression or if this is even possible.

View 4 Replies View Related

Pass Parameters Into SSIS Package From A Web Application

Nov 13, 2007

Hi all,
 I wish to pass parameter from a dropdownlist in my web application to the SSIS package so as to export the user specified table.
Is using package configuration the right way to do this?
Any advice is appreciated!
 

View 8 Replies View Related

Pass Dynamic Date Value To SSIS Package

Jun 14, 2007

Hi,

I have a parent package which accepts date as input. I can configure Set Values of Execute Package Utility with hard coded date value and it works fine. My question is how do I configure Set Values to accept dynamic date value or current date value (may be using GetDate()) ?



Thanks in advance.

Prabha

View 6 Replies View Related

How To Pass Values From ASP DOT NET To SSIS Package Variables

Jun 1, 2006

Hi

Does anybody know how to pass values from asp dot net to SSIS package variables ?

Currently I have an SSIS package for monitoring windows service... for that...

I have to pass the Server-IP Addrress, UserName, Password, Service Name as Parameter.

I would like to pass these parameters through an Interface from RUN TIME.

Please help this problem

Regards

Deepu M.I



 

 

 


 

 

View 1 Replies View Related

Pass-thru Query Doesn't Work With A SQL 2005 SSIS Package

Dec 14, 2007

I am trying to execute an SSIS package from an MS Access 2003 database that imports a table from the Access database into a target table in SQL 2005. I saved the package in SQL 2005 and tested it out. If I run it from the Management Studio Console with Run->Execute ... everything works just fine. However, if I try to run it using the following line command "Exec master.dbo.xp_cmdshell 'DTExec /SER DATAFORCE /DTS SQL2005TestPackage /CHECKPOINTING OFF /REPORTING V'" the execution will always fail when the Access database is open (shared mode). The connection manager looks like this: "Data Source=E:Test.mdb;Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Jet OLEDB:Global Bulk Transactions=1". The error is listed below:

Code: 0xC0202009
Source: NewPackage Connection manager "SourceConnectionOLEDB"
Description: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not use ''; file already in use.".


What am I doing wrong?

View 4 Replies View Related

How Do I Pass A Parameter From A SSRS Report To The Sql Stmt In A SSIS Package

Aug 24, 2007

How do I pass a parameter from a SSRS report to the sql stmt in a SSIS package?
Mainly need to know the correct syntax of the connection string to use for the datasource in the SSRS report. Every time I add the /SET part of the string the connection breaks.
The connection string i've been using is:
/file "C:\PackageName.dtsx /Set Package.Variables[StartDate];"&Parameters!StartDate.Value

View 26 Replies View Related

Call SSIS Package From Stored Procedure And Pass Parameter

Mar 27, 2008

I am new to the SSIS.

For DTS package of sql server 2000, I can call a DTS package from stored procedure. The command is:

dtsrun /E /SMyServer /NMyDTS /Wtrue /A Parameter1:3= 'Test'

Does anyone know, how do I do the similar thing from SSIS environment.

1) How to call a SSIS package from Stored Procedure?
2) How do I pass parameter to the SSIS package?

Thanks everyone.

View 6 Replies View Related

Pass A Parameter From A SSRS Report To The Sql Stmt In A SSIS Package

Aug 24, 2007

How do I pass a parameter from a SSRS report to the sql stmt in a SSIS package?
Mainly need to know the correct syntax of the connection string to use for the datasource in the SSRS report. Every time I add the /SET part of the string the connection breaks.
The connection string i've been using is:
/file "C:\PackageName.dtsx /Set Package.Variables[StartDate];"&Parameters!StartDate.Value

View 3 Replies View Related

Assigning User Name And Password Form The Databse To Ssis Package For Data Flow Operations And Execute Sql Statement

May 8, 2008

hi in my package, some sql operations need the special user name and admin privilage. so how do i create my ssis package so that when it executes it takes the given username and password from the table in some database.

View 8 Replies View Related

Controlling SSIS Package From A Website And Including A COM Object In The Processing

May 22, 2008



Hello everyone,

This is a new level of complexity for me..

The Boss wants..

1. To control an SSIS package , start, check status, and emergency stop + rollback a package from a web page. Does anyone know of an example or good articles to start with.

2. I have one of the iterations of the data invoke and use a COM object (third party) It will value the items and change a field.

I can always do #2 as a second step but I need all the help I can get on #1.

Thank you,

View 1 Replies View Related

Create SSIS Package To Script Out DB Objects (1 File Per Object)

Nov 29, 2007

We are in the process of trying to automate our production releases (what a concept ;-)

The database is SQL server 2005
All objects are being stored in VSS
Using Nant and Cruise Control for the actual migrations.
I have two directories - Create (for a brandnew database) and Change (db object changes)

In my 'Change' script, I do the following -

1 - Take backup of database
2 - Migrate objects from 'change' directory to production
3 - Script out all objects of database and save in the 'Create' directory

For the #3, I was hoping I could create an SSIS package that would
script out all database objects and save them on the VSS server.

I'm new to SSIS and want to verify it's something that can be done before I start down that path.
If anyone has any examples or references, it would be much appreciated.

Thanks

View 4 Replies View Related

Integration Services :: Pass Multiple Parameter Values To SSIS Package In 2012 Through Stored Procedure?

Jul 9, 2015

we can  assign one parameter value for each excecution of  [SSISDB].[catalog].[set_object_parameter_value] by calling this catalog procedure..

Example: If I have 5 parameters in SSIS package ,to assign a value to those 5 parameters at run time should I call this [SSISDB].[catalog].[set_object_parameter_value] procedure 5 times ? or is there a way we can pass all the 5 parameters at 1 time .

1. Wondering if there is a way to pass multiple parameters in a single execution (for instance to pass XML string values ??)
2.What are the options to pass multiple parameter values to ssis package through stored procedure.?

View 4 Replies View Related

How To Pass Null Value To The Database If A Form Field Is Empty?

May 31, 2004

How can I pass into the database (@User_fax = null) if the fax form field is empty, from a command type Stored Procedure? For example:

Dim CmdUpdate As New SqlCommand("Form2_NewUser", strConnection)
CmdUpdate.CommandType = CommandType.StoredProcedure

CmdUpdate.Parameters.Add("@User_fax", SqlDbType.char, 9)
CmdUpdate.Parameters("@User_fax").Value = fax.Text()

...

strConnection.open()
CmdUpdate.ExecuteNonQuery
strConnection.close()



And, the stored procedure inside Sql server:

USE market1
GO
ALTER PROC Form2_NewUser
@User_id bigint, @User_fax char(9),...

AS

SET NOCOUNT ON
UPDATE Users
SET User_fax = @User_fax, ...

WHERE User_id = @User_id
SET NOCOUNT OFF
GO



Thank you,
Cesar

View 4 Replies View Related

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

Problem Getting DTS Object To Work On A Web Form

Feb 26, 2007

Hi;
 I would like to run a DTS package from the On click button event on a web form.
I tried using code that works in a windows form.
But ASP.net, VS 2005 doesn't like the code.
Here are the libraries that I used with the windows form.
 Imports System, Imports System.Data. Imports System.Data.SqlClient.
Is there a library that I am missing ?
And here are the lines of code that won't compile:
 Dim oPackage As New DTS.Package2Class
Dim oStep As DTS.Step
Package.LoadFromSQLServer("123WXYZTRSQL", , , DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , , "cpyPrinters2Excel", )
I am able to run the above in a windows form with no problem.
Thanks for any insights,
Gordon 
 
 

View 2 Replies View Related

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 View Related

Inserting Data In SQL 2005 Using Javascript From A Form Object

Mar 4, 2008

I am new to ASP.NET. At present i am developing a web application in which i need to insert data in database(MS SQL 2005) from a form which uses only HTML controls. I need to use HTML controls so posting of form to the server is not done and hence i need to generate HTML controls using javascript. So the data in the form must be stored in the database. How this data can be inserted in the database is the problem and i think that javascript might be the solution for it.
 
Sagar 

View 3 Replies View Related

SSIS Error Or Progress Log

Feb 21, 2008



I have just finished building an SSIS package which does a couple of things including using variables, calling child packages as well as starting off replication.

I plan to kick-off the package via SQL Server Agent.


Is there any way I can monitor the progress of this report by creating a web front-end that refreshes every few minutes to report on errors and progress?


Any ideas are welcome.

Thanks

View 2 Replies View Related

Progress Indication From Ssis App In VB

Nov 11, 2006

Hi

am calling an ssis app from my vb programme. It takes about 5 minutes to run. What is the best way to provide progress feedback to my vb user.



Cheers



Ants

I

View 7 Replies View Related

Binding A DataSource Table Column To A Form Object (RadioButtons)

Oct 25, 2006

Hi,

  I have a little question.  I have an application which interfaces with a SQL Express Database.   On a form, I want to bind a control which is made of several Radio buttons to a table column which is in fact a varchar(1).  This is the picture:

        Table column:  OptVisualRpt  varchar(1)

        Screen control:  2 radio buttons

                                    rb_VisRPTbImp_O    for "yes"

                                    rb_VisRPTbImp_N    for "no"

 

  I'm really scratching my head as how I can bind a single table column to my radio buttons controls.   I think that I just can't this way but rather have to use an intermediate variable or control. 

Solution 1?

 I thought of using a local variable that I would set to "y" or "n" following "CheckedChanged" events fired from radio buttons but I don't know how to bind this variable to my table column.                 

Solution 2?

  I thought of placing a hidden text control into my form, which one would be binded to my table column, that I would also set to "y" or "n" following "CheckedChanged" events fired from radio buttons.

Any of these solutions which would be feasible or any more neat way to do it?

Many thanks in advance,

Stéphane

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

How To Pass Parent Package Parameters To A Package Executed By SQL Server Job Agent

Jan 11, 2007

Hi,

I'd like to know if there's a way to pass parent package parameters to a package executed by SQL Server Job Agent? It appears that sp_start_job doesn't have any variable that could accomodate this.

Hope to hear your ideas.

View 7 Replies View Related

Can I Pass A SqlParameterCollection Object Into A SQL Command

Dec 6, 2004

I currently have a connection class that handles all of my database connectivity. What I am trying to do is build a SqlParameterCollection object on one page, then pass that object to my connection class. Is it possible to do this? I am not getting any compilation errors, but I can not get the parameters to be recognized. Here is what I am trying to do:

Page 1:

string sql = null;
conn.strConn = connectionstring;

sql = "sqlstring";

SqlParameterCollection newcollect = null;
newcollect.Add("@Switch",1);

conn.OpenReader(sql, newcollect);
while (conn.DR.Read())
{
read data onto page here...
}
conn.CloseReader();

Page 2 (connection class) :

public void OpenReader(string sql, SqlParameterCollection collect)
{
Conn = new SqlConnection(strConn);
Conn.Open();
Command = new SqlCommand(sql,Conn);

Command.Parameters.Add(collect); <------This is the root of my question
Command.CommandTimeout = 300;
// executes sql and fills data reader with data
DR = Command.ExecuteReader();
}

Can you do this??? And if so, can anyone tell me why the statement will not return any data? The procedure works perfectly, and will work if I use the standard way of passing the parameters to the command statement.

View 4 Replies View Related

Where To Order The Table Values Displayed In A Web Form Object? In Sql Server Or In The Application?

Sep 10, 2004

Hi,

I have a table in my database with several car types, and the order I want for that table is:

Car_typeA_1
Car_typeA_2
Car_typeA_3
Car_typeA_4
Other_Cars_typeA
Car_typeB_1
Car_typeB_2
Car_typeB_3
Other_Cars_typeB
Car_typeC_1
Car_typeC_2
Car_typeC_3
Car_typeC_4
Car_typeC_5
Other_Cars_typeC
...


This table is more or less always the same, but from time to time I want to add a new car type, for instance; Car_typeA_5, but this new type must be located under the last register, in the example under ‘Other_Cars_typeC’. So, now the order is wrong, and when I want to display these car types to a web form object, the items will appear wrong ordered.

My question is: To order the values(items) correctly, Where I have to do it? In the web page (ASP.NET) code behind, or somewhere in SQL Server (for example in the Stored Procedure that passes the value to the application)? Or maybe in the same database table..?

Thank you,
Cesar

View 7 Replies View Related

Problem: SSIS, ODBC And Progress Database

Dec 15, 2005

Hi,

The project Im working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.

But when I tried to create a DataRearder Source pointing to my ODBC Data Source,  and open the next tab I received this error message:


Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager?


Anyone can help ?

View 23 Replies View Related

To Pass A Dataset To .net Script Task As N Object

Mar 21, 2007

I want to pass a dataset to my .net script task as an object. I know how to declare an Obect variable and map the result set of my Execute SQL task to the Object variable lets say tbl1. Then on the Advanced Menu of .Net Script task I input tbl1 as my ReadOnlyVariable. But once in the design view of the .Net Script I am unable to get and work with every row of the my tbl1 variable.

View 5 Replies View Related

How To Pass Parameters To A Package Using A Execute Package Task

Jan 19, 2008

Hi,

I am calling one SSIS package from another using the Execute Package Task.
I also need to pass a parameter to the called SSIS package.
Can I do this? If yes, how? If no, then what will be the work-around for this?

Thanks in advance.

View 16 Replies View Related

SSIS Design : Object Reference Not Set To An Instance Of An Object

Jun 22, 2006

In visual studio 2005, I create a new Integration Services Project. It tries to create the first package by default "Package.dtsx". The "Package.dtsx[Design]" tab displays

Microsoft Visual Studio is unable to load this document

Object reference not set to an instance of an object

I try to create new SSIS package or edit an existing one (from tutorial), I get the same error in the SSIS graphical user interface tab.

Thanks for your help.

View 3 Replies View Related

Integration Services :: Connect SSIS 2005 To Progress Database?

Sep 18, 2015

how can I connect SSIS 2005 to Progress database?

View 4 Replies View Related







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