loading an ssis package from batch

Robleh Wais 0 Reputation points
2023-02-05T20:28:59.6466667+00:00

I have a package that runs quite well from SSIS as a package to SQL Server. However, when I put it into a batch file and attempt to start my SSIS package the batch file fails with the following error code:

batchfilerrorStartingSSISpackage

The package is a data flow that pulls data from ms Access to SQL Server. It has a data conversion that converts the date field between ms access and SQL server. As I said above it works well directly from SSIS. I am wondering if there could a problem with my permissions in the folder where the batch file resides, I doubt that. I have run the batch file as admn too and it still fails. I'll keep searching for a solution, however.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,736 Reputation points
    2023-02-06T09:06:55.73+00:00

    Hi @Robleh Wais

    Could you please share the code in the batch file with us?

    Please make sure that you have installed SSIS on the machine.

    Also check that the target sql server version is correct in your package.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments