Delete Old Reports Saved In Shared Folder

Nov 16, 2007



Hi All,

I subsricbe few reports by data driven file shared method. Each reports is supposed to be delivered to 5 different customers. But each customer can see only his/her data. So I use a paramter to generate 5 different reports for each customer. But once the five different reports are saved in the shared file folder, is there any method to delete old files? These reports are to be executed once a week

Thanks

View 2 Replies


ADVERTISEMENT

Not All The Reports Are Delivered To The Shared Folder

Nov 5, 2007



Hi All,

I'm delivering some reports through data driven to a shared folder in another computer in my network. In report manager, under status, it shows the following message.

Processing: 10 processed of 12 total; 0 errors.

When I chek in the folder, I can see sometimes only 6 reports. I rescheduled and run it again. Then I could see only 10 out of 12 reports.

I opened the Management Studio and tried to refreshed the report subscription under subscription. Then I got the following error message.

"

nvalid node. (Microsoft.SqlServer.SmoEnum)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.XPathExpression.Load(AstNode ast)
at Microsoft.SqlServer.Management.Smo.XPathExpression.Compile(String strXPathExpression)
at Microsoft.SqlServer.Management.Smo.Urn.get_XPathExpression()
at Microsoft.SqlServer.Management.Smo.Urn.Compare(Urn u1, Urn u2, CompareOptions[] compInfoList, CultureInfo cultureInfo)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.RebuildItem(INavigableItem item, Boolean applyItemParentFilter)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequeryProperties()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.Refresh(Boolean autoRefresh)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.Refresh()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.Refresh()



Even If see error log file, I can not see any file there. This is actually a file of the previous run.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__11_05_2007_11_29_11.log</Path>
<SystemName>DEV02</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!11/5/2007-11:29:12:: w WARN: WebServiceAccount is not specified in the config file. Using default: DEV02ASPNET
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.

ReportingServicesService!library!8!11/5/2007-11:29:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
Login failed for user 'ZOPAratnayake'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
--- End of inner exception stack trace ---
ReportingServicesService!library!8!11/5/2007-11:29:21:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
Login failed for user 'ZOPAratnayake'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

ReportingServicesService!library!4!11/05/2007-11:43:03:: Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share.
ReportingServicesService!notification!4!11/05/2007-11:43:03:: Notification 77fc9843-80f6-4392-9c26-3a84b087dafb completed. Success: True, Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 0
ReportingServicesService!dbpolling!4!11/05/2007-11:43:03:: NotificationPolling finished processing item 77fc9843-80f6-4392-9c26-3a84b087dafb
ReportingServicesService!library!4!11/5/2007-11:43:03:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!11/5/2007-11:43:03:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!library!d!11/05/2007-11:43:03:: Data Driven Notification for activation id 668b2d9c-d5ea-46e9-8efd-e2824e9a8c64 was saved.
ReportingServicesService!library!d!11/05/2007-11:43:03:: Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share.
ReportingServicesService!notification!d!11/05/2007-11:43:03:: Notification 5fa50ecb-1b0f-4e40-86c8-4c4700c4b820 completed. Success: True, Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 0
ReportingServicesService!dbpolling!d!11/05/2007-11:43:03:: NotificationPolling finished processing item 5fa50ecb-1b0f-

