Issue – My BI developer informed me; They are no longer able to connect oracle data sources they have created in their cube. Troubleshooting – As I am aware; In order to connect to Oracle; you should have oracle client installed properly. As it was working earlier hence my first impression was; they definitely have… Read More Issues related to Oracle Client in SQL Server.
Issue – How to export .dtsx file from SSISDB as from SQL 2012 onward you will not see .dtsx package listed in integration services. Note – This is shortcut solution. Step 1: – Go to Integration Services Catalogs à Project Step 2: – Right click on Project à Export Step 3: – Save project file… Read More How to export SSIS package ( dtsx file) from SSISDB
SSIS access permissions are managed via Component Service under DCOM Config 1. Run –> dcomcnfg.exe or Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer 2.Right click on MSDTSServer or MSDTSServer100 ( based on SQL version ) 3.Click properties 4.Click on the Security tab 5.Select Customize and add the users/groups to the… Read More How to grant access on SSIS Server