Skip to main content
4 votes

How do I grant the privilege of connecting to SSIS?

I faced this today, basically the user you are using has not allowed to use SSIS: Here the steps to allow your user to SSIS: Open a commend prompt as Administrator and type Dcomcnfg.exe Go to ...
Francesco Mantovani's user avatar
1 vote
Accepted

dtexec returns immediately without any messages

When you run dtexec with the parameters I used, you cannot specify the file extension .dtsx with the package name. That causes the program to exit immediately, without error messages. Why dtexec ...
user1443098's user avatar
1 vote

dtexec returns immediately without any messages

You are almost there, the syntax you are using is correct by you cannot use an abbreviation /Val. From the official documentation, you can see that: /Rep[orting] level [;event_guid_or_name[;...
Hadi's user avatar
  • 1,222

Only top scored, non community-wiki answers of a minimum length are eligible