Click here to Skip to main content
15,867,686 members
Home / Discussions / Database
   

Database

 
AnswerRe: I need some help from my fellow developers... Pin
Richard MacCutchan12-Jan-17 4:19
mveRichard MacCutchan12-Jan-17 4:19 
GeneralRe: I need some help from my fellow developers... Pin
Steve Naidamast12-Jan-17 5:08
professionalSteve Naidamast12-Jan-17 5:08 
Questionvb.net, select where statement Pin
jkirkerx5-Jan-17 8:12
professionaljkirkerx5-Jan-17 8:12 
AnswerRe: vb.net, select where statement Pin
Wendelius5-Jan-17 8:30
mentorWendelius5-Jan-17 8:30 
GeneralRe: vb.net, select where statement Pin
jkirkerx5-Jan-17 8:39
professionaljkirkerx5-Jan-17 8:39 
GeneralRe: vb.net, select where statement Pin
Wendelius5-Jan-17 8:47
mentorWendelius5-Jan-17 8:47 
GeneralRe: vb.net, select where statement Pin
jkirkerx5-Jan-17 9:17
professionaljkirkerx5-Jan-17 9:17 
QuestionSSIS Excel connection is creating another temporary file and interfering with the FileSystemWatcher Pin
indian1434-Jan-17 8:39
indian1434-Jan-17 8:39 
Hi All,

I have a File System Watcher, which is monitoring file drops and renaming etc, which keeps the file information into a table, I have another application which executes the file related SSIS packages, and these two applications are Asynchronous. The problem is the Excel Connection Manager in the SSIS Package, when its reading the files, its creating another temporary file which is unnecessarily creating a record in the table. Can anybody please help me in how to overcome this scenario, I did a little bit by keeping a file exists check in the SSIS package that if the file exists or file already ran I am not going to run the package again on the File but still a record entry would be there on the monitors table which comes because of the Excel connection manager opening and reading the File.

Any help would be very helpful, a code snippet, a link or suggestion anything helps, thanks in advance Smile | :)
Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

SuggestionRe: SSIS Excel connection is creating another temporary file and interfering with the FileSystemWatcher Pin
David Mujica4-Jan-17 9:44
David Mujica4-Jan-17 9:44 
GeneralRe: SSIS Excel connection is creating another temporary file and interfering with the FileSystemWatcher Pin
indian1434-Jan-17 10:58
indian1434-Jan-17 10:58 
Questiondoubt in logical schema of database Pin
Member 129343424-Jan-17 3:19
Member 129343424-Jan-17 3:19 
AnswerRe: doubt in logical schema of database Pin
Afzaal Ahmad Zeeshan4-Jan-17 3:42
professionalAfzaal Ahmad Zeeshan4-Jan-17 3:42 
AnswerRe: doubt in logical schema of database Pin
Richard MacCutchan4-Jan-17 5:01
mveRichard MacCutchan4-Jan-17 5:01 
GeneralRe: doubt in logical schema of database Pin
Eddy Vluggen4-Jan-17 7:02
professionalEddy Vluggen4-Jan-17 7:02 
GeneralRe: doubt in logical schema of database Pin
Richard MacCutchan4-Jan-17 22:04
mveRichard MacCutchan4-Jan-17 22:04 
QuestionMySql - No results from query with WHERE Pin
BobbyStrain2-Jan-17 16:44
BobbyStrain2-Jan-17 16:44 
AnswerRe: MySql - No results from query with WHERE Pin
Mycroft Holmes2-Jan-17 20:45
professionalMycroft Holmes2-Jan-17 20:45 
GeneralRe: MySql - No results from query with WHERE Pin
Jörgen Andersson2-Jan-17 22:56
professionalJörgen Andersson2-Jan-17 22:56 
GeneralRe: MySql - No results from query with WHERE Pin
Mycroft Holmes3-Jan-17 10:29
professionalMycroft Holmes3-Jan-17 10:29 
AnswerRe: MySql - No results from query with WHERE Pin
Bernhard Hiller2-Jan-17 21:01
Bernhard Hiller2-Jan-17 21:01 
GeneralRe: MySql - No results from query with WHERE Pin
BobbyStrain3-Jan-17 4:30
BobbyStrain3-Jan-17 4:30 
QuestionDelete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx28-Dec-16 13:04
professionaljkirkerx28-Dec-16 13:04 
AnswerRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
CHill6029-Dec-16 3:59
mveCHill6029-Dec-16 3:59 
GeneralRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx29-Dec-16 7:04
professionaljkirkerx29-Dec-16 7:04 
AnswerI got this working partially, but can't figure out why I can't delete by Invoice Number Pin
jkirkerx29-Dec-16 8:07
professionaljkirkerx29-Dec-16 8:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.