Search results for query: *

How can I make a copy of an SSRS Report history snaphot to another folder in Report Manager. I have a report that has history snapshots. But want a copy of the report snapshot history in another folder for users to view easier in Report Manager. I would appreciate anyone's help.

Hello I am having Problems Saving VS 2008 analysis services Properties Deployment Options. I configure Dev, Test and Staging Environments on the Properties Deployment configuration page. You get their by right clicking project. You close project and open project again. Right click project and...

Hello SQLBill, I also ran your script and had 400 for max worker threads SSIS subsystem thanks Brian

Hello SQLBill, The max worker thread on my server is 512. I ran this script below: select max_workers_count from sys.dm_os_sys_info Is this a low number or should I increase more. The SSIS package running under sql server agent can only process up to 25 excel files without hanging. If I go...

My SSIS 2008 R2 package processing 55 excel files successfully in BIDS, but when I run the SSIS pacakge under Sql Serve Agent the job hangs with about 25 excel files processed. I notice their were a 15 excel.exe processes in the Windows Task Manager Processes tab. Does anyone have a solution? I...

Thanks SQLBill for all your help. It works now. Have a great day.

Hello SQLBILL, Thanks for responding back. My environment is SSIS 32 bit and SQL Server Db 64 bit. Their is a selection within sql server agent job that runs SSIS package in 32 bit mode. I already have that selected. But still get error above. If any suggestions please let me know. Thanks

I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIS package i get an error. Please let me know if you have any questions. thanks. Error is below: Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL Server...

I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIS package i get an error. Please let me know if you have any questions. thanks. Error is below: Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL Server...

Hello TomKane, I made some tweaks and got this new error: Executed as user: SCONET\svc_BIGCCDEV84_SSA. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:11:38 AM Error: 2012-04-21...

Hello TomKane, Yes \\SCONET\Data\SCO\Group\LGCR Files For Upload\ is accessible by sql server agent. I don't have access to those permissions but my network unit says the service account that sql server agent uses has access. Are their any other solutions to this problem? I appreciate all your...

Thanks TomKane. But still not working My server is Windows 2008 Server R2 Data Center edition, Excel 2007 and SQL Server 2008 R2 Enterprise edition. I have a SSIS package that runs successfully in business intelligence development studio but fails to run under sql server agent as a job. The...

I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIs package i get an error. Please let me know if you have any questions. thanks. Error is below: Message Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL...

Hello, I keep getting error thrown by connections collection when the specific element is not found in my ssis package. I recreated my connection managers and still the same problem. Problem points to SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}". Here is the problem in XML below...

Hello, I keep getting error thrown by connections collection when the specific element is not found in my ssis package. I recreated my connection managers and still the same problem. Problem points to SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}". Here is the problem in XML below...

Hello anyone, I open up reporting services configuration manager. I click report manager url and a windows security dialogue box displays. when I type credentials it works. But I need to click report manager url and go directly to report manager using IE. I would appreciate anyone's help. Thanks

Hello mrdenny, Thanks for the info. I added the account that the SQL Agent uses to the folder with the logs. Applied the full rights and everything worked. It's amazing that this error does not show anything in the event viewer logs. Either way I appreciate all your help!!!! You are a...

Hello mrdenny, I have been looking in the event viewer while trying to start sql server agent. The only error i get is this one below: The SQL Server Agent (MSSQLSERVER2011) service entered the stopped state I also cannot generate a new SQLAGENT.OUT file. The main error I always get is the...

Hello gmmastros, When I try to start SQL Server Agent their is no error logs generated except the dialog box that pops up showing the error I posted before. That's it. Here is a sql Server log, But it does show anything with SQL Server Agent. Here it is below: 2011-10-24 17:45:43.07 Server...

Hello SQLBill, I have started SQL Server Agent through Windows services, Command line, Sql Server configuration manager and using Sql Server management Studio. None of it works. I also cannot start Analysis Services. I would appreciate your info. This is the only error generated by starting SQL...