I have a job which should exe3cute the stored procedure, when I execute the job with "run as user" in job properties, I got the error message like below. But when I empty the "run as user" it work fine to execute the job. what is wrong here ?
Executed as user: domian1\kamry. Cannot find the object "%" because it does not exist or you do not have permissions. [SQLSTATE 42000] (Error 1088). The step failed.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…