man, login 30 minutes late :-D.. you must figure out somethings yourself..

on a serious note I'm not sure why that'd happen..

code looks fine..verify whether you have values in dts variables or not

it could point to shared drive too but ensure you have adequate free space there

REPLACE(LTRIM(REPLACE(field,"0"," "))," ","0") is the expression, this won't work if field value has space characters

you could use replace function in ssis

I did it once. you'll have to use script task..here is a lead

http://stackoverflow.com/questions/5541848/save-content-of-email-body-in-outlook-to-a-file

This also should work..

declare @people as table (

person varchar(20),

dob date

)

declare @SDate date

set @SDate= '5/3/2013'

insert into @people(person,dob)

values ('Frank','3/20/1990'),

...

perhaps this might help:

declare @tbl table (id int,string varchar(512))

Insert into @tbl

SELECT 123,

...

if date is after 01/01/1900 then following should work

declare @d datetime

set @d='04/29/2013'

select dateadd(day,-(datepart(dw,dateadd(month,datediff(month,-1,@d),-1))-1),

dateadd(month,datediff(month,-1,@d),-1))

have that city column value into a variable and use derived column

You could skip data rows until you encounter "EmpName,HR,4" record, insert into HR table

try removing "@" infront of SSIS variables in the query, appropriate casting, also verify final query in the SQL command variable with some dummy data in other ssis variables

You can execute it every one hour and if found then send out an email

this should work too...

declare @t table(empname varchar(32),sal money)

insert into @t

select 'patrick',1000

union

select 'john',12000

union

select 'peter',500

union

select 'robert',360

union

select 'steve',810

union

select 'edward',3000

union

select 'sean',1200

union

select 'ricky',500

select * from(select empname,ROW_NUMBER() over (order by sal desc) as position from...

this should work

declare @start int=2013,@end int=2015

;with cte(temp,yr)

as

(

select @start,cast(RIGHT(@start,1) as varchar)

union all

select temp+1,cast(yr+'/'+RIGHT(temp+1,1) as varchar) FROM CTE WHERE temp<@end

) SELECT max(yr) as result FROM cte