berbagisolusi
sqlserver2005
Remote Access Reporting Service (Setting Role Reporting Service SQL Server 2005)
WINDOWS XP & 2003 SERVER a. Run cmd.. type “inetmgr” b. Disable Anonymous Access in Reports&ReportServer Virtual Directory c. Goto IE Browser, and type http://localhost/reports > Properties Tab > Security d. Add new Role Assigment for NT AUTHORITY\IUSR or IUSR_<COMPUTERNAME> e. Enable Anonymous Access in Reports&ReportServer Virtual Directory f. Restart SQLSERVER service. WINDOWS 7 & 2008 SERVER a. … Continue reading
SSIS The exit codes values
Executing an SSIS package from within a stored procedure is not an uncommon request. People sometimes scratch their head when it comes to figuring out if that package ran successfully or not though. There may be a process that runs a stored procedure and kicks off a certain SSIS package depending on the situation. Maybe there are parameters … Continue reading
Error SSIS Variable (Cannot assign value to variable): The result of the expression “_” on property “Executable” cannot be written to the property. The expression was evaluated, but cannot be set on the property.
Stack error assign value to SSIS paramter via ASP.NET or batch file. Yesterday I’m stack in Execute Process Task to execute Batch file, that batch is setting of SSIS execute. The First solution, 1. restart your IIS (if using ASP.NET) always restart your IIS after changed the SSIS component and properties value 2. Change variable properties … Continue reading
Web Statistic
berbagisolusi 