I have an ssis package in sql to export some tables from access database to sql. I have added the ssis packae in batch file and executed. The tables were imported but the tables are empty. If I directly execute from ssis then all tables with data are imported.
This is the command of the batch file
"C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /f "D:\New Package.dtsx"
Aradhana TripathiPosted Mar 24, 2025, 11:46 AM
It seems like the issue might be related to connection settings.
Check if connection strings in the batch file are correctly configured.
Sometimes, passwords or other sensitive information might not be saved properly in the SSIS package.
Amira BedhiafiPosted Mar 23, 2025, 9:56 PM
I think your issue is likely due to missing permissions or differences in environment when running the batch file.
Try running the batch file as Administrator, or use the full DTExec path for your installed SSIS version (for example SQL Server 2016 uses a different path).
Also, check if the package uses Windows authentication or needs Access database drivers, which might not be available in the batch context.