The is an undocumented engineering script you can use to change the collation on an entire server, which includes all databases, all fields and all indexes. It's also very quick....

Maybe you could use an SQL Agent Job to run the SSIS package which itself is started using sp_start_job

https://msdn.microsoft.com/en-GB/library/ms186757.aspx

Use the for each loop to populate a table with the full filename of each file. Have two additional fields of Prefix and FileDateTime, derive the values for these from...

If you use the Project Deployment Model you can set up parameters in your project, either at the project level or package level. (You can even tailor these to your...

You could simplify your SQL, for example:

declare @start datetime;
set @start = '20170101 09:00:00';
declare @end datetime;
set @end = '20170101 09:15:28';

select convert(varchar(8), @end - @start,...

Create a string variable and call it currentFile.
In the For Each Loop editor go to Variable Mappings, in the Variable field select User::currentFile and in the Index field enter...

So I have been doing some further reading and it would seem that XS:string will always map to wstr with a 4000 characters limit, you cannot map it to  Unicode...

Use an Execute SQL Task to run the SQL to return the connection string records. Map the result to an object variable in SSIS. Then use a Foreach loop using...

In your data flow task use substring in a Derived Column Transform