How to call the SSIS Package in CA Workload:
Sometimes developer wants to call SQL Server Integration Service via CA Workload Process, Developer need to follow below points:
· Pick Data from created Database
· Transform the data in the format acceptable by client.
· Create .TXT file for Procedures (with header and multiple records)
· Encrypt the .TXT files
· Deposit encrypted .TXT files into SFTP for client to pick
For Example:
Developer can follow this process for DBs which created like EDH_DST DB.
CA Workload Process –
Workload will help us to schedule the SSIS Job to run at desired time. This workload will execute the following components:
1. This package will be responsible of generating all the necessary parameters to be used in SSIS package.
Configurations should be the follow parameters that used in SSIS packages.
To generate the xml files that will be used by the process, this SSIS must call the following command:
C:\WINDOWS\system32\cscript.exe
Summary:
Keep these points in your mind while calling SQL Server Integration Service via CA workload Process, our aim should not be to call SSIS manually only, but it should be call auto on daily basis via job Scheduler.
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.