ReportingServicesService!library!d!11/05/2007-11:43:03:: Data Driven Notification for activation id 668b2d9c-d5ea-46e9-8efd-e2824e9a8c64 was saved.
ReportingServicesService!library!d!11/05/2007-11:43:03:: Status: The file "Members - Awaiting Approval_1.xls" has been saved to the "\derbyReports" file share.
ReportingServicesService!notification!d!11/05/2007-11:43:03:: Notification 3a282979-9cab-44fd-b4e8-a083558c494e completed. Success: True, Status: The file "Members - Awaiting Approval_1.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 0
ReportingServicesService!dbpolling!d!11/05/2007-11:43:03:: NotificationPolling finished processing item 3a282979-9cab-44fd-b4e8-a083558c494e
ReportingServicesService!subscription!4!11/05/2007-11:43:03:: System.IO.IOException: The process cannot access the file '\derbyReportsMembers - Awaiting Approval_1.xls' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data)
ReportingServicesService!subscription!4!11/05/2007-11:43:03:: Error writing file Members - Awaiting Approval_1.xls to path \derbyReports
ReportingServicesService!library!4!11/05/2007-11:43:03:: Data Driven Notification for activation id 668b2d9c-d5ea-46e9-8efd-e2824e9a8c64 was saved.
ReportingServicesService!library!4!11/05/2007-11:43:03:: Status: Failure writing file Members - Awaiting Approval_1.xls : The process cannot access the file '\derbyReportsMembers - Awaiting Approval_1.xls' because it is being used by another process.
ReportingServicesService!dbpolling!4!11/05/2007-11:43:03:: NotificationPolling finished processing item 09e28175-ce44-41cd-ab55-56199a58885f
ReportingServicesService!dbpolling!d!11/5/2007-11:43:03:: NotificationPolling processing item 41cfd72e-bda0-4e8f-87dd-a22789eb340f
ReportingServicesService!dbpolling!c!11/5/2007-11:43:03:: NotificationPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!4!11/5/2007-11:43:03:: NotificationPolling processing item 34e19ce1-b298-48e6-a2fc-b7637765968c
ReportingServicesService!subscription!11!11/05/2007-13:18:10:: Auto increment filename = Members - Awaiting Approval_5.xls
ReportingServicesService!subscription!11!11/05/2007-13:18:10:: System.IO.IOException: The process cannot access the file '\derbyReportsMembers - Awaiting Approval_5.xls' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data)
ReportingServicesService!subscription!11!11/05/2007-13:26:15:: Auto increment filename = Members - Awaiting Approval_11.xls
ReportingServicesService!library!11!11/05/2007-13:26:15:: Data Driven Notification for activation id 7bd68b9c-855f-4f2a-9482-43ac5f7c9589 was saved.
ReportingServicesService!library!11!11/05/2007-13:26:15:: Status: The file "Members - Awaiting Approval_11.xls" has been saved to the "\derbyReports" file share.
ReportingServicesService!notification!11!11/05/2007-13:26:15:: Notification 76aedee6-e860-4c60-aebc-2c3aeb854bed completed. Success: True, Status: The file "Members - Awaiting Approval_11.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 1
ReportingServicesService!dbpolling!11!11/05/2007-13:26:15:: NotificationPolling finished processing item 76aedee6-e860-4c60-aebc-2c3aeb854bed
ReportingServicesService!library!11!11/5/2007-13:29:12:: i INFO: Cleaned 0 batch records, 0 policies, 12 sessions, 0 cache entries, 12 snapshots, 36 chunks, 0 running jobs, 0 persisted streams




Here I did not post the whole error log, because its too long.
Does any one know why I can not deliver all the reports?

View 2 Replies View Related

Transferring Existing SSIS Packages Saved In A Shared Folder Location From Development Server To Live Server

Dec 20, 2007

Please can anybody help me in transferring existing SSIS Packages saved in a shared folder location from development server 2ED to Live server TWD1.
Both has SQL server 2005 running and has visual studio 2005
Currently about 25 SSIS packages are executed from the development server transferring data on Live server TWD1...these ETL process is called from development server but executed on live server.
Now the problem is when i call these packages from the shared folder from live server it crashes.....i need to changes something to shift the whole package to the live server..and execute on live server itself instead of recreating the whole 25 process from scratch.....also i use optimize for many tables ..and run in a single trancastion....so how can i see the mappings of source and destination tables.
 
Please let me know the process how i can achieve this.
Thanks
George
 

View 5 Replies View Related

Shared Datasource In Different Folder...

Jul 16, 2007

Hi all,



Ive tried searching but nothing came up specific to my problem.



I currently have all the reports separated into separate folders, such as Finance, HR etc, and the datasources in a datasources folder at the root level. My problem is that when i upload reports into their appropriate folder, the shared datasource information gets deleted, and i need to re-map it everytime.



Is there anyway to have the specific reports point to specific shared datasource folders on the report server when i upload them?



cheers



Rob.

View 1 Replies View Related

Accessing Files On A Shared Folder

Jan 7, 2008

can sql server 2005 access files on a shred folder (which sql 2000 was not able)?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

View 3 Replies View Related

Saved Reports - How Did They Do That?

Jun 2, 2008

