I fixed that issue now I'm getting this its not complaining about the slash anymore.

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

@FilePath varchar(max),

@..." failed with the following...

I tried to put duplicate \ the package just shuts down  and yes I did read it

I'm the admin of the server so I should be able to have this send a email with the source file that I'm pointing it too?

Here is the image I...

Hi Jeff,

I can't find the syntax errors in this can you take a peak for me I'm new to scripting in sql

Keeps complaining about this:

Msg 102, Level 15, State 1,...

Thank you now will this put the data it’s calling in the file as well ?

thank you

Do you have a email ?

How is my stored procedure going to look like ?

I was having browser. Issues so do I run the command option in the Data flow tas I just need a outline

Hi Jeff

so how would I put this in my send mail task in my ssis package are you familiar with ssis packages ?

ok I fixed it and I got this output:

---------- ----------

2020-02-16 2020-02-22

nStartLocationID nEndLocationID nDonorCount tEffectiveDate cChangedBy

---------------- -------------- ----------- ----------------------- --------------------------------------------------

but I have nothing from the table in there showing but I...

Hi Thank you for youre respone,

I was wondering can you type out the correct format that it suppose to be I'm new to sql so I just want to try...