Please enable JavaScript.
Coggle requires JavaScript to display documents.
Suppression export, Job steps, Actual Job Steps - Coggle Diagram
Suppression export
Truncate table
Get export dates
Call export API SP
Wait until file is on FTP
Download file
Merge files together (run Additional 4)
Create file copy
Upload files on FTP
Call export API Transact
Wait until file is on FTP
Download file
Create suppression tables (one for SP and one for Transact)
Job steps
Call SQL instruction to truncate tables
Call PHP scripts to generate files
Wait x minutes for files to be ready
Packages to download files // maybe PHP script to download
Packages to insert file to tables
Run Additional 4 SP
Package to duplicate file
Package to upload files
Actual Job Steps
TRUNCATE TABLE [Sales_DW].[reten].[tmp_Suppression_Silverpop]
TRUNCATE TABLE [Sales_DW].[reten].[tmp_Suppression_Transact]
START
http://finance04.secure-backend.com/silverpop/RunSuppressionSilverpop.php
START
http://finance04.secure-backend.com/silverpop/RunSuppressionTransact.php
WAITFOR DELAY '00:01:00'
EXEC [Application].[dbo].[usp_RunSSISPackages] 'DownloadFilesSilverpop'
EXEC [Application].[dbo].[usp_RunSSISPackages] 'DownloadFilesTransact'
EXEC [Application].[dbo].[usp_RunSSISPackages] 'ImportFileSilverpop'
EXEC [Application].[dbo].[usp_RunSSISPackages] 'ImportFileTransact'
1 more item...