Click here to Skip to main content
14,425,525 members
   

Database

 
GeneralRe: Can't get my 2nd table working Pin
piano00112-Jun-18 16:41
Memberpiano00112-Jun-18 16:41 
GeneralRe: Can't get my 2nd table working Pin
piano00112-Jun-18 16:42
Memberpiano00112-Jun-18 16:42 
QuestionError in Restoring SQL Server Backup of v 2012 to v 2008 Pin
indian1431-Jun-18 12:14
Memberindian1431-Jun-18 12:14 
AnswerRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
Victor Nijegorodov1-Jun-18 21:46
MemberVictor Nijegorodov1-Jun-18 21:46 
AnswerRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
Eddy Vluggen2-Jun-18 1:21
mveEddy Vluggen2-Jun-18 1:21 
GeneralRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
indian1434-Jun-18 7:10
Memberindian1434-Jun-18 7:10 
GeneralRe: Error in Restoring SQL Server Backup of v 2012 to v 2008 Pin
Eddy Vluggen4-Jun-18 8:08
mveEddy Vluggen4-Jun-18 8:08 
QuestionA Control flow Task is appearing in the SSIS Packages xml even after disabling and the deleting it. Pin
indian14331-May-18 14:34
Memberindian14331-May-18 14:34 
Hi,

I have a Contolflow Task in my SSIS Package, which sends Emails, and because we don't need it and msdb.dbo.sp_send_dbmail is disabled on our SQL Server, I have first disabled the Controlflow task that sends Email using msdb.dbo.sp_send_dbmail (basically Execute SQL Task).
It was working fine on my local machine, when I deployed the Package on to a Server as SQL Agent Job, Job didn't execute threw error. Then I disabled the Email task on Package deployed it again, but surprisingly, Job is giving the same error as " msdb.dbo.sp_send_dbmail is disabled"

Then I completely deleted the Task and deployed again, still it is giving me the same error, to check when I opened the Package in notepad the task still showing.

Is there any way we can completely get rid of the task from SSIS Package, any help would be very helpful - thanks in advance.

Thanks,

Abdul Aleem

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

QuestionThe following Query is taking too long to execute Pin
indian14330-May-18 14:33
Memberindian14330-May-18 14:33 
SuggestionRe: The following Query is taking too long to execute Pin
CHill6031-May-18 3:53
mveCHill6031-May-18 3:53 
GeneralRe: The following Query is taking too long to execute Pin
indian14331-May-18 14:26
Memberindian14331-May-18 14:26 
GeneralRe: The following Query is taking too long to execute Pin
Eddy Vluggen1-Jun-18 1:10
mveEddy Vluggen1-Jun-18 1:10 
QuestionGraph Database vs Dimensional Pin
DADom24-May-18 22:32
MemberDADom24-May-18 22:32 
AnswerRe: Graph Database vs Dimensional Pin
Eddy Vluggen26-May-18 3:45
mveEddy Vluggen26-May-18 3:45 
GeneralRe: Graph Database vs Dimensional Pin
John 1356415428-Jun-18 10:07
MemberJohn 1356415428-Jun-18 10:07 
GeneralRe: Graph Database vs Dimensional Pin
Eddy Vluggen28-Jun-18 10:19
mveEddy Vluggen28-Jun-18 10:19 
QuestionHow to create a insert trigger on just one table? Pin
Member23622-May-18 0:02
MemberMember23622-May-18 0:02 
QuestionRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 2:34
mveCHill6022-May-18 2:34 
AnswerRe: How to create a insert trigger on just one table? Pin
Richard Deeming22-May-18 3:30
communityengineerRichard Deeming22-May-18 3:30 
AnswerRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes22-May-18 15:09
MemberMycroft Holmes22-May-18 15:09 
GeneralRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 23:56
mveCHill6022-May-18 23:56 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 14:20
MemberMycroft Holmes23-May-18 14:20 
GeneralRe: How to create a insert trigger on just one table? Pin
Member23623-May-18 0:04
MemberMember23623-May-18 0:04 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 14:23
MemberMycroft Holmes23-May-18 14:23 
QuestionFOR XML PATH is not creating Child elements if they are coming with null values Pin
indian14316-May-18 13:39
Memberindian14316-May-18 13:39 

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.