Recent content by bmann

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...