SO u just want to update where Propertyid is 9. I thought u want to update all other records with that UserID.....

here this should do

UPDATE A

SET A.PV = 'FALSE'

-- use...

Here this should work.........

CREATE TABLE #TEST ([UId] int, PId int, PV varchar(10) )

INSERT INTO #TEST VALUES

(33138, 9, 'True'),

(33138, 8, 'False'),

(33138, 5, 'False'),

(33138, 7, 'False'),

(33130, 9, 'True'),

(33130, 8, 'False'),

(33130, 5, 'False'),

(33130,...

UserID PropertyID PropertyValue

33138 9 True

33138 8 False

33138...

So if UserID = 33138 and PropertyID = 7 and PropertyValue = False

Update UserID 33138 Set PropertyValue = True where PropertyID = 9

Are you trying to make us fool or...

Hi All,

I want to know if there is a way to dyamically set Source and destination in a file system task.

Eg I have a move a file from C:\ to...

select email

from user1

where userid in(

select userid

from adminroles

where roleid = (select roleid from notification where seqno =100))

i am not sure how ur email are stored in tbl. I am...

Then create one more variable called "Month" as datatype string

bring Sql Execute task and

map this variable to this T-SQL

SELECT DATENAME(mm, GETDATE()) As [Month]

in the SQL task general page set...

OK, so I was able to successfully copy the Excel file from one location to another, but I don't know how to include the date/month in the filename after it's...

I think what a fool i was too not to tell you that dts packages were in 2000.

There was no doubt that packages were in 2000 msdb. It's just job...

I think Greg answered the issue, and in 2005 ssis packages are in msdb.dbo.sysdtspackages90.

I think you have to take out the dts package from msdb and save and you...

Addicted,

You have accurately described what I did.

Transferring the jobs also seems to have transferred the DTS packages that those jobs run. Jobs that kick off DTS packages work. However,...

Dwolfe, Sorry I got confused here. Since I haven't done this on my own. SO you telling me that there were jobs in Sql 2000, some of which used to...

Create few varaibles It will be easy for u . Like variables to hold each folder name. Actually you can copy rename and archieve just using one file system task....

sarvesh thanks, But looks like again I was not clear. OK

let me try to explain here in more detail. I have a table with column name as clerk_name where data...

thanks guys............But looks like I was not clear on my questions and postings.

All I needed was name in two different formats. I have a field in a tbl called EName...