I have a ssis pacakage which was in designed in 2008 and i have upgraded it to 2017 having flat file source.
I want to execute via ssis catalog (SSMS).
How to add file name in ssis catalog?
Asked
Active
Viewed 38 times
0
-
This is two question, File Name should be put in SSIS package, Can i know what are you mean add file name in SSIS catalog? – BeiBei ZHU Jun 10 '19 at 02:17
-
I have 1 package having flat file connection, given file location in package and run it via visual studio but now i want to execute this package from SSMS with the help of SSIS Catalog from different system, here how can i add my file location -Error: Cannot open the datafile. this error is showing while execute from ssis catalog. – Sneha Yadav Jun 10 '19 at 06:59
-
if you are using flat file connection manager, you shouldn't hard code it in it, you should have package parameter and use parameter inside flat file connection manager connection expression, and when you deploy to ssis catalog, u can config this parameter at Config tab. hopefully this help you – BeiBei ZHU Jun 10 '19 at 07:48
-
After using project parameter it is working as expected. Thank you for your great help. – Sneha Yadav Jun 12 '19 at 09:48