SSIS deployment issues

• Cannot use Excel data connection with error: SSIS SQL Server 2012 - The requested OLE DB Provider Microsoft.Jet.OLEDB.4.0 is not registered.

Solution: Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.

• Cannot move the files to the target folder after processed with error: "Access to the path is denied"

Need to give the full permission to the SQL server service account in the folder property.

• ...