Your response wasn't very clear this time around too. Having said that i have tried to answers with my best guess.

Question 1. How...

You need to cast your integer values to string in order to achieve this.For loop will increment your integer number but not really sure what you want to achieve through...

Well, I assume all Database have set to Recovery model 'Full' and you don't take periodic Transaction Log file backup. It is necessary to take transaction log backup so that...

Well, this can be achieved through dynamic sql. All you need to do it to construct the select CASE portion of the query with dynamic column list you have in...

Nice question Steve. Thanks for being easy on start of the week 🙂

There are few ways to get the desired output. You can look at this one.
Note: Aded an 'ID' column (Identity)  in the result table to ensure order by and...

Glad to help.

For the query you shared you need to do the following:
1. You need to remove the "EndTime" column from your Group by Clause.
2. Remove the Distinct Key word...

1. First you need to make sure WinSCPnet.dll to Global Assembly Cache (GAC). For SSIS you need to register your WinSCPnet.dll to Global Assembly Cache (GAC).
2. to download file from...