Est. Budget: $200.00
• I need to the SQL script (SQL Procedures) to export the tables / views to flat files
• In the database (SQL2012) there is the table which defined:
• which table should be exported [TableName]
• path ,[FilePath]
• Targeted file name ,[FileName]
SELECT [Id] ,[TableName] ,[FilePath] ,[FileName] FROM [MIS].[dbo].[T_BASE_ICV_STG_EXPORT_FILES]
• The flat file should be
o UTF-8 Character files.
o Double pipe delimiter (0x7C 0x7C) will be used between fields
o No fields will contain two pipe characters in a row
o A ...