Solved

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

Posted on 2008-10-04
8
993 Views
Last Modified: 2013-11-30
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
Comment
Question by:Pharmica
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22641825
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
 

Author Comment

by:Pharmica
ID: 22641841
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
 
LVL 51

Accepted Solution

by:
Mark Wills earned 300 total points
ID: 22641884
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
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
LVL 30

Expert Comment

by:nmcdermaid
ID: 22828832
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22830709
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
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 22837435
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22839640
@pharmica: you still out there ?
0
 

Author Closing Comment

by:Pharmica
ID: 31503075
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

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question