So my scheduled job is set for every monday at 7am for that location so you are saying everytime the job is executed it will update to the current week.

I wasn't sure if running this package weekly if that function would update automatically every week

Actually for the week of February 23rd

again I really appreciate the help

Subject line needs to state previous week if possible.

My CSV file that i'm using right now contain the dates for the week of 23 to 29th but the subject line that I used that code...

Thanks Phil I appreciate it how would I get it to say for the week of 23 to 29th?

Its not liking youre @Subject = CONCAT('Transfer Report for the week of ', CONVERT(CHAR(10), GETDATE(), 101)),

Msg 102, Level 15, State 1, Line 11

Incorrect syntax near 'Transfer Report for the week...

Here is my current Execute SQL Task :

DECLARE @FilePath nvarchar(max) = 'C:\inetpub\ftpuser\WESA\ftpwashingtondc\DCWeeklyEmail\'

DECLARE @Filenames nvarchar(max)

DECLARE @EmailAddress varchar(max)

SET @EmailAddress = '?'

SET @Filenames = @FilePath + 'dc_weekly' + '.csv'

EXEC msdb.dbo.sp_send_dbmail

@Recipients = WESA,

@Subject =...

Hi Jeff,

Finally got my package fully functional and working another question is the report I'm sending weekly  as of right now my subject line shows 'DC Transfers Report' how can...

Yes I got the data coming straight from a database in my production server so the package in my flat file destination editor  not exactly sure why its not attaching...

Hi

Thanks for you helping me out I apoligize but I'm new to programming this language my next question is why isn't any of my data showing up in my csv...

my apologies i forgot about this

Msg 102, Level 15, State 1, Line 24

Incorrect syntax near '+'.

Msg 102, Level 15, State 1, Line 30

Incorrect syntax near '@subject'.

ok So i fixed it to be correct its only complaining about one thing now thats highlighted in bold

Declare

@FilePath varchar(max),

@filenames varchar(max),

@LoginFile varchar(max),

@EmailAddress varchar(max)

set @FilePath = 'C:\inetpub\ftpuser\WESA\ftpwashingtondc\DCWeeklyEmail\'

set @EmailAddress = '?'

Select @LoginFile...

So I narrowed it down to my Send Script Task and here is the error:

[Execute SQL Task] Error: Executing the query "Declare

@FilePath varchar(max),

@..." failed with the following error: "Attachment file...

No it doesn’t it should be

C:\inetpub\ftpuser\WESA\ftpwashingtondc\DCWeeklyEmail\dc_weekly.csv