I recently viewed an application which included customizable savable reports. In the first step, the user selects from a very large (probably over a hundred) set of variables to include in the report (these would be the columns displayed in the report). In a second step, the user selects (from the same set of variables) which variables they want to set as criteria indicators (these would then be dropdowns and text boxes on the report that would filter the query results).

So, how do they do this? Lets take the AdventureWorks database as an example. Lets say the user can select the following variables to include in their report:

Product.Name
Product.ProductNumber
Product.Color
Product.Size
Product.ListPrice
WorkOrder.StartDate
WorkOrder.EndDate
WorkOrder.OrderQty
PurchaseOrderDetail.DueDate
PurchaseOrderDetail.UnitPrice
PurchaseOrderDetail.OrderQty
Vendor.Name
Etc…

How do you design this in the database? If you have a table that holds all of the possible variables, and a table that connects the user-selected variables to the user – how then do you construct the query that pulls it all together? For example, what if a user wants only these two variables in their report:

Product.Name
Vendor.Name

Here is the query:

select p.name as ProductName, v.name as VendorName
from Production.Product as p
inner join Purchasing.ProductVendor as pv on pv.ProductID = p.ProductId
inner join Purchasing.Vendor as v on v.VendorId = pv.VendorId

How do you build that query from just getting two variable names?

View 1 Replies View Related

Add Existing Shared Folder To File Table

Jan 29, 2015

I need to add an existing shared folder to a SQL FileTable.So this is the path and I created a SQL Filetable and now I need to add it to the filetable.

View 0 Replies View Related

Reporting Services :: SSRS Using A Shared Folder

Sep 4, 2015

I am trying to create a basic report in SSRS, with 6 columns but then we receive an excel spreadsheet with different account numbers daily and I am requested to create a report based on those account numbers. so how can I create a shared folder for the users to drop their excel spreadsheet  there and make my SSRS only filter the result set based only on those account numbers?

View 5 Replies View Related

SQL 2012 :: Add Existing Shared Folder To File Table

Jan 29, 2015

I need to add an existing shared folder to a SQL FileTable. So this is the path and I created a SQL Filetable and now I need to add it to the filetable.

View 0 Replies View Related

To Access A Shared Folder Providing User Name And Password

Feb 17, 2008

Hi,

My code should copy files from a shared folder.
the share can be accessed by all who can provide a specified username and password.

I use the following code:
But where to specify username name password to access that folder?


DECLARE @cmdstr varchar(1000)

set @cmdstr = 'copy \servernamefoldername$ C:DataExTest'

print @cmdstr

EXEC xp_cmdshell @cmdstr

Any sort of help would be highly appreciated.

Thanks in advance


View 10 Replies View Related

Could Not Register Msxmlsql.dll Under Microsoft SQL Server/90/Shared Folder

Dec 18, 2006

Hi,

I'm trying to silently(quiet mode) install Sql Server 2005 and our application.I created a custom wrapper and included all the files and folders extracted from SQLEXPR.exe.

So when I execute this customized setup its throwing an error : Could not register Program Files/Microsoft SQL Server/90/Shared/msxmlsql.dll

If I ignore the above error its throwing similar errors for almost all the files under Program Files/Microsoft SQL Server/90/Shared folder.

kindly help me to resolve the issue.

Thanks & Regards

Krish

View 2 Replies View Related

Problem With Creating Directory By SQL Server On A Remote Shared Folder

Jul 18, 2006

Dear all,

I now have 2 server, say serverA and serverB. ServerA has a SQL server and I am using a command in the SQL server to access the serverB. The command is:

declare @command varchar(500)
set @command = 'mkdir ' + '"\serverBabckevin_wong123"
exit'
exec master.dbo.XYRunProc
'cmd.exe',
'c:',
@command

where abc is a shared folder in serverB which can be accessed by serverA. However the output of this execution is "c:> mkdir "\serverBabckevin_wong123" Access is denied". It is possible to do this in command prompt. Does anyone know what's the problem of this?

Thank you very much!!

Kevin

View 1 Replies View Related

Copy Reports From Other Users My Reports Folder

Aug 7, 2007

Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.

The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.


Is there a way to do this?

Thanks for your help.

View 3 Replies View Related

SQL Server 2008 :: Checking Files In A Shared Path If Folder Or File?

Jun 3, 2015

I wrote the below script to print all folders and files located in the share path. How to extend my script to mention by adding another column whether the file is a folder/file , sort of 0 or 1.

declare @chkdirectory1 varchar(4000) = 'shared_pathfolder';
declare @finalserver3 varchar(4000);
create table #tmp (directory_name varchar(4000))
SET @finalserver3 = '''"DIR ' + @chkdirectory1 + ' /B"''';
--select @finalserver3
--SELECT @finalServer
DECLARE @ExecCmd varchar(100)
--SELECT @ExecCmd = 'EXEC master.dbo.xp_cmdshell ' + char(50) + 'mkdir D:'+ CONVERT(varchar(8), getdate(), 112) + '' + char(50)
SET @ExecCmd = 'EXEC master.dbo.xp_cmdshell ' + @finalserver3
--SELECT @ExecCmd
exec(@ExecCmd)
drop table #tmp

View 0 Replies View Related

Integration Services :: Access A Remote File On Shared Folder SSIS

Sep 9, 2015

I have a package that need to copy a file from a remote server using path like  ipaddresssharedfolder..now, inside of Microsoft data tools, everything runs fine, because y access to those folders on the windows sessions and enter my credentials. however how to I set up the package to use my credentials on the remote server?  

Without it, I got error Executed as user: NT ServiceSQLAgent$RETAIL_PRO.and this user does not exists on remote server. so got access denied. error. 

View 4 Replies View Related

Integration Services :: Way Of Creating Shared Folder In Order To Perform Operation From Title

Apr 14, 2015

having on mind that this is my Target server: what is the way of creating shared folder in order to perform operation from the title (and, of course, to continue with installation of packages etc...)? SQL SERVER 2008 R2

View 26 Replies View Related

My Reports Folder Is Invisible

May 9, 2007

I am trying to locate the "My Reports" folder on the SSRS site, but I dont think I am able to see it. I am an admin on the box with Browser, Content Manager, My Reports roles.



I also tried creating the folder manually and it says the folder exists but I cant see it.



I have also checked on the "Site Settings" and checked the box "Enable My Reports". What else am I missing here?



Thanks,

sj

View 2 Replies View Related

Is It Possible To Have The .rds File In Reports Folder

Mar 13, 2007

Since i have 5 different projects all has the same kind of reports., but calling via 5 different sites all sites on same webserver.

The problem i have is the .rds file name is same in all 5 report projects and it is a shared datasource., now when i compile the report project it will not load or overwrite the .rds file since the name is same, for that reason i tried to have the .rds file in reports folder as a datasource not a shared datasource. but i tried to add it, after i create the datasource, it is automatically going into the shared datasource folder, how can i create a datasource not shared under reports folder.

Thank you very much for all your help and information.

View 3 Replies View Related

Can Not Find Reports Folder

Nov 5, 2007

Hi

I donn't see reportserver folder in my local host is there any wrong at instalation time ?

Thank you

View 3 Replies View Related

Reporting Services :: Unable To Run Scheduled Reports From SharePoint In Manage Shared Schedules

Jul 16, 2015

We are running into an issue where we are unable to run scheduled reports from SharePoint in the "Manage Shared Schedules" sections of any given site in our site collection (<site url>/_layouts/15/ReportServer/ScheduleList.aspx).  Reports are able to be generated manually, but never run when scheduled from SharePoint.We are encountering the following error in the SharePoint logs for our server.  

 Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException: , Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:

The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is '162'.;     Here is the background in our environment:

SharePoint App Server  - Server 2012 R2 running SharePoint 2013 Application server - running SSRS SharePoint Integrated configured through Central Admin.SharePoint SQL Server - Server 2012 R2 running SQL 2012 SP1 for the SharePoint farm - hosts the Reporting Services databases.I have run the script within the Central Admin > Provision Subscriptions and Alerts to give appropriate permissions the the account in use.  Also the reporting services databases were created new as part of the install, so they were not migrated from a previous version.

View 3 Replies View Related

How To Set The Path To The Reports Snapshots Folder?

Mar 15, 2007

We have a statutory requirement to keep 5 years of history, so I've checked the option in the Site Settings page in the Report Manager to "Keep an unlimited number of snapshots in report history". The drives are partitioned as follows:

C: -- OS; 20GB

D: -- Apps; 20GB

E: --Data: 160GB

I want to force the report history snapshots onto the data (E:) drive, but I can't figure out what setting will force them there. Can anyone tell me how to set the path to the reports snapshots folder?

