My ssis packages are using project level params which are stored in project.params file. I am running packages via .bat file
Error code 0xC0047098
Description. The variable $Project::Jdb_sql_connectionstring was not found in variables collections . The variable may not exist in correct scope . Please advise
This my sql connection string. "Data Source =11.23.55.213;Initial Catalog=MYDB;Provide=SQLOLEDB.1,Integrated Security=SSPI;Persist Security Info = False;"
.bat file. code
@ECHO OFF
CLS
ECHO test execution
"C:\Program Files\Microsoft SQL Server\150\DTS\Binn\dtexec.exe" /f "F:\input\source\mypackage.dtsx"
cmd /k
Please advise