not working

Thanks for the reply. I can parse this statement successfully but when i hit execute i can see this

Msg 911, Level 16, State 1, Line 9

Could not locate entry in...

actually see this code.

declare @sql as varchar(Max),@CostCenterCode varchar(Max)

set @CostCenterCode ='123'

set @sql ='SELECT FundingCostCenterId

FROM gtl_srf_funding C

JOIN F_Adv_iter_charlist_to_tbl'(' +@CostCenterCode+ ',...

What I did to resolve the issue was,

Select * from msdb.sys.database_mirroring

you can see a column named mirroring_connection_timeout,

the default value in that column is 10 sec but due to intermittent

network issues...

It continuously checks some records by executing select commands and when needed it issues delete statement which is like this below.

DELETE FROM dbo.CMS_InfoObjects5 WHERE ObjectID in (705469...); DELETE FROM dbo.CMS_RELATIONS5...

Hello guys, any updates ... I really appreicate if someone can focus more on this.. Thanks

I was analysing my detailed deadlock report and it looks like...

--For Spid =58

- <process id="processbaf438" taskpriority="0" logused="0" waitresource="KEY: 10:72057594052214784 (4b007efe08c7)" waittime="2421" ownerId="474019538" transactionname="SELECT" lasttranstarted="2010-03-22T11:15:45.360" XDES="0x80754d48" lockMode="S" schedulerid="1" kpid="7796" status="suspended" spid="58"...

Thanks for your replies.

So accoring to your answer I need to create 2 conditions

1) PwdExpiration ---@PasswordExpirationEnabled = False use login options facet

2) TestUserPwdExpiration---@name LIKE '%testuser%'...

Hey Jeffery,

I agree with your answer.

AS per you,

What I would do is remove the extra notify operator tasks - you only need one of them. Connect each task to that...

Sorry, but I am rather dense, and do not understand your amplified explanation. Some items is question:

1. Does user pass in a single parameter value?

--no users can pass any number...

ummm not really. i have years starting from 1985 to 2009 and it will increase every year so next year 2010 will be added.

@visa1985 is a parameter like...

The query retrieves the expected rows because the date values in the query and the datetime values stored in the RateChangeDate column have been specified without the time part of...

hey jason did u find the answer for this?

thanksa lot. I got that but one lil confusion. for one of my column values in text files are 00 but after running packkage i can see values as...

Of course I have defined the workflow.. and that is on completion of the task go to next step

so it doesnt matter its successful or fail.

--I checked the log file...