Search results for query: *

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...

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...

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...

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...

Crystal v. 8.5 I have a subreport placed in the GH3 of the main report. The subreport only shows a tot count and a tot sum of the details within the subreport. The headers for these two fields are included in the main report's PH. When I drill down on the subreport to view the details...

How can I transform a string &quot;yyyymmdd&quot; (ie: 20020131) to a date format #dd/mm/yyyy# (ie: 31/01/2002)? I cannot use @StrReverse() or @DateValue()... Thanks in advance for your help luzippu

How would you subtruct a frequency 3 (where 3 is a quarterly frequency) from a date (dd/mm/yyyy)? ie: {billing.date}-{billing.frequency}: 01/06/2003 - 3 = 01/03/2003 or 01/05/2003 - 6 = 01/11/2002 or 01/12/2002 - 12 = 01/12/2001 etc. Thank you