.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Schedule a package to run again... Any ideas how?

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server


I am planning on using a File Watcher task to have an SSIS wait until a file is submitted. This seems to work ok. However I want the package to launch itself again once it completes, or schedule itself to launch again in a couple of minutes. That way I could relaunch the task after it has processed and moved the current set of files. That way it would process loads more or less as they are exported by the source systems. I'm not even sure how to approach this problem as its not something I've done with SSIS in the past. The current solution uses batch files and DTEXEC so I'm guessing its scheduling via the windows scheduler. I would lean towards SQL Server Agent personally but that's just because I'm looking for something that will expose what jobs are running to me more easily than investigating processes.

I also wanted to know if it was possible to see what other packages were already running. That way if a package inadvertently launched while another instance of itself was still processing it could just shut itself down. I may also have dependencies between packages. So if package A was running, package B should wait rather than processing any of its files, and vice versa. I could do this by logging the packages in and out of a cusotm locks table, but that feels unweildy and the package may crash out and not "unlock" cor

View Complete Post

More Related Resource Links

Using schedule id in SSIS package

Dear all, I want use different variables in my SSIS package dependant on the schedule. So is there a way to use the actual schedule id from SQLAgent in a SSIS package? Thanks a lot, Nils

Schedule the SSIS Package?

Hi All,   I know how to schedule the ssis package in SQLSERVER Agent. Do you have any other option to schedule the package?   Thanks CMK…

Schedule a ssis 2005 package



Im new & would require how to schedule a Job for the SSIS 2005 packages I have created 40 individula packages, but can u provide me the steps to schedule these packages.


Schedule problem with SSIS package on SQL Server 2008

Hello there

Step 1 - I created my first SSIS package (simple ole db source to file destination scenario) in BIDS 2008. I created and run this on the SQL Server 2008 - SP1(on Win2k3 SP2 - 64 bit machine). This integratin scenario creates a flat file with some records in it (records modified today). This packages runs ok from BIDS.

Step 2- After deploying this SSIS package to the SQL Server 2008, I was able to run it successfully. The package created a flat file with some records.

On the two occasions above, the ssis package did exactly what I wanted it to do.

I tried to create SQL Server Agent job selected the Type as SSIS package, allowed this package to run under Windows Authentication (service account - same account used as in Steps 1 & 2). Before scheduling, I thought why not run this manually. The job ran successfully (looked at the success message and the history of the job), but a flat file was created (as expected) without any records (not as expected!)

Please note I have tried the default protection level ("EncryptSensitiveWithUserKey") as well as ("DontSaveSensitive") on the package.

I am suspecting that when the SSIS package is scheduled the SQL Server Agent is unable to pass the authentication to the SSIS package !?

Some help will be appreciated.


Problems posting to a package


Hey Y'all

I'm currently creating a program that accesses a mysql package to add data to a few tables.  I'm currently getting an error that says  "

ORA-01403: no data found
ORA-06512: at "JESSE.PKG_WORKPLAN", line 42
ORA-06512: at "JESSE.PKG_WORKPLAN", line 177
ORA-06512: at line 1


These lines are


and 177:add_team_members(V_PROJECT_ID, V_START_DATE, v_FISC_YEAR, V_MEMBERS ,V_NUM_MEMBERS,'add');

Checking these variables in my asp.net page they are all receiving parameters.

Is there a  way to see what the database is actually receiving from the asp.net page?

Or is there another thing to be looking at?


SMTP not working if I use web deployment package to deploy my app.


Hi all

I use msdeploy to install my web app. deployment package. everything about web app works, but find out email was not working.

I checked telnet smtp is running.

I debug the project, and it was sending out email too.

So my solution was upload the whole project (not complied) to wwwroot, and email works too. Thats why I assume the deployment cause the problem.

at last, I also tried to copy the web deployment web.config to replace the project's web.config, and the email also work, so it wasn't the web.config problem.

Could anyone tell me whats going on?

My environment:

window 2003

iis 6

.net framework 4.0

{ End Bracket }: Your Innovative Ideas


Having that next great innovative idea is only half the battle-getting it heard is the real challenge.

Eric N. Bush

MSDN Magazine February 2009

sql server agent - job schedule 22022 error


Hi ! I have scheduled a job in sql server 2008 to send birthday e-mails. I run the script and it looks wroking but in agent schedule it doesn't. I am getting the below error; what is the problem?

