Sivajihero Hero

Sivajihero Hero

  • NA
  • 105
  • 32.2k

Problem in running ssis via batch file

Nov 15 2016 6:42 AM
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"