1
vote
1answer
49 views

debugging an ssis package which is invoked from a .net application?

can we attach a debugger to an SSIS package which is invoked to execute from a .net assembly?
2
votes
1answer
119 views

Getting conversion error, for value that doesnt exist in database [closed]

I am running this query: SELECT thirdpid , ea.Empid , ea.Empname , em.RsCode , em.CustomerName AS 'RS Name' , SUM(CASE WHEN ea.Present=1 THEN 1 ELSE 0 END) AS 'Present days' ...
0
votes
0answers
85 views

Debugging\Profiling CONTEXT_INFO

i have a problem with CONTEXT_INFO in SQL Server 2008. My problem is identical to this question: Why is my CONTEXT_INFO() empty? We use CONTEXT_INFO to store the application user in it and the use ...