At present I have a number of jobs that are scheduled and executed through SQL Agent. The Agent is set up to execute batch files that parse data into variables contained within the packages themselves.
Is there anyway that I can get data into variables without using batch files just to make the process more integrated in SSIS rather than starting the process in SQL Agent to start the job, coming out of SQL Server to execute the batch file and then back
into SQL Server to run the packages detailed in the batch files?
I would like to point out that this is something I have inherited not built myself.
View Complete Post