create all your variables you need in your SSIS package.
Pass them to your script task.

then in your code, read them into a variable, assign a value...

gmail has to use port 587 as well as the  use_ssl flag.
here's the exact script i use. replace"sqlnotifications@gmail.com" with your gmail address instead.
--#################################################################################################
-- BEGIN Mail...

you'll need to re-save it as a lower version.
with Visual Studio, create a new Reporting services project.
add an existing item with the specific rdl in question.

right...

here you go, here is one way:
i just used a case statement to examine the fifth character, to determine where to start the substring:
/*
ActualValue  ExpectLeftValue ...

Beating my own drum here, but i put together a procedure that queries the metadata to script tables and objects:
I try to maintain it as best I can, it's...

your example was not syntactically correct, i fixed it for you.
the key you want here is to group by and SUM.
some things just don't belong in the results,...

SearchAllTables from stack overflow explicitly ignores date/datetime datatypes.

peek at the code:  

modify your version to use datetime data...

in SSMS, if you drag the columns folder from the SQL object explorer to an ssms window, all columns will appear as a comma delimited list.
it's easier then to...

SQL doesn't have a rowtype equivalent.
ROWTYPE , in sql terms for me, is used in a cursor as a collection of all the @parameters that would correspond to each...

We have an Audit in place that captures Login created or Login Changed.
I have seen on patch nights, those same logins get dropped and recreated as part of the patches;
i...

it's gotta be permissions.
here's my suggestion:
On the  SQL Server, Create a credential that has your actual username and password, because we know it works when you execute it.

can you create some Aliases in SQL configuration manager, so, for example servers named [ProdCluster01]  and [ProdETSource] etc etc are all aliased to point to your local machine? or to...

the verb was just so it mirrored the filename and process; it just seemed right;
This was republished today , as it had some relevancy for new folks.

use a script task instead of a file system task;

the code would look something like this:

string WorkingDirectory = (string)Dts.Variables["WorkingDirectory"].Value;
      string ArchiveDirectory = (string)Dts.Variables["ArchiveDirectory"].Value;

how are you sending the data to CSV in your job step? sqlcmd? bcp? powershell? SSIS? both sqlcmd and bcp can add those delimiters , and force column widths .