How do I delete one entry then?

alright.. Let me create everything u said and then may be u can provide the solution.

I have created a proc which gives the results on daily basis instead of weekly basis.. Will that be helpful??

Sorry If I was not able to provide the correct details. I read the article. and will take care of this in future.

but coming back to my original solution, can...

hi,

can anyone tell me how to do this?

I have a similar kind of proc that produces the results for weekly instead of monthly. Can I share that? DO u think it would be helpful?

Below is the result...

These are the csv results:

CHJUSDDN,App,LMA,2012-03-30 00:00:00.000,I/O,16.9,2012-05-25 18:31:29.323

CDGDFGD545E,App,LMA,2012-04-03 00:00:00.000,MEMORY,0.22,2012-05-25 18:31:29.323

CRFGFG12ZE,WEB,LMA,2012-04-30 00:00:00.000,ScanRate,0,2012-05-25 18:31:29.323

CDFGDRFDGD,App,ESN,2012-05-12 00:00:00.000,RUNTIME,0,2012-05-25 18:31:29.323

BGFGHJ676RF,SQL,LMA,2012-05-31 00:00:00.000,CPU,0.0426399999999989,2012-05-25 18:31:29.323

HHJUI878DFE,DB,POR,2012-06-01 00:00:00.000,DiskSPACE,164.8,2012-05-25 18:31:29.323

i NEED COUNTER_VAL IN 'MEMORY, I/O, CPU'

INSERT DDL:

INSERT INTO [EMDB].[dbo].[STG_CAP_HLI]

...

create table st:

CREATE TABLE [dbo].[STG_CAP_HLI](

[HOST_NAME] [varchar](255) NOT NULL,

[SERVER_ROLE] [varchar](255) NULL,

[CHANNEL] [varchar](255) NULL,

[DATE] [datetime] NOT NULL,

[COUNTER_NAME] [varchar](255) NOT NULL,

[COUNTER_VALUE] [float] NULL,

[DATE_TIME_CREATED] [datetime] NULL

) ON [EMDB_FG01]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[STG_CAP_HLI] ADD ...

I need to do it using SSIS only. I mean I have to copy the data.

Really sorry.. It was mistake at my side. Bt ur replying speed was much faster than fixing my mistake here.. It is working without any issues.

This is not working.. Did u make any change to code?

What if we declare 8 variables and then put the values in those. That will be good for me.

I am trying the values for the result set in a temp table.

I created the below temp table:

create table #temp (datevalues datetime)

How can I store the values from this result set in a temp table?

I created below table:

create table #tempfriday(datevalues datetime)

Now I am trying to declare 8 variables and and put...

Thats a good answer. It will help lot. Thankyou 🙂

Thanks a lot!!