how to set up two connection managers in a bat file

Paul Lummel 0 Reputation points
2023-01-25T21:46:01.5533333+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 46,031 Reputation points
    2023-01-27T06:44:26.0266667+00:00

    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.

    0 comments No comments

  2. Paul Lummel 0 Reputation points
    2023-01-30T22:08:39.0066667+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.