title: SSMS change to take data from unzip files to table
body: <p>I have an script which enters the data into the database through zip files, first moves them after unzipping them and then inserts data from the <code>CSV</code>, resulting from unzipping, in the tables. And now I would like to change this script to take the data only from another database and table, but I need to be able to put this data where the <code>CSV</code> data went.</p>
  <pre><code>USE [$(DataTools)];
  GO
  
  DECLARE @LoadJob  VARCHAR(64) = '208_table';
  DECLARE @LoadStep VARCHAR(64) = 'spMoveUnzipLoad';
  DECLARE @PreLoad  VARCHAR(128) = CONCAT('etl.spChangeFileEncodingAsMUZLPreLoad ''', @LoadJob, '''');
  
  DELETE FROM [load].LoadParameters WHERE loadJob = @LoadJob;
  
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'copyOrMoveFile'     , 'move';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'doNotUnzipFile'     , '0';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'FileMask'           , 'data.csv.gz';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'firstRow'           , '2';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'forLoadFolderName'  , '\ForLoad';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'formatFile'         , '\208_Customers.fmt';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'loadedFolderName'   , '\Loaded';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'notLoadedFolderName', '\NotLoaded';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'sourceFolderName'   , '$(SourceFileLocation)';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'targetDatasetName'  , 'table_Staging';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'targetDatabaseName' , '$(DatabaseName)';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'truncate'           , '1';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'unzipFolderName'    , '\208_Customers\Unzip';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'PostLoadSql'        , 'test_PostLoad';
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'PreLoadSql'         , @PreLoad;
  EXEC [load].setLoadParameter @LoadJob, @LoadStep, 'workingFolderName'  , '\208_Customers\Working';
  ------------------------------------------------------------------------------------------------------------------------
  --                                                     End of Script
  ------------------------------------------------------------------------------------------------------------------------
  </code></pre>
  <p>How can I change this script to take my data from the tables?
  Does it change or does it need to be recreated?</p>