I Got this. It worked. I just changed the column data type as nvarchar(4000) and gave size as 4000 near flat file source input. Thanks a lot for all your...

USE [ESG]

GO

/****** Object: StoredProcedure [dbo].[usp_Dashboard] Script Date: 01/06/2012 15:38:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_Dashboard]

AS

--TRUNCATE TABLE dbo.dashboard

/*Cut_Date*/

declare @cut_date date

--set @cut_date = cast(('30-NOV-2011') as date)

set @cut_date...

Incorrect syntax near bb

Incorrect syntax near a.

Yup. I used merge statement. It worked. Except was not giving the accurate results. That was weird.

I tried this. But not working

Thanks so much. That worked. I used Max function

select cal.datevalue

,datename(DW,cal.datevalue) day_of_week

,isnull(flowon.sum_flow_on,0) flow_on

,isnull(flowend.sum_flow_end,0) flow_off

...

Yup I got it. Thanks a lot for your time.

I have selected ignore failure for truncation and ran the package. But the data is getting truncated. How to solve this error. In my dest table for this column I...

Yup I got it. Thanks so much for the reply. I just replaced substring in place of right and it worked.

Thanks Drew and Ninja. It worked.

I used CAST(DATEADD(D,16,NULLIF(CURRENT_STMT_DATE,' ')) AS DATE)

Thanks for your time.

Thanks for the reply.

Its not working.

I have tried like this

CONVERT(DATEADD(D,16,CURRENT_STMT_DATE),NULLIF([CURRENT_STMT_DATE],' '))

Thanks so much. I got it

Not from BIDS. I want something like that in sql agent.

Thanks for your time. I will try that approach