Thanks for suggestion guys, I rewrote the code as shown below ... it is working right now.

DECLARE @currentDate datetime = ' 2012-03-22'

DECLARE @rowCount Int

DECLARE @count int...

i haven't seen something blocking in sysprocessors, but for hundred records it is executing fine but when the count increase to 10000 records. It keep on executing. So suggest...

Actually i am trying to map the drive using script in ssis + c#

hi, my problem is how can i get if it is on remote server. My flat file in CSV is on another server. how can i access that server. i...

I got the store procedure for above XML, The problem is i don't know how to insert vendor_cache_id it is underlined in XML file.

/****** Object: StoredProcedure [dbo].[usp_vendorCacheData] ...

i selected fixed width option, but i am displayed with only one column in preview

this is the accurate display of the table, and i created the table structure in database. What the problem is when i browse the flat file, after making connection...

actually i want to know is it possible to create primary key with non_cluster index.

DATEADD(S,-59, DATEADD(s,-1,DATEADD(M,1, DATEADD(D, 1 - DATEPART(D, GETDATE()), DATEDIFF(D, 0, GETDATE())))) )

how can assign are use above expression in expression builder in execute sql task.

any help that would be soooooooooo great

ok i dnt want milliseconds but it it possible to get above boundary without millis seconds. If yes how?

I hope we cant convert varchar to datetime

millis seconds as well..... the given date is my boundary value for my partitions. I need date including seconds to.

thanx for your clue

(1000 row(s) affected)

(4000 row(s) affected)

(4001 row(s) affected)

(2000 row(s) affected)

(2000 row(s) affected)

Msg 242, Level 16, State 3, Line 23

The conversion of a varchar data type to a datetime data type resulted...

update dbo.[sample]

set platform_id= 'AVMselect', creation_dt= '2009-02-7'

where Row_id between 131001 and 132000

update dbo.[sample]

set platform_id= 'Realquest', creation_dt= '2009-02-2'

where Row_id between 132001 and 136000

update dbo.[sample]

set platform_id= 'RealList', creation_dt= '2009-02-14'

where Row_id between...