thanks for the replies so far
the time has changed on the recurring instances under the history tab. ie: if you click on the recurring the instance properties show the "Next Run Time: ... 09:35:18" instead of 08:30
any of the reports if run manually only take a couple of minutes.
but what i...
has anyone else experienced this before:
i have several scheduled reports that have been running fine for months. the scheduled time for this reports "was" 8.30 am. for unknown reasons all scheduled reports are now running from an hour to an hour and a half later.
i defenetely haven't changed...
I need to create a customised job that runs every day except fot the first of every month.
Is this feaseable?
How can I build a customised schedule to use within a job?
Thank you
Hi
I'm using a job to run a batch file with several robocopy commands in it.
The step in the scheduled job runs a SSIS package saved in the Server Package Store.
The SSIS package uses an 'Execute Process Task' control flow item.
The 'Execute Process task' simply calls and execute the batch file...
Thanks vbkris.
yes i'm using a job to run this script on a daily basis.
i've found on another post:
Set FSO = CreateObject("scripting.filesystemobject")
FSO.CopyFile "P:\test.txt", "C:\test.txt"
is this the sintax that i should follow?
but i couldn't find much on the "if newfile date >...
hi everyone,
I need to create a ssis in MS SQL Server 2005 that can complete the following:
copy filea.mdb and fileb.mdb (readonly files) from s:\folder1\ to c:\folder1\ on a daily basis (let's say at 07:00am)only when the files dates (modified date) are greater than the equivalent files dates...
----------------------
MS Win XP Pro 2002 SP2
MS SQL Server 2005
MS Visual Studio 2005
----------------------
I'm trying to schedule a job in Management Studio (SQL Server Agent)for a SSIS package that runs fine in BI Visual Studio and that also runs ok if executed from Management Studio...
----------------------
MS Win XP Pro 2002 SP2
MS SQL Server 2005
MS Visual Studio 2005
----------------------
I have designed 3 Projects (.dtproj) in Visual Studio each containing a dozen Packages (.dtsx) and saved them on a local folder.
I'm now in Management Studio and would like to schedule...
hi,
i can't see why the following field is not working correctly, ie: it's always coming up with 0:
((POWER((1+((((((POWER((1+(dbo_table1.APR/100)),(1/12)))-1))*12))/12)), dbo_table1.FREQUENCY)-1)*(12/dbo_table1.FREQUENCY))*100 AS YIELD
breaking the code down to a smaller formula it does...
hi,
i have tried the following code on both the 1st frame of the main movie and on the movieclip itself, but it doesn't work or gives me a huge image:
mymovieclip.loadMovie("loaded/mulino.jpg");
_root.mymovieclip._width = 200;
_root.mymovieclip._height = 200;
what am i doing wrong...thanks...
thanks all for your input.
i've tested the truncate option and it does the job exactly how i need it and very fast.
i surely be in touch again before the end of this project.
ttfn
luzippu
hi,
i need to be able to "drop and recreate" some tables in an sql server 7 enviroment as fast as possible.
currently i have a simple dts that deletes data on existing tables, then other dts's that insert new data back into this tables.
due to size and indexes, the delete process takes a...
atomicchip
the code above is related to a flash menu and sits between an html page. the url i'm trying to get at, is not the url where the .swf file is , but the url of the current page: for example http://www.mysite.com/about.html
in fact the same flash menu is used in several pages, and i...
I need the flashvars below to retrieve the current url value:
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0"
width="864" height="180">
<param name="movie"...
briefly, what i'm trying to achieve is:
i need to modify a website in dreamweaver where the page template has a table with a top cell where a flash menu sits and a bottom cell where the contents (in html) changes depending on the page you're in.
the buttons in the flash menu change formatting...
bkeeton or anyone taht can help,
have you found a solution to your initial problem?
-ie: on-demand subrpt to prompt for parameters only when double clicked and not within the main report parameter window-
i have the same issue and would like to find a solution.
thank you
Sorry about that:
the subreport consist of:
RHc: where the header fields are hidden.
GH1: Region group, linked to the main rpt, no fields.
GH2: Sector group, linked to the main rpt, no fields.
GH3: Country group, linked to the main rpt, with 'count of orders' and 'sum of value' fields.
Da: this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.