View 1 Replies View Related

RS Webservice Delete Folder

Apr 21, 2008



Hi,

Is there any way to delete folder in reportserver using RS webservice API?
I know there is a method: DeleteItem ( Item As string )
But I tried it and it didn't work for folders.
Thanks


JY

View 1 Replies View Related

Inheritance Of Security Role In Folder Structure Of Reports

May 16, 2007

Hi,
I have a folder structure of reports like this
Home
|
/
A B

Now, suppose I have created this folder, A first and user, say A_User is given permission to view this folder. I am expecting this user to browse from 'Home' to A folder but as you know to browse folder 'Home' he must also be added to 'Home' folder . So I add him to 'Home' now.

The problem comes when I add new folder B, for user B_User. The moment I add this folder A_User is also added to folder B because of the inheritance of users to child folders.
So user A is able to see both A and B folder....and thats my problem, he is supposed to only A folder and not B

Is there any way to disable this inheritance feature ??
I tried deleting A_User from B with a script using "InheritParentSecurity" method of ReportingService but it says that it can not delete inherited users.

How can I fix the problem ? without need to manually delete users from folders ??/

thanks

prashant

View 3 Replies View Related

What Is The Solution For This Internal Error EnsureMyReportsExists: Users Folder Not Found When My Reports Accessed

Nov 1, 2007

Any help would be apprecaited....

aspnet_wp!library!1!11/01/2007-09:36:59:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., EnsureMyReportsExists: Users folder not found when My Reports accessed.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!11/01/2007-09:37:04:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!webserver!1!11/01/2007-09:37:04:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.


10/31/07 14:54:06, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x053F5860
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 14:54:06, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 14:54:10, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 14:54:10, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0001.mdmp
10/31/07 14:54:10, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:25:56, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E31E9C
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:25:56, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:25:59, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:25:59, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0002.mdmp
10/31/07 15:25:59, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:28:01, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E32A04
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:28:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:28:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:28:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0003.mdmp
10/31/07 15:28:04, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:29:31, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E3356C
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:29:31, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:29:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:29:34, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0004.mdmp
10/31/07 15:29:34, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:31:14, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E340D4
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:31:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:31:17, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:31:17, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0005.mdmp
10/31/07 15:31:17, ACTION, aspnet_wp.exe, Watson Invoke: No
10/31/07 15:37:52, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2160
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x07E34C3C
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
10/31/07 15:37:52, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
10/31/07 15:37:54, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
10/31/07 15:37:54, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0006.mdmp
10/31/07 15:37:54, ACTION, aspnet_wp.exe, Watson Invoke: No
11/01/07 09:37:01, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 260
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
11/01/07 09:37:01, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
11/01/07 09:37:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/01/07 09:37:04, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFilesSQLDmpr0007.mdmp
11/01/07 09:37:04, ACTION, aspnet_wp.exe, Watson Invoke: No

View 6 Replies View Related

Error Processing Resource 'http://localhost/reports/Pages/Folder.aspx'

Jul 22, 2006

Hi all

After deploying my report on the report Server, I try to access it on the browser which gives me the following error.

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


A name was started with an invalid character. Error processing resource 'http://localhost/reports/Pages/Folder.aspx'. Line...<%@ Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.ReportingServices.UI.Folde...




How can I trouble shoot this error.?

Please help me out.

Thanx in advance.

Ronald

View 7 Replies View Related

SQL Server 2008 :: Can Delete Contents Of Update-cache Folder

Sep 26, 2013

this directory is over 2gb

Program FilesMicrosoft SQL Server100Setup BootstrapUpdate Cache

can you delete the contents safely?

View 1 Replies View Related

Where Are The SSI Files Saved When Saved To The Server?

Apr 20, 2006

This is a pretty simple question, but I'm going nuts trying to find the answer. After creating an SSI package, I told it to save to the SQL server... Now where do I go to pull that package up again and make changes and/or execute the package?

View 4 Replies View Related

Reporting Services :: Unable To Delete Reports

Apr 20, 2015

We have created and scheduled some test reports via Idera performance tool but we are unable to delete the reports. These are not custom reports and reports created with Schedule Email option in Idera. Unfortunately, I dera does not have any option to delete these reports and support is asking me if I tried this by deleting from SQL Server Reporting Services.I looked at the Reporting services but can't find any place to delete these reports. This link does not provide any support because I don't have these (Or Report Manager)----> Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services.

