Reporting Services is a reporting suite. It's not a designed to do things like replace Microsoft Office's Mail merge functionily, as you use that to send letters, or similar. Reports...

You can't send parts of a report to different people, no. You would need to generate a separate report for each individual.

What version of SSRS, and licence, are...

If the names are always the same, and there is no unique reference, i would suggest a staging table. Then you check for existing records and either not load the...

I assume that you mean SSIS 2012? There is no 2010, however, when launched SSDT 2012 used VS2010.

Personally, my way, is by having a column for the file...

I'm still not 100% sure on what it is your attempting to achieve here, so I'm going to explain my understanding, and if it's correct, bingo! ^_^

You have...

When the user has the option of inputting their demographic, can they have more than one? Ideally, when dealing with a many-to-many relationship, you would use a composite key table....

Something like:
SELECT *
FROM dbo.sysjobsteps sjs
WHERE sjs.subsystem = 'SSIS'
AND sjs.command LIKE '/ISSERVER "\"\Agile\"%';
This would return all the job steps that reference a...

What version of SSDT and VS are you using? If you're using VS2015/2016 have you set your Target Server Version correctly? You can check it by right clicking the project...

you ask how to design, but you already posted the design of your database in a separate topic. What is your actual goal here if not to gain...

As pointed out, when running any task via the SQL Agent, the service account must have access to the location being referenced, and, also have the relevant permissions (for example,...