COPY file from the SAME DIRECTORY LOCATION as the SQL Script File
I am using this copy function and want to make it part of a script deployment. Is there a way to reference the current directory the script is in as the path. For instance, I could place this copy script anywhere on a machine and then the FROM line of the COPY script would look like: FROM '.../TestFile.txt', where the .../ represents the current file location of the script...I just don't want to have to manage changing this, but allow it to be copied to any folder and ran from any location...
WITH DELIMITER E'\t'
QUOTE AS E'\t'
NULL AS '';