In order to quick copy a package from SSIS project to another:
- Copy the package file from Windows Explorer.
- Paste it on the project node in the Visual Studio.
SSIS: copy package between projects
SSIS Excel Connection Manager 64-bit error
Error message:
[Connection manager "XXX Excel Connection Manager"] Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Solution:
Right click on the project name à properties
Configuration Properties à Debugging: Set Run64BitRuntime to False.
SQL Server String: Get File Name from Full File path
DECLARE @FullPath NVARCHAR(500) = N'D:\Itai\Tasks\MyFile.csv'
SELECT LEFT(@FullPath,LEN(@FullPath) - charindex('\',reverse(@
RIGHT(@FullPath, CHARINDEX('\', REVERSE(@FullPath)) -1) AS OnlyFileName
