Runtime Interface Messages?

Oct 5, 2007

Is there a way to provide updates to the user interface during execution of a package? I realize it's not the purpose of SSIS, but would find it helpful... especially in terms of looping through recordsets, etc. what value a certain variable is set to.

View 1 Replies


ADVERTISEMENT

How To Show SQL Server Data Validation Error Messages In The VB 2005 Designed Interface ???

Apr 27, 2008

I'm developing a database-driven program using SQL server 2000 and Visual Basic 2005.

Most of the guys say professional programming is doing the validation stuff (such as the constraints and data integrity stuff like" [0-9][1] " and the use of LIKE IN keywords etc.) in the databse itself.

say i did the data validation contraints in SQL server itself. and now i connect the database with the interface made in 2005. and say a person enters some invalid data through the interface. but the error messages are generated by SQL server. how am i to display the SQL server generated error messages in the VB made interface??

PLS HELP ME .. if the question is not clear pls tell so that i can explain it further.

PLS PLS PLS HELP ME

View 1 Replies View Related

How To Show SQL Server Data Validation Error Messages In The VB 2005 Designed Interface ???

Apr 27, 2008

I'm developing a database-driven program using SQL server 2000 and Visual Basic 2005.

Most of the guys say professional programming is doing the validation stuff (such as the constraints and data integrity stuff like" [0-9][1] " and the use of LIKE IN keywords etc.) in the databse itself.

say i did the data validation contraints in SQL server itself. and now i connect the database with the interface made in 2005. and say a person enters some invalid data through the interface. but the error messages are generated by SQL server. how am i to display the SQL server generated error messages in the VB made interface??

PLS HELP ME .. if the question is not clear pls tell so that i can explain it further.

PLS PLS PLS HELP ME

View 4 Replies View Related

How To Configure A Dataflow Task Having A Runtime Source Table Name And A Runtime Destination Table Name

Apr 18, 2008

Hi,

I am having a Data flow task in For each loop which will gets 100 sourcetable names and 100 target table names...

am having a simpleData flow task which trasferes from OLEDBSource to OLEDBDestination.
I am repeating the Dataflow task which transfers from sourcetablename extracted from for loop to a destination table var.

The problem am gettting is for the first table it is able to transfer correcly because I did mapping for those tables at design time...but for the next coming sourcetable-desttable (which r having different no of cols,datatypes) its giving Validation failed...and...needs to refresh metadata....

is there any way to refresh the metadata of Data flow task (I set the property of OLEDBSource validate external meta to false then also same error is coming)

Thanks
Radhika

View 4 Replies View Related

How To Write .net Code To Place XML Messages On Queues And Retrieve XML Messages From Queues.

Apr 2, 2008

Hello, please help!!

I have spent days searching the web and forums for an answer to this simple question and cannot find an example.

I have built a service broker application on sql server 2005. The application puts some xml on an incoming queue which is basically a few parameters to be used in a query. This queue will then call a stored proc which does some business logic and puts the resulting results in another queue also in xml.

I have written a test harness in SQL to put messages on the inbound queue and then some sql to retrieve the returned code from the outbound queue.

What I want to do is be able to convert the SQL which does this into .net code to be used by an application. i.e. write in .net some code to put xml on a queue and then write some .net code to retrieve xml from another queue.

I wouldn't have thought this would be a difficult thing to do and would have been done hundreds of times, but unable to find anything to simply send and retrieve XML to service broker queues....

thanks for your help.. its really needed. I found some links, but they are really vague and often doing select statments in service broker or something like this. I don't want to call any sql, just send and recieve XML on the queues.

any example code that does this, would be really helpfull

kind regards,
David Weeden
Database Developer

View 2 Replies View Related

Need A Web Interface

Aug 3, 2006

Hi all. I'm not sure if this is the correct place for this question, so my apologies if it should be in another section.

I need to build a simple QA (quality assurance) DB for my company (a small physician group). I have the DB built in Access, but would much prefer to put it in SQL Server for reasons of stability, security, and access control.

