Lookups are case sensitive unless you set the No Cache option.

When you build an SSIS solution in Data Tools or Visual Studio it creates an ispac file in the Bin folder. You can transfer this file to the SQL server...

In my last role we used SQL DB logging for SSIS in 2008, you don't have to worry about locks on a text file then.

The doesn't answer your question directly but offers a possible alternative. Since SQL 2012 you can use Project Deployment with SSIS where logs are automatically created in the SSISDB and...

Having had problems myself using Temporary Tables and CTE's with SSIS your best option is to create a stored procedure and use EXECUTE WITH RESULTSETS. I believe the problem is...

It does seem to me that this is a Windows security issue. When run from SSMS all is okay so it would have the security context of the user who...

You might have to put this in a stored procedure and EXECUTE WITH RESULTS SETS where you define the schema expected. Here is MS's example

EXEC uspGetEmployeeManagers 16 ...

Please provide more detail about how Server D is executing an SSIS package on Server A. Unless I am missing something I didn't think this was possible unless you execute...

Have a look at the WinSCP .NET Assembly. You can then run FTP or SFTP direct from VB.NET or C#.

Not how you want to use it but, I...

You could achieve this in SSIS without any C# coding. This is a rough outline of what is involved.
Use the Execute SQL Task to get a Distinct List of...