There was an error executing the query. Please check the syntax of hte the command and if present, the types and values of the parameters and ensure they are correct. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

But when I run the query through Management Studio, I can get the result.

I am binding my gridview without using a datasource control and instead doing it in the code behind. However, I would like to use the inline editing features of the gridview. Could someone please point me to an example that does gridview editing/updating 'manually' in the code behind?

Hello,
On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink.
A data source has not been supplied for the data source DS_TraceEvents
SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX)
1. exec sp_executesql N'SELECT
dtb.name AS [Name]
FROM
master.sys.databases AS dtb
WHERE
(dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX'
this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server).
2. USE [datatbaseX]
this produces the following error:
Msg 911, Level 16, State 1, Line 1
Database 'databaseX' does not exist. Make sure that the name is entered correctly.
why is the report looking for the database on my server?
thanks
Jag
Environment: MDW (Management Data Warehouse) on SQL 2008 R2

Hi,
I'm creating a report model (2008 R2). I am trying to create a relationship between two tables. One FKs to another--same name and type (tinyint) columns. But the Data Source View editor doesn't allow this, giving the message "...source
and destination column have different data types". But the columns are the same types. I ahd this once before acouple of years ago and don't remember how I got around it.
Does anyong have ideas?

Nuances of using Excel data sources with SSIS
Your Development Machine Setup
Needs Jet Drivers, available along with the default Office install so if you have Excel working fine locally, this is enough.
Installing the "Office Data Connectivity Components" (download file name AccessDatabaseEngine.exe) as well as having Office installed corrupts the Jet Driver stack so that SSIS in VS 2008 cannot create the object to read the XLS file. You will
see the title error "Unspecified Error" and "80004005" code.
Resolution:
Uninstall the Jet Engine pack on your development XP machine if you have Office. It will be listed as something like "Microsoft Access Database Engine (2010)".
Run Office 200x setup with the Repair option and reboot. Try configuring the task in SSIS and it should be able to read the Sheet names again and columns.
Live Server (32-bit and 64-bit)
Deploying your SSIS package to a server without Office 200x means it will not have the Jet Engine drivers to read XLS, XLSX files. You must install the 32-bit Office Data Connectivity Components - Jet Drivers mentioned above found here (http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en).
There are no 64-bit drivers; therefore regardless of 32 or 64-bit live environments, this step is the same.
You shoul

On the control flow tab, there is an Execute SQL task that calls a stored procedure and returns a GUID.ÃÂ

I have a package scoped variable that stores a UNIQUEIDENTIFIER output from the stored procedure. It appears that the package variable data type does not include a GUID data type so I tried to use string instead.

Next, the Execute SQL task is mapped to a data flow task.ÃÂ

Within that data flow task I have an OLE DB Source which connects to a SQL Server Destination task.

On the OLE DB Source Editor screen I have a query that performs the following:

SELECT ID, SessionKey, ....

FROM dba_DroppedLoginsLog

WHERE SessionKey = ?

I have clicked on the parameters button to map the Parameter to my variable called User::SessionKey. This is the output variable from my Execute SQL Task component on the Control Flow tab. This value should be a GUID, but again, I don't see a data type for that.

When I execute the package it fails on the OLE DB Source with the following error:

When I try to copy and modify a data source, I get a server error that the operation is prohibited because it exceeds the list view threshold, but I only have 10 items in my list, well below the default threshold. I get the same error if I try to create
a new page from master. Anybody run across this one?

Confirmed the threshold with my administrator and even upped it to 10,000 but that did not help.

How do i set a data source of a drop down list which is inside a grid view, snap shot of asp code given below , the Asp file name is DataEntry.aspx and there is method in the DataEntry.aspx.cs called DTB.BindData("Department"). i want to set the datasource to point to this method

I am working on share point 2007.
I have added a XML Web service in Data source in Share Point designer 2007. This web service is custom web service which get data from 3 different type of list and creates XML and return that xml.

I have installed this web service as instructed in msdn. I checked it is working properly.
First time when I create a data source from XML web service in Share Point Designer 2007, It shows all records when I clicked on “Show Data ”. But after a few minutes it shows en error”
The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator. ”.

I am attempting to pass report parameters to my query. My report's data source is a WCF web service. I can run normal queries fine, but I have found that without the know-how to pass parameters to my query I am limited with my capabilities.

Assume a string parameter named "Name" with a specified default value of "Jmachol90", how would I pass that into the following query at the designated place:

Pardon the elementary nature of this question. I have a SQL 2005 database with several queries. I want to use the queries as data sources for grids in VS2008. I connect the SQL database but cannot see the queries as a data source.
I have tried building the queries in code within VS but I still cannot use the query results as a grid data source. Any Help would be greatly appreciated.

I've created an analysis services project in BIDS with the intention of creating a mining strucuture. I notice that you cannot create a data source view based on a query and that it must be based on linking actual tables (via the access looking
GUI). In my scenario I have a very long and complicated query which uses temp tables to retreive the data I want to use for mining. Am I forced to insert this data into a table in order to create and use a mining structure? Or are there
other ways to do it?

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.