TITLE: Microsoft.SqlServer.Smo
Start failed for Job 'Sending_transferdb_birthdate_e-mails'. 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Start+Job&Link

36 ideas over the weekend for improving Visual Studio


We released WoVS last friday around mid-day. Since then, that is, only two days later, its Community section has received 36 different ideas for new VS features and improvements to existing ones. THIS IS JUST AMAZING!

Some of the more popular submissions so far are VS RoamingStack Overflow integration, and a built-in Chat!.


How to create WSP or Package for workflow in Share Point 2007?



I am working on SharePoint 2007. I have created 2 List called "Config List" (this is a list) and "Vacation Form" (this is form library & form designed in infopath). I have also created a workflow on form library "Vacation Form" in Share Point Designer 2007.

With the use of this workflow I am creating some task and updating "Vacation Form".

Now I want to deploy these three thing (Config List, Vacation Form & workflow) on other server.

How do I create a package or WSP file to install these things on different server.


G. Goyal

using SharePoint List for SSIS package

I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

Erro While Creating a Solution Package With a timer Job


Hi All,

I am trying to create a test Timer job in SharePoint and want it to be deployed as a solution package. I am using a web application project and added Timerjob.cs, fetaurereceiver.cs, feature.xml and manifest.cml files in in. Then I created a .dff file to arrange the solution package. But when I tried to create a solution package with makecab.exe i got the below error

100.00% flushing current folder

I dont know what to do with that . Please if anyone can send me an example where a timer job was deployed as a solution package it will be of great help




Isha kapoor My SharePoint Blog Follow me

The language-neutral solution package was not found.


Hope I might be able to find some help on this one...


I developed a simple web part which posts HTML form contents to a SharePoint list - on first deploy, it worked fine, using the Web Part project base from VSeWSS 1.1, but after deployment, I noticed I fat fingered a url for redirection, and went back in to change it. Now, on deployment I get the following error:


------ Build started: Project: ContactUsForm, Configuration: Release Any CPU ------

ContactUsForm -> C:\Visual Studio 2005 Projects\ContactUsForm\ContactUsForm\bin\Release\ContactUsForm.dll

------ Deploy started: Project: ContactUsForm, Configuration: Release Any CPU ------

------ Deactivate and uninstall features in old solution ------

------ Retract and delete old solution contactusform.wsp from the SharePoint ------

Retracting solution ...


Server Error: The language-neutral solution package was not found.

========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========


I've restarted IIS, recycled app pools, etc., but still keep getting this error and am a bit confused as to where to go next. I followed the steps listed in this blo

SharePoint 2007 - my site is schedule for deletion


My manager is getting the following email "The My Site of XXXXXXXX is scheduled for deletion. As their manager you are now the temporary owner of their site. This temporary ownership gives you access to the site to copy any business-related information you might need. "  Can anyone tell me the number of days before the my site gets deleted and can the deletion be stopped?

.Net Framework zip package file

Has anyone idea about .net package files?? I seriously have no clue about this & have asked to do a POC on this. I am told that this feature has come up along with .Net Framework 3.5 but couldn't find any pointer after googling even. It would be great if somebody can explain this & its usage??

Execute Package Task password issue

I have a parent and child package. Both are stored on the file system and both are password protected. My problem is that when I call the child package from the parent using execute package task, I get prompted for the child package's password. Now the PackagePassword property of the Execute Package Task is supposed to take care of that. But for some reason the password stored in the Execute Package Task is not getting passed to the child package.  I've re-entered the PackPassword property several times, but it did not help.  I even tried loading the password from a config file, but that did not make any difference.  Can anyone help?

SSIS Package Transaction locks entire table

Hello, I have SSIS package that using transactions and working as expected. But this locks all the tables involved in the data flow that are get inserted/loaded. If I query those tables during package execution the query waits till SSIS releases the lock. But I can still query those tables using NOLOCK hint. Is this possible SSIS will lock only the rows that it insert/update/delete etc? So that other user can still use that table or another instance of same SSIS Package can load data into those tables? My Package: In the package level I have TransactionOption = Required. The Sequence (Data Flow is inside this sequence) TransactionOption = Supported. I had some issue in my package that I posted here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/dfb5a8b9-d43c-452b-bb21-d6aea192fc97 and also resolved. Now I descovered this issue and trying to resolve. Thanks, Prabhat
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend