Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dr223
Constraint Violating Yak Guru
444 Posts |
 Posted - 2011-09-06 : 07:08:12
|
| Hi, I have an application I developed in .Net and connecting to SQL Server 2005, the application unzips files and updates tables in the database in SQL server. I had the application on my harddisk and run the application and it worked fine.. Tried a number of times and satisfactory results. Now, I published the application and launched it to the server then used the following guidelines as to the blog below to setup an SSIS package reading the executable file.. http://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.htmlThe problem is on this SSIS the process after executing the executable file is not terminated or there is a process still running.. This is because when I execute the SSIS for the firs time then it unzips the file and updates the tables on the database successfully.. The second time I execute the application I receive the error " Microsoft. Net FrameworkUnhandled exception has occurred in your application. If you clikc Continue, the application will ignore and attempt to continue. If you click Quit, the application will close immediately. The process cannot access the file 'G:\ZippingUtility\ZippedFolders\test1.zip' because it is being used by another process' No one is in the Server except me, no one is using the database except me.. This application works fine on its own ONLY when I use the procedure to set the SSIS I receive the error.. Any help please |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-06 : 07:22:26
|
| are you clearing out variables etc values from your application once you've used it? do you have any variables created in ssis for holding filepath?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2011-09-06 : 07:41:11
|
| Yes I do have one variable - How can I clear it? Or even more easily done maybe, I have a setup.exe (published application)... Is it possible to set a scheduler to execute this application daily instead of using the package ot you reckon the SSIS is much better to be set as a scheduler ofcourse when the variable is cleared? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-06 : 08:01:06
|
| no need to use ssis just for scheduling sakeyou can call application via t-sql step using xp_cmdshell extended procyou can add a sql agent job which calls the t-sql step and schedule it to be executed periodically as per your schedule------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2011-09-06 : 08:02:40
|
| Woow, thnaks Visakh16 - do have any sort of guidelines/procedure how to can create such a scheduler that will be fantastic Many thank |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SSIS Package