I need to delete rows in table 1 :

I am getting an Error message :

The DELETE statement conflicted with the REFERENCE constraint "FK_Users_Divisions". The conflict occurred in database "BidManagerCommon", table...

Report Wizard:

There is an error in the query. Implicit conversion from data type sql_variant to datetime is not allowed. Use the CONVERT function to run this query.

I...

yes, I am getting the error here..

Nope , I have Copied the error message

ADD-->> Report --> NewItem -->> Report -->> Dataset -->>commandtype--'Storedprocedure'-->>Querystring--'Procedurename'

It is a typo error invalid Object Name #Orderstastics

error Message :Invalid object name '#Orderstatics'. (.Net SqlClient Data Provider). I am getting

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Alter proc [dbo].[CdoeOrders_Test]

@userid nvarchar(20) ,

@StartDate dateTime ,

@EndDate dateTime

As

select b.User_ID ,d.First_Name+' '+ d.Last_Name as FullName,a.Cust_Name ,a.Cust_Num,SUM( b.PO_AMT) as...

We have sql server 2005 express edition... we don't have sql agent .. so we have to run dts package...

I believe data conversion is the reason I have changed ADDR_1 column to nvarchar. finally it's working ...

Thank you !!!!

Thanks ,

I have created the package in the same server

It is done through a maintence plan.

only one database is being backed up in the job. data, log files and backup files are stored on the same device and no other process is running...