SSIS Catalog - Can you deploy a package without a catalog

Question

SSIS Catalog - Can you deploy a package without a catalog

ClockSpeed8

Old Hand

Points: 344
More actions
January 7, 2015 at 4:33 pm

#313489

Is it possible to deploy a SSIS package without building an Integration Services Catalog on the server?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 1

Sure you can. You just have to turn on the previous deployment method.

I'm trying to remember right now where it is, but try package properties or maybe deployment properties. Then you can deploy like you used to.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Right-click the project in SSDT and choose "Convert to package deployment model".

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 3

yep, there ya go.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

ClockSpeed8 Old Hand Points: 344 More actions · Answer 4

Thanks guys. I actually found these two link together pretty helpful:

databasejournal.com

SQL Server 2012 Integration Services - Package Deployment

http://www.databasejournal.com/features/mssql/ssis-2012-integration-services-package-deployment.html

youtube.com

SSIS 2008 Series: SSIS Package Deployment part1/2

https://www.youtube.com/watch?v=YXJ2lplvA28

Now researching what types of permissions I need to create and deploy to a catalog (the 2012 way) vs. deploying to the file system or msdb (the 2008 way) as described above.