March 17, 2017 at 9:07 am
Dear All,
I get the following error message when trying to create SSIS package by using dtexec Utility:
Could not find package error message.
I'm using the following link to create the package: https://www.mssqltips.com/sqlservertutorial/215/command-line-deployment-tool-for-ssis-packages/
Thank you in advance
March 17, 2017 at 9:34 am
Did you provide the full path to the package?
What is the full command you are running? Seeing the arguments you provided will likely help resolve the issue.
dtexec is an SSIS package deployment/execution tool not an SSIS package creation tool.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
March 17, 2017 at 10:17 am
Thanks for your reply! I've now managed to deploy the dtspackage on to the MSDB database which is on the Integration Services but I'm now trying to find out how to createa folder so I would be able to group all of my dtx packages please?
Syntax:
DTUTIL /DESTSERVER "Servername" /FILE"File location\nameof the dtxpackage.DTSX"
Thank you
March 17, 2017 at 11:19 am
tt-615680 - Friday, March 17, 2017 10:17 AMThanks for your reply! I've now managed to deploy the dtspackage on to the MSDB database which is on the Integration Services but I'm now trying to find out how to createa folder so I would be able to group all of my dtx packages please?
Syntax:
DTUTIL /DESTSERVER "Servername" /FILE"File location\nameof the dtxpackage.DTSX"
Thank you
It has been a long time since I have used the Package deployment method for SSIS. We migrated to an SSIS catalog ages ago but if memory serves, you can't make folders with the old method.
I could be wrong (and wouldn't be surprised if I am).
If this is an SSIS catalog, I would expect you would need to compile your DTSX into an ISPAC and then deply the ISPAC which would create all of the folders. Mind you, I usually use the GUI to deploy SSIS projects.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply