Windows - Concatenate multiple text files into one

In cmd:

type *.txt > OneFileName.txt

Linux: Create a file

 touch myfile.txt

Linux - make a copy of a file

cp <FILENAME> <path>/<NEWFILENAME>

CMD - Copy Folder's files list to a texst file

dir /on/b > 1.txt

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(@FullPath),1) + 1) AS OnlyPath,

       RIGHT(@FullPath, CHARINDEX('\', REVERSE(@FullPath)) -1) AS OnlyFileName

TSQL command - Get list of files in a folder

declare @files table (ID int IDENTITY, FileName varchar(100))

insert into @files execute xp_cmdshell 'dir \\\Public\itai'

select * from @files

       where FileName like '%.DAT%' -- filters