Your post is more the unclear.
What is "MF Scheduler", what for a batch (BAT) file, what for a "CSV export connection manager"?
You have to provide much more details, otherwise it's impossible to assist you.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am run an SSIS package with MF scheduler that triggers the package by bat file. In the bat file I configured the connection manager to use what ever database connection I put in.
I want to do the same with the thing with the CSV export connection manager
Your post is more the unclear.
What is "MF Scheduler", what for a batch (BAT) file, what for a "CSV export connection manager"?
You have to provide much more details, otherwise it's impossible to assist you.
this is a Visual studios project that is running SSIS packages
in the Production environment I have to use a main frame scheduler to run this process
the Main frame kicks off a package that run a bat file out on the production server.
in the Bat file i can set up the set \Package.Connection [servercommectionmanager].Properties [ConnectionString];""Data Source= Prod*Server1234; " to run using the Prod_*Server1234" . that works fine
i want to put in a second set command to export the results of the the package that was triggered "set \Package.Connection [Use_this _connection} Properties [ConnectionString];\ ""\S:\Interdepartmental\dataresults\myfolder\Reporting\work reports
the main frame keeps giving me message not defined in the log files