Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1004
  • Last Modified:

SSIS problem: File System task (delete file) does not run on remote machine

Greetings,

I created an SSIS package that does a number of things, the last task is to delete a file.  When I run the SSIS package from within MS SQL BI is runs fine and deletes the file off the server.   However, when I run the package using DTexecUI, on the same machine, the delete task does not execute.  The file never gets deleted on the remote server.  Just so you know, I do not have SQl database or integration services installed on this machine, I just have the Business Intelligence Studio installed.  Any ideas?
0
Pharmica
Asked:
Pharmica
  • 4
  • 2
  • 2
1 Solution
 
Mark WillsTopic AdvisorCommented:
They will be running under different accounts for a start, so probably has something to do with how the different accounts have been set up.

Also if you are running 64 bit, then there are a couple of other issues... dtexec comes in 32 bit and 64 bit editions, dtexecui does not - in fact VS is not. So, might be having problems at that level as well. Are you running 64-bit ?
0
 
PharmicaAuthor Commented:
Actually, I am running it from a laptop, not 64-bit.  I am running both from the same laptop.  Once this goes into production, a server will run it nightly, but I need to see it work on my laptop first.  Should i try using dtexec instead of dtexecui on my laptop?

0
 
Mark WillsTopic AdvisorCommented:
Yes, would be best... But you still have different user profiles - SQL Server Agent is a service with own profile, SQL Server - again how / who you login as, VS - your user - so unless you have them all starting / setup to be "you" and you have admin / sysadmin with Windows authentication, then you could have a few different profiles running those jobs. Gets tricky like that...
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
nmcdermaidCommented:
Pharmica can you verify whether you are using SQL Agent or not?
I don't know that using DTExecUI necessarily means that SQL Agent is involved.
 
0
 
Mark WillsTopic AdvisorCommented:
DTexecUI is the one you can use interatively... then there is DTEXEC (interestingly comes in both 32 and 64 bit flavours where as DTEXECUI is only 32 bit - I think)...
0
 
nmcdermaidCommented:
In the old world (DTS), you generally used the UI version to assist in building the command line. I assume SSIS is the same.
0
 
Mark WillsTopic AdvisorCommented:
@pharmica: you still out there ?
0
 
PharmicaAuthor Commented:
Sorry, I forgot to close this question.  You were right about the profiles.  After reviewing the account information, the services were running with an account that did not have rights.  Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now