What I would like to do is build a web interface to this DB so the users can just click an IE shortcut on their desktop, and be able to enter information via the browser like they would in a form in MS Access.

What would be the best way of going about building something like this? My background is as an analyst, so I'm unsure when it comes to actually building a front-end.

Sorry if this question is simplistic or if it has already been answered, and thank you in advance for any assistance you may lend.

View 3 Replies View Related

Interface

Mar 5, 2008

how can i down load interfaceor fix the problem?

View 2 Replies View Related

HL7 Interface

Jan 4, 2008

I am working on the project for Health Care Provider. They use HL7 interface to data sources. Any other interface is not an option. I need to address following scenarios for daily ETL jobs:

Pull analyses results for patients based on certain criteria to my database (SQL2005). Hundreds of results per day.
Verify list of patients against master list thru HL7 and update data elements that has changed. There are millions of patients
I am considering using WEB Services task in SSIS for scenario 1. Scenario 2 is more complicated because of the volume of data. I am considering using BizTalk for this one. Can BizTalk handle this scenario? Is there is more efficient way?

View 2 Replies View Related

Interface Not Supported

Jul 17, 2000

I have the following VB function. The stored proc that is being called
("GetList") inside the function does a simple SQL Select statement against
an SQL Server 7 database using OLE DB. I'd like to store the result of the
SQL Select statement in the "Rs" parameter to pass back to the calling
function. Whenever I call this function, I get an error message stating "No
Such Interface Supported". Does anyone know why I cannot do this?

Also, this function is being called from ASP code. That's why the "Rs" is
passed as a variant. It's created in the ASP code before this function is
called.

------------------------------------------

Function GetAddressDropDownList(Rs As Variant, CustomerId As Long)

Dim ProcComm
Dim Parameter

Set ProcComm = CreateObject("ADODB.Command")
ProcComm.CommandType = adCmdStoredProc
ProcComm.CommandText = "GetList"

Set Parameter = ProcComm.CreateParameter("CustomerId", adInteger,
adParamInput)
Parameter.Value = CustomerId
ProcComm.Parameters.Append Parameter
Set Parameter = Nothing

ProcComm.ActiveConnection = BuildConnectionString()

Rs.CursorLocation = adUseClient
Rs.Open ProcComm, , adOpenForwardOnly

Set Parameter = Nothing
Set ProcComm = Nothing

End Function

View 1 Replies View Related

Query Interface

Jan 15, 2007

Is there an interface that I could use in SQL Server to create queries or tables instead of typing codes in query analyzer? Any help would be appreciated.

View 2 Replies View Related

Log-file For Interface-use

Jul 23, 2005

Dear All,SQL-SERVER-DBAccess interface25 usersI want to know how the users are working with the interface:* What forms the use* What routines the run ( commandbuttons)* How long they use the interface* etc.I'll use a public function to add the information.Where should i store the information ? :* in a table in the SQL-DB: 1 table for all users on the server* a text-file for each user on the users computer.What solutions is the quickest?Thanks,Filip

View 1 Replies View Related

Oracle/MS SQL Interface

Dec 27, 2005

Hi everyone. I need to be able to query a database in Oracle and thenactually save the data in an MS SQL database, does anyone know what isthe best way to do this? Would it be best to do everything internal(inside MS SQL) or external (with some script: javascript, vbscript,perl)?Thanks in advanced,Mike

View 6 Replies View Related

Run A Sql-sript From Interface

Jul 20, 2005

Dear All,I'm looking for a VBA-code to run a sql-sript from the Access.adp-interface.I want to send scripts so my client can add sql-server-objects from theinterface.Thanks,Filip

View 1 Replies View Related

Interface Not Registered

Jan 13, 2006

I was trying to burn cds when I got thisfda error message stating Interface not Registered what does this mean and can someone tell me how to fix it 

   -thanks Lequeta

View 3 Replies View Related

ASP.NET 2.0 Interface For SSIS

Feb 21, 2006

Hi there,

we have several DWH Load processes running in SSIS, however I want to enable the enduser to have more control and information about the status of these processes. Therefore I plan to write a monitoring interface based on ASP.NET 2.0. However I hardly could find good docu or samples on what is available from within ASP.NET 2.0 to read out or control SSIS.

Anybody having me some good pointers to start with ?

View 2 Replies View Related

The IDMClusteringAlgorithm Interface

Jan 29, 2007

Good morning,

Well... I'm implementing a clustering algorithm following the examples given on the Managed Plugin Algorithms tutorial. As the samples are in C# and I'm implementing it on C++, I'm facing some problems, but nothing really significant.

But I've some conceptual questions about the implementation:

1) It necessary to implement the IDMClusteringAlgorithm interface in order to implement the ClusterMembership() and the CaseLikelihood() methods, right ?

2) The changes needed to be done on the Navigation class have nothing to do specifically with clustering. These changes are only to set calculated statistics to be shown, and if I want, I can simply don't implement them. Is this correct ?

3) Is there any documentation on the parameters received by the ClusterMembership and CaseLikelihood methods ? What's its inputs and outputs ?

Any clues are wellcome.

Thanks a lot again.

View 10 Replies View Related

ETL Vs Export Interface

Apr 19, 2007

Dear Friends,

I'm having a problem...

I need to export all the work that I have done in SSIS, but I dont know the option to do it... If I do a printscreen of the ETLs, I dont have all the layout of the ETL... Do you know how can I get it better to create my document?

thanks!

View 5 Replies View Related

User Interface For SQL

May 30, 2008



I downloaded SQL Server Express 5.0 and would like to know - must I open SQLServer through a studio like SQL Server Management Studio Express, or can it open on its own? Does it come with a GUI inside it?

I clicked Start/All Programs/Microsoft SQL Server 2005 and only submenues were displayed, not the server itself. The submenues were

Configuration Tools
SQL Server Management Studio Express.

Thanks.

View 1 Replies View Related

Interface Not Registered

Dec 31, 2006

I was just wondering why when i go to burn a cd it says Interface not registered. If somone could help i thank you.. cause i really want to burn cds again. thanks

View 3 Replies View Related

Direct Interface To SQL Server

Dec 4, 2007

I did a little bit of looking in the forums for something like this, but I wasn't able to find anything.  In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see:
- A dropdown of different connection strings, to connect to different databases
-A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once)
-A gridview object for results
-A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc)
 I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output.  Anyone have any ideas?  It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)

View 2 Replies View Related

Web Interface For Managing SQL Server

Jun 11, 2001

Hi all

Does any one know abt the web interface for managing SQL SERVER
I would like to create database,create tables create users, modify, insert data etc.. over the web

i belive there are interfaces are available on the net

can any body tell me from where i can download it

Thanks in advance

Prasad

View 2 Replies View Related

What Is The Best Visual Interface To SQL Server?

Feb 15, 2001

HELP!!! I've looked at a few, but none of them support insert and update. I hate to say it, but the Access inteface is better, but uses a different SQL than SQL Server. :(

Help,
mike

View 3 Replies View Related

Fast User Interface

Dec 14, 2001

Hello everybody,
please advice: what is the fastest standard method of user interface access to SQL database? I am looking for fast display of one master record plus related dependent records, plus fast scrolling through master records with display of dependent records as fast as posible. Perhaps a standard problem with standard solution? At current state of matters, I am still much slower then with my old Access97 database.

thanks for any advice,
Otakar Kverka
Prague

View 1 Replies View Related

What Happened To Nice BCP Interface In SQL 6.5

Nov 20, 1998

In the SQL Object manager tools for sql server 4.21 there was a gui interface for running BCP where you could select tables and fields etc.

I haven't beem able to find abnything equivalent in sql 6.5 enterprise manager. Am I missing someting, or was this dropped?

Thanks.
Jerry Dunn
ViaHealth
jerry.dunn@viahealth.org

View 1 Replies View Related

MS Access Interface With MS SQL Server

Dec 17, 2004

I am getting "writing conflict" or "Update or Cancel Update Without AddNew or Edit" errors even though there is nobody else updating the same record. I use Access Form as interface, the DBMS is MS SQL Server 2000 Standart Edition. I did not write any code for the form and its AllowEdits property is set to Yes.

Can anybody tell me what is the problem and how I can fix it?

Thanks... :

View 10 Replies View Related

Interface Link Between 2 Database

Mar 29, 2012

We are looking for a way to have sales data to flow from 1 database to another database on same SQL server. Can we build or have a link between 2 database? If yes, how to and how much effort will that be?

View 2 Replies View Related

SSRS Parameter Interface

Sep 6, 2007

I don't want to use SSRS's GUI for parameter entry. It's quite minimal and not very easy to use for users and doesn't cope very well with large selection lists (E.g if you wanted to select 3 companies from a list of 60 000 to run a report for).

So I want to make my own parameter entry screen and then pass only the user parameter value selection on to the report parameters.
Can I do that? Are the parameters exposed?

I'd wanna do something like:
My_SSRS_Rep.param1=@MyValFromMyApp1
My_SSRS_Rep.param2=@MyValFromMyApp2
My_SSRS_Rep.Run/Refresh/View

Currently I just have a Windows form with a web browser control in it.
And I've set the url to http://myserver/reportserver?%2fDB+Report+Server%myRep&rs:Command=Render
So it is possible?
Or do I need to go about this some other way like using the SSRS Report Viewer or some other mechanism?

Answer:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88484
Report Viewer it is then!

UPDATE1:
Or maybe not...
When I do the following, the report does not refresh:

Dim param(0) As Microsoft.Reporting.WinForms.ReportParameter
param(0) = New Microsoft.Reporting.WinForms.ReportParameter("Test", a)
Me.ReportViewer1.ServerReport.SetParameters(param)
Me.ReportViewer1.ServerReport.Refresh()

Anyone know why?

View 4 Replies View Related

Interface For SQL Server Database

Jun 2, 2006

Comments and ideas for software tools (ActiveX components)to make a user interface for database.

View 3 Replies View Related

Sql Server Wait Interface?

Jul 20, 2005

Oracle has a 'wait interface' for monitoring bottlenecks, etc... does SQLServer have utilities like this?

View 3 Replies View Related

SQL Interface Data Security

Sep 13, 2007

I would like to initiate a discussion regarding a client-side interface using a SQL db. Specifically, I want to have all users with read-only privileges, but include an event on a form that will nevertheless update a record on the server using a different user identity in ADO code - one that has read-write privileges in the database.

Is this a common approach?

View 5 Replies View Related

Interface For Visual C++ In VS 2005?

Jun 13, 2007

I've been tasked to understand and develop an easy interface to query (insert, select, update, etc) a sql server compact database on an x86 win ce 5 machine. I'm using VS 2005 and have all the necessary SDK's installed. The problem is I can't find any good tutorials or documentation on sql server compact coding in C++ (only in C# and VB). Do y'all have any suggestions on where I can get started to learn the basic c++ sql interface coding?

Thanks!
Jeff


Edit: I'd like to note that I can run the sample northwind project on a win ce 5 x86 emulator, so it's not the setup that I need help with, but the actual coding.

View 6 Replies View Related

SQL Network Interface, Error 28

Oct 7, 2007

When I initially downloaded SQL Server Express the System tables were visible using SQL Server Management Studio Express. I was able to create a new database and define and populate a couple of small tables. I then attempted to set up an ODBC SQL Natvie Client connection so that I could print the table contents using Crystal Reports. That failed with the following error message:
"An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections."

I subsequently uninstalled and reinstalled SQL Server Express. Now, I get the following error message whenever I try to connect to the database using SQL Server Management Studio Express. Additionally, the System tables are no longer visible. However, I can access my database via the Server Explorer in VS2005.

TITLE: Connect to Server
------------------------------
Cannot connect to STAN-DELLSQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476


View 4 Replies View Related

BIDS Interface Question

Mar 23, 2007

Hi,

When I open a project in BIDS, for some reason it automatically opens a new tab for each and every package in the project, which is both time consuming and a bit annoying.

I don't want to open a tab for a package unless I do it myself.

Is there a way to turn off this behavior?

Thanks

View 1 Replies View Related







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