Click here to Skip to main content
15,741,083 members

Comments by Kuthuparakkal (Top 200 by date)

Kuthuparakkal 11-Feb-19 13:07pm View    
Thank you ML
Kuthuparakkal 25-Jan-19 14:53pm View    
Microsoft.Office.Interop.Word.Application winword = new Microsoft.Office.Interop.Word.Application();
Document document = winword.Documents.Open(@".docPath");
//Save the document
object filename = @"c:\temp1.docx";
document.SaveAs2(ref filename);
document.Close(ref missing, ref missing, ref missing);
document = null;
winword.Quit(ref missing, ref missing, ref missing);
winword = null;
Kuthuparakkal 13-Oct-16 6:27am View    
You cannot delete both in 1 SQL Statement. You need to separate it out (ie 2 SQL Stmnt. If this is PK-FK style, then set Cascade on Delete so that if you delete from primary then it will be deleted from FK table...
Kuthuparakkal 1-Aug-16 0:19am View    
This may not be the very first error, please scan log again. I believe it's permission issue because if the pkg runs in VS it runs under your credentials, and when it runs under SQL Agent it runs under the credential used by "SQL Server Services"
Kuthuparakkal 30-Jun-16 7:16am View    
We may need a database priest to conduct this marriage....