How to schedule package Continuoulsly?

Hi,

I have requirement that i need to Schedule package continuously(every 10 Seconds).

Any solution on this?

it would be great!

Duplicate post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1037184&SiteID=1

sql

How to schedule package Continuoulsly?

Hi,

I have requirement that i need to Schedule package continuously(every 10 Seconds).

Any solution on this?

it would be great!

H there,

I'm afraid that 2005 doesn't give you the possibility to launch processes on seconds-basis, so you could do a little vb application where inside a loop and using a Timer..:

Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package

Dim EventsSSIS As Eventos

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

while true..

pkg = app.LoadFromSqlServer("msdb\yourpackage", Nothing, Nothing, Nothing)

sResultDts = pkg.Execute(Nothing, Nothing, EventsSSIS, Nothing, Nothing)

stuff..

Public Class Eventos

Implements IDTSEvents

OnPostValidate()

OnPreExecute()

..

stuff

|||Hi

I have two suggestions:
- you could reorganize your package to use an never-ending for loop, with a ~10 seconds sleep (I would try to do that first, if you have the possibility to modify the package)
- or use a scheduler (sql jobs, or third party software like nncron or cruisecontrol.net to trigger the package execution) - keep in mind that if you have to launch it every 10 seconds, it may end spending more time just starting and stopping compared to the time really used to carry out the transformations...

Thibaut|||

Sivarama wrote:

Hi,

I have requirement that i need to Schedule package continuously(every 10 Seconds).

Any solution on this?

it would be great!

Is SSIS really what you want here?

SSIS is inherently a batch tool. If you want something more real-time then perhaps BizTalk is what you're after.

-Jamie

|||Although you should have an "end process trigger", I would suggest using a for task, place all your stuff in it and just say while @.endtrigger = 0.

I have had a similar issue with trying to run things every 1 min, 10 sec is a little fast I think. On my server it takes an SSIS job 1 min 34 secs just to START the job. This makes it very hard to say, look for a file over and over, until it finds it.

How to save SQL 2005 solution?

Hi,
I have a solution within SQL 2005, which contains scripts of all
stored procs and views so that they are in source control. My
question is, how can I save this so that every time I open up SQL 2005
management strudio, it appears in the right hand pane, instead of
having to open it up every time.
Thanks for any assistance.How about having a shortcut for the sln file on your desktop?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1172157510.539730.34010@.k78g2000cwa.googlegroups.com...
> Hi,
> I have a solution within SQL 2005, which contains scripts of all
> stored procs and views so that they are in source control. My
> question is, how can I save this so that every time I open up SQL 2005
> management strudio, it appears in the right hand pane, instead of
> having to open it up every time.
> Thanks for any assistance.
>|||On Feb 22, 3:29 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> How about having a shortcut for the sln file on your desktop?
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1172157510.539730.34010@.k78g2000cwa.googlegroups.com...
> > Hi,
> > I have a solution within SQL 2005, which contains scripts of all
> > stored procs and views so that they are in source control. My
> > question is, how can I save this so that every time I open up SQL 2005
> > management strudio, it appears in the right hand pane, instead of
> > having to open it up every time.
> > Thanks for any assistance.
Is that the only way? Also, it is very slow loading them all. Think
I might just stick to using souce safe without the solution.

How to save SQL 2005 solution?

Hi,
I have a solution within SQL 2005, which contains scripts of all
stored procs and views so that they are in source control. My
question is, how can I save this so that every time I open up SQL 2005
management strudio, it appears in the right hand pane, instead of
having to open it up every time.
Thanks for any assistance.How about having a shortcut for the sln file on your desktop?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1172157510.539730.34010@.k78g2000cwa.googlegroups.com...
> Hi,
> I have a solution within SQL 2005, which contains scripts of all
> stored procs and views so that they are in source control. My
> question is, how can I save this so that every time I open up SQL 2005
> management strudio, it appears in the right hand pane, instead of
> having to open it up every time.
> Thanks for any assistance.
>|||On Feb 22, 3:29 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> How about having a shortcut for the sln file on your desktop?
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://www.solidqualitylearning.com/
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1172157510.539730.34010@.k78g2000cwa.googlegroups.com...
>
>
>
Is that the only way? Also, it is very slow loading them all. Think
I might just stick to using souce safe without the solution.

How to run solution from Visual Studio 2005

Hi.

Is it possible to run solution i have created by MS Visual Studio (filling table from file). I was thinking about schedueling job and launching the solution periodically from stored procedure.
Anyone has idea how these things work?

PKV

VS is used for designing a package. If you want to run your package on a schedule you should use SQL Agent to chedule a SSIS job to run the package.

How to Run Job without Sysadmin Role

Hi All,
I know this question have already posted frequently, and I've tried all
the solution that they're suggested, but still doesn't work. I've
changed job owner and also setup the SQL Server Proxy account and
password into that Non-SyAdmin user, but still failed when run the job.
Is there any other solution? Please help me...
ThanksWhat error are you getting when the job fails?
-Sue
On 9 Nov 2005 18:13:06 -0800, resant_v@.yahoo.com wrote:

>Hi All,
>I know this question have already posted frequently, and I've tried all
>the solution that they're suggested, but still doesn't work. I've
>changed job owner and also setup the SQL Server Proxy account and
>password into that Non-SyAdmin user, but still failed when run the job.
>Is there any other solution? Please help me...
>
>Thanks|||"Non-SysAdmins have been denied permission to run CmdExec job steps"
But never mind, i've solved now but i'm getting new error :
"The specified @.job_name (Name of Job) doesn't exist".
This happen when I changed job owner into sysadmin user not that
Non-Sysadmin user.
Oh yeah, I use sysadmin user for proxy account, so when a Non-Sysadmin
user run the job, they will use the proxy account, right?
So, what should I do now?
Thanks