I have a DTSX package that is called from a SQL Agent Job. The DTSX package references a file at a fixed location (e.g. e:\mssql\myfile.txt). On most machines, this location exists, but on some I have to manually map this (which is not a problem - I know a better solution would be to use package conifgurations to dynamically pull the ...
I have a pretty basic SSIS package that is attempting to read a file hosted on a share, and import its contents to a database table. The package runs fine when I run it manually within SSIS. However, when I set up a SQL Agent job and attempt to execute it, I get the following error: Executed as user: DOMAIN\UserName. Microsoft ...
I'm running a VBScript in SQL Agent but I get a 'Permission Denied' on line 34 (the first copy attempt). I've run this script outside SQL Agent with no problems FYI: The 'X:\' drive is mapped to a SharePoint folder. This may be the culprit. Function Main() Const SourceDrive As String = "X:\" Dim fso Dim Today Dim FileName Dim FromFil...
I'm trying, unsuccessfully, to remotely execute an SSIS package. The package resides on a SQL Server 2008 instance and I'd like to call it from a Job on a 2005 server. The error I'm getting is: The package could not be loaded. The step failed. If I go from 2008 to 2008, there is no error. Any ideas? ...
Is there a way to trigger a job on a from another job on a remote server without using Linked Servers? The reasoning is that the job being triggered executes an SSIS package on 2008. The calling job resides on a 2005 server, so cannot execute the job directly. The servers are not linked, and I was hoping there was a way to call one f...
Task: Write timestamps into MS SQL database table every second. Solutions: External application which writes timestamps by schedule (Sql agent for example). Stored procedure, which writes timestamps in infinite loop. Questions. Which of the solutions is best? Is there any drawbacks of running infinite loop in stored procedure? ...
I have a scheduled Check Database Intergrity maintenance plan in sql agent. Every time it completes, i get an email and it has always succeded until now. This time the status in the email is "Failed". I have tried to excute the job manually in management studio and again it failes. I now want to investigate and find out why and get issue...