Click here to Skip to main content
15,920,603 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL 2012 Restore Problem Pin
Kevin Marois21-Dec-16 6:02
professionalKevin Marois21-Dec-16 6:02 
Questionerror occurred while enabling mars for this connection Pin
Travelthrprog18-Dec-16 7:56
Travelthrprog18-Dec-16 7:56 
AnswerRe: error occurred while enabling mars for this connection Pin
Eddy Vluggen21-Dec-16 4:52
professionalEddy Vluggen21-Dec-16 4:52 
QuestionTrying to access ReadWrite and ReadOnly variables in Script Component's ProcessInputRow Pin
indian14310-Dec-16 14:35
indian14310-Dec-16 14:35 
QuestionJet OLE, multiple joins with a union, missing an operator or brackets Pin
jkirkerx9-Dec-16 6:16
professionaljkirkerx9-Dec-16 6:16 
AnswerRe: Jet OLE, multiple joins with a union, missing an operator or brackets Pin
Eddy Vluggen9-Dec-16 7:08
professionalEddy Vluggen9-Dec-16 7:08 
GeneralRe: Jet OLE, multiple joins with a union, missing an operator or brackets Pin
jkirkerx13-Dec-16 9:14
professionaljkirkerx13-Dec-16 9:14 
QuestionRun SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 9:05
indian1436-Dec-16 9:05 
Hi,

I have and SSIS Package, my lead wants me to create a C# application that sets Variables, Connections and everything properly and executes the package, I did that, I even have written OnError event and logged the Error why SSIS failed to execute. As far I saw there is no difference between my Application and SQL Job. In fact my Application is logging every detail and placing all details as I am logging many things and its priority based logging means logs depending upon the Environment. But just asking, is it good Idea to write my own Application or did I do wrong?

My lead wanted to do it this way because there are many SSIS packages and because the SQL jobs they are running sometimes same time and creating lot of mess. But my application does it synchronously and it combines this synchronous process with another Asynchronous process of FileSystemWatcher, which keeps a record into the Database when file is dropped and then my App would take those details of path etc sets the connections and variables then calls the SSIS packages Synchronously and kills the execution of SSIS package if its taking too long. All these features are implemented by using C# code, if anybody has better advise please let me know their opinions.

Just want to calculate pros and cons from some other developers just to check my process, in fact I believe all Programmers are always learners Smile | :) .
Thanks,

Abdul Aleem

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

AnswerRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
ZurdoDev6-Dec-16 10:10
professionalZurdoDev6-Dec-16 10:10 
GeneralRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 10:51
indian1436-Dec-16 10:51 
AnswerRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
CHill606-Dec-16 13:19
mveCHill606-Dec-16 13:19 
GeneralRe: Run SSIS Package using Microsoft.SqlServer.Dts.Runtime or Sql Server Jobs Pin
indian1436-Dec-16 14:07
indian1436-Dec-16 14:07 
QuestionJoin or the nomemclature for join using EF in c# Pin
jkirkerx28-Nov-16 12:14
professionaljkirkerx28-Nov-16 12:14 
QuestionRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming29-Nov-16 2:13
mveRichard Deeming29-Nov-16 2:13 
AnswerRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 6:52
professionaljkirkerx29-Nov-16 6:52 
AnswerRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 7:48
professionaljkirkerx29-Nov-16 7:48 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming29-Nov-16 9:21
mveRichard Deeming29-Nov-16 9:21 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 10:58
professionaljkirkerx29-Nov-16 10:58 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx29-Nov-16 11:12
professionaljkirkerx29-Nov-16 11:12 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming30-Nov-16 2:10
mveRichard Deeming30-Nov-16 2:10 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
indian1436-Dec-16 11:43
indian1436-Dec-16 11:43 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx6-Dec-16 12:08
professionaljkirkerx6-Dec-16 12:08 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
indian1436-Dec-16 14:11
indian1436-Dec-16 14:11 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx7-Dec-16 6:58
professionaljkirkerx7-Dec-16 6:58 
QuestionRecommendations on nosql for embedded Pin
LasseL28-Nov-16 4:04
LasseL28-Nov-16 4:04 

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.