Hi Brian -
I have SSMS installed and so does my co-worker. It is my understanding that dtexec comes along with that installation. The dtsx. file gets invoked via Excel or Powershell, so there isn't an error that shows. I look at the SQL table and I can see data wasn't populated... that's pretty much how I come to find out it didn't execute. My co-worker does not have SSDT installed though.
Hi Frederico -
I have a license for SQL Server but the DBA do not allow SSIS on the SQL server I am using. Using the SSIS Catalog is not an option. As work around, I am using SSDT to create a package to automate how flat file data makes it way to an SQL table.
Is it possible to create a dtsx. file and a user invoke dtexec /File \\path\to\file\filename.dtsx, from Excel? Or is it, to utilize the dtsx. file, the user must have a SQL Server license? I thought I could create a package (such as this, to import a flat file) and pass access along to any user? Is this not the case?