Hi,

The error which u mentioned will be execute when u parse the query but if u try to run the execute task it will run successfully .

Hi,

consider the @[System::ContainerStartTime] as a new column in derived column transformation and while mapping into the destination table , map the modified_date column with the derived column which was considered...

Hi,

In execute sql task, parameter mapping

variable nameDirectionData typeparameter name parameter size

user::empnoInput Long 0 ...

Hi,

as u said single quotes i pass date within the quotes it is showing this msg.

Msg 8114, Level 16, State 5, Procedure uspInsertFlight, Line 0

Error converting data type varchar to...

Thanks for reply it is helpful

Requirement is like that without using sql query .populating data using only ssis transfomations.:-)

without using the query .Means using oledb source and aggregate tranfomations i need to send to destination .

Not using that query in execute task or in oledb source

create table tablename( column name int identity(1,1))

identity refers auto increment first one refers from which number u has to start and the second one tells how much u need...

no it is has to read from folder from system

can u tell hw to do in ssis

option (maxrecursion 0)

now Recursssion error wont occur if i write this code in that program

DECLARE @SDATE DATETIME

DECLARE @EDATE DATETIME

DECLARE @MLIST TABLE

(MName VARCHAR(30))

SET @SDATE = '2000-09-20'

SET @EDATE = GETDATE()

WHILE (@SDATE < @EDATE)

BEGIN

INSERT INTO @MLIST

SELECT DATENAME(month,@SDATE)

...

Thanks fr reply

declare @date1 datetime

declare @date2 datetime

set @date1=GETDATE()

set @date2='2011-12-25'

;with cte as (

select datename(month,@date1) as [Month_Name],@date1 as dat

union all

select datename(month,DateAdd(Month,1,dat)),DateAdd(Month,1,dat) from cte

where DateAdd(Month,1,dat) < @date2)

select [Month_Name] from...

hi ,

plz find the atttachment.