URL....All I have is "Reporting Services Configuration Manager" under "Configuration Tools". How can I delete these reports from SQL Server Reporting services ?. Can I delete them from some tables in Reports databases ?. If so, what are the tables ?. I delete the jobs from SQL Server but the jobs are automatically created the next day emailing the reports again..

View 3 Replies View Related

Unable To Copy App_data Folder Databases On Production Server To A Different Folder Or Location

Sep 19, 2007

I dont alot about sql server 2005(Express edition). For debugging purposes i want to copy  the whole app_data folder(.mdf & .log files) on the production server to another folder on the same machine(or sometimes to a network folder).  So when i copy and try to paste this App_data folder to a new location, i get this error message
"cannot copy ASPNETDB: it is being used by another person or program. close any programs that might be using the file and try again."
After reading the above message, i close visual web developer, stop the website in IIS and stop the SQLExpress service on the server and try again but still get the same message.
So how can i make sure that all the programs accessing these database files are closed such that i'm able able to copy them to a different location.

View 2 Replies View Related

Integration Services :: SSIS WMI Event Watcher Check For New Folder In Existing Folder

Jul 2, 2015

I know a WMI event watcher can be used to watch for a new file being added to a folder. However, I need to check for new folders being added to an existing folder. I haven't been able to find a post on doing this. Is there a way in WQL to check for a new folder being added instead of a new file? I've used SQL for years, but am new to SSIS.

View 2 Replies View Related

SSIS Or SQl Agent Job Moving From A Network Folder To A Sharepoint Folder - Errors...

Oct 31, 2007



Ok,

I have a network folder called A

I have a SharePoint (2007) Document Library site called B. Web Client is enabled on the server and B is mapped as a Drive (let's call it Y for this discussion)

I want to move documents in A to B. Easy enough, right? Not so....

I first started by creating a batch file that issues a COPY \A \Y /Y at the command prompt. Viola! Worked Great!

I then moved that command to a SQL Agent job as a CMDExec statement (exact same statement) and attempted to run it.....CRASH! It found the files in A but then said "The system cannot find the path specified"

Ok, so I tried it in SSIS. CRASH! Checked the error log. Same thing...

So I then checked the account under which the SQl Agent was running (special domain account for all our SQL Servers). Thinking it might mater I changed it to run under my name (I'm in Domain admin). I also ensured I had permissions to the SPS 2007 library as well. (I did).

Ran again! CRASH! Same error....

So, I created a batch file , placed thec ommand in the batch file and ran that from the command prompt! Viola! Worked Great.

So, I was thinking of how ingenious I was as I pasted my C:RootCopy.bat into my SQL Agent job. With a big grin on my face I right clicked and picked "Start Job at step".......CRASH! Same error.

Does anyone have any ideas on this ???????????????

Thanks,
Stephen

View 3 Replies View Related

Can I Use The Foreach Loop To Obtain The Sub Folder Names Within A Folder?

Sep 4, 2006

I have a set of folders with the following structure:

MainFolder

1999

SpreadsheetA.xls

SpreadsheetB.xls

SpreadsheetC.xls

2000

SpreadsheetA.xls

SpreadsheetB.xls

SpreadsheetC.xls

etc.

Is there a way that I can use the foreach loop container to loop the sub folders? My plan was to get the folder name and path into a variable, use this to build the connection string for each file in this folder, carry out the upload for that folder, then move onto the next folder and do the same thing, but I cannot see a way to do this.

Thanks,

Sam

View 2 Replies View Related

Moving Csv File From One Folder To Another Folder

Mar 28, 2008

I am having problem with moving a file from one folder to another folder. Here is the detailed scenario:

I want to move a input.csv file from shared input folder to shared archive folder. i am using the below code to do this.
declare @inpath varchar(100)
SET @inpath = 'move "\abcdefINPUTinput*.csv" "\abcdefARCHIVEarchive.csv"'
EXEC @filestatus = master..xp_cmdshell @inpath
but the problem was it was cutting the input.csv file from INPUT folder but not pasting it in the ARCHIVE folder.
I really appreciate if anyone can help me to solve this or anyone can tell some workarounds.

Thanks,

View 20 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved