Recent content by luzippu

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

fantastic thank you

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

thank you i have now solved this issue by using flashvars.

thank you