I am attempting to load data from an older database (APPX) to SQL Server. The files have 2 extensions, .dat and .key. I have tried File delimited and File regex but haven't been able to read the data yet. I have attached 2 files (in .zip file) as an example.
Can anyone suggest a way to open and import these types of files?
APPX has probably a proprietary file format so you cannot get the content using tFileXxxxInput component. Refer to the APPX documentation to get information about the best way to extract information from the database and produce CSV or XLSX files.
APPX has probably a proprietary file format so you cannot get the content using tFileXxxxInput component. Refer to the APPX documentation to get information about the best way to extract information from the database and produce CSV or XLSX files.
