now i m getting this error

[GROUP_ITEM_DETAIL [962]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC0202009. There...

u r right ...i resolved that problem

but can u tell me If Preview option in Dts components doesn't show records what does that mean ???

MY DTS is running success fully...

hi...it was great to look into the solution provuded by that lady.but can you tell me PROCESS MONITOR is a third party tool or something else.

and can you tell me...

USE [db]

GO

/****** Object: StoredProcedure [dbo].[usprunreport] Script Date: 10/01/2008 11:38:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[uspfruadreport]

@startdate datetime,@enddate datetime

as

set @enddate = convert(datetime, convert(varchar(11),enddate ,103),103);

set @startdate =...

actually ......one of my colleague asked me about it . he is on leave today ..as sson as he comes i will let you know....

try this out

USE [db]

GO

/****** Object: StoredProcedure [dbo].[usprunreport] Script Date: 10/01/2008 11:38:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[uspfruadreport]

@startdate datetime,@enddate datetime

as

declare @startdate datetime;

declare @enddate datetime;

set...

this is basically Project requirement ,we need to show record randomly

and see below query ,i added BETWEEN clause bcoz i needed 2 records for every Gid.

BUT

Can you tell...

thanks a lottt ..JEFF...it works Fine

Can u explain the logic ...i never use this CTE feature

Jeff....appreciate you immediate response.

Actually my requirement is slightly Stupid..

I want always different recid corresponding to their Gid whenever i run it.

For example

1st run

1 a

4 f

8 b

2nd run

2 a...

Is it possible to use TOP in this query ....i want to use TOP

hi nitin,

Solution suggested by GILA is very good

but i can give you in more elaborated form

run the followinf SP

it will by default get executed in your master database

then...

Restart your SQL server Agent ....you problem will be sorted out

Gila,

Sorry for posting in caps actually i was in hurry ...so didn't notice that..i will keep in mind

but question for you ..

DECLARE @d DATETIME

SELECT @d = '2008-09-24 14:19:56.293'

SELECT DATEDIFF(d, 0,...

Asked Query is basically : return no if week in passed dates

so i think ...my query is returning no of weeks in a month .

for ex: select datediff(ww,'05/01/2008','05/03/2008')

it will give...

thanks ..i deselect that option ..and it works.:).i dont know who had selected that ?

but by the way ....why this option is used for ???