March 21, 2018 at 7:55 am
Team,
I'm trying to figure out if I can import packages in SSISDB catalogue and run bat script
Is this still possible ?
Can someone share example please ? I'm not able to find anything from Microsoft so far
If we are not able to use batch script then what will be the alternative ?
example please, I'm new with SSISDB
Thanks
Dave
March 21, 2018 at 8:04 am
What do you want the batch script to do?
March 21, 2018 at 8:23 am
We are migrating from 2008 to 2016 and developers are running packages from c: drive folder using .bat script
so they want to use something similar in future, Can this be possible in SQL 2016?
please explain
March 21, 2018 at 8:34 am
Davekahn - Wednesday, March 21, 2018 8:23 AMWe are migrating from 2008 to 2016 and developers are running packages from c: drive folder using .bat script
so they want to use something similar in future, Can this be possible in SQL 2016?
please explain
So you want to know whether it is possible to execute SSISDB-deployed packages from the command line?
Check this post to see whether it answers your question.
Alternatively, create a stored proc to execute packages in SSISDB and call that from your bat files.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 21, 2018 at 1:34 pm
Thanks Phil
Can we still setup jobs old way from agent and keep SSIS packages in C drive ?
Or this is not possible in SQL 2016 going forward
March 21, 2018 at 2:34 pm
Davekahn - Wednesday, March 21, 2018 1:34 PMThanks PhilCan we still setup jobs old way from agent and keep SSIS packages in C drive ?
Or this is not possible in SQL 2016 going forward
File system is still a Package source on the job step screen, so yes.
Also, if you want to continue to run packages from the C: drive, why import them into the SSIS db at all?
March 21, 2018 at 3:59 pm
Well, another DBA in office is saying we can't use .bat script with keeping packages in C drive we need to use new SSIS DB
I was looking around in Microsoft and not able to see any white paper that says we cannot use old way of doing things
So if we keep the script in c:drive folder and run a bat file from agent we will be fine - If I understood correctly
Please confirm
and if you have any white paper that will help
Thanks
March 22, 2018 at 5:23 am
Davekahn - Wednesday, March 21, 2018 3:59 PMWell, another DBA in office is saying we can't use .bat script with keeping packages in C drive we need to use new SSIS DB
I was looking around in Microsoft and not able to see any white paper that says we cannot use old way of doing things
So if we keep the script in c:drive folder and run a bat file from agent we will be fine - If I understood correctly
Please confirm
and if you have any white paper that will help
Thanks
It should continue working as you want. Why not download 2016 Dev Edition and test it for yourselves ... it's free?
I would suggest that you do consider migrating to SSISDB though ... there are a few excellent benefits of doing so.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 22, 2018 at 12:11 pm
Davekahn - Wednesday, March 21, 2018 3:59 PMWell, another DBA in office is saying we can't use .bat script with keeping packages in C drive we need to use new SSIS DB
I was looking around in Microsoft and not able to see any white paper that says we cannot use old way of doing things
So if we keep the script in c:drive folder and run a bat file from agent we will be fine - If I understood correctly
Please confirm
and if you have any white paper that will help
Thanks
I think what your other DBA is trying to tell you is to look at doing this using the catalog instead of using batch files. Once you actually migrate to using SSISDB you won't need batch files to kick of jobs - or need to worry about encryption of credentials or package configuration files or other file-based options.
You may even find that you can simplify things since you can now setup a project and deploy as a project, separating out functionality across different packages as needed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply