Export (0) Print
Expand All
Expand Minimize

ReportingService2006.CreateDataSource Method

Creates a new data source in a SharePoint library.

Namespace:  ReportService2006
Assembly:  ReportService2006 (in ReportService2006.dll)

public CatalogItem CreateDataSource(
	string DataSource,
	string Parent,
	bool Overwrite,
	DataSourceDefinition Definition,
	Property[] Properties
)

Parameters

DataSource
Type: String
The name for the data source including the file name and extension (.rsds).
Parent
Type: String
The fully qualified URL for the parent folder that will contain the data source.
Overwrite
Type: Boolean
A Boolean expression that indicates whether an existing data source with the same name in the location specified should be overwritten.
Definition
Type: ReportService2006.DataSourceDefinition
A DataSourceDefinition object that describes the connection properties for the data source.
Properties
Type: ReportService2006.Property[]
An array of Property objects that defines the property names and values to set for the data source.

Return Value

Type: ReportService2006.CatalogItem
A CatalogItem object for the newly created data source.

The table below shows header and permissions information on this operation.

SOAP Headers

(In) TrustedUserHeaderValue

(Out) ServerInfoHeaderValue

Required Permissions

Creating a new data source: AddListItems on Parent

Updating an existing data source: EditListItems on DataSource

If the .rsds extension is excluded from the data source name, an rsFileExtensionRequired error will be returned. If an .odc extension is given, an rsNotSupported error is returned.

If errors occur, the data source is not created.

The length of the Parent parameter cannot exceed 260 characters; otherwise, a SOAP exception is thrown with the error code rsItemLengthExceeded.

The Parent parameter cannot be null or empty or contain the following reserved characters: : ? ; @ & = + $ , \ * > < | . ". You can use the forward slash character (/) to separate items in the full path name of the folder, but you cannot use it at the end of the folder name

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;

class Sample
{
    static void Main(string[] args)
    {
        ReportingService2006 rs = new ReportingService2006();
        rs.Url = "http://<Server Name>" + 
            "/_vti_bin/ReportServer/ReportService2006.asmx";
        rs.Credentials = 
            System.Net.CredentialCache.DefaultCredentials;

        string name = "AdventureWorks.rsds";
        string parent = "http://<Server Name>/Docs/Documents/";

        // Define the data source definition.
        DataSourceDefinition definition = new DataSourceDefinition();
        definition.CredentialRetrieval = 
            CredentialRetrievalEnum.Integrated;
        definition.ConnectString = 
            "data source=(local);initial catalog=AdventureWorks";
        definition.Enabled = true;
        definition.EnabledSpecified = true;
        definition.Extension = "SQL";
        definition.ImpersonateUserSpecified = false;
        //Use the default prompt string.
        definition.Prompt = null;
        definition.WindowsCredentials = false;

        try
        {
            rs.CreateDataSource(name, parent, false, 
                definition, null);
        }
        catch (SoapException e)
        {
            Console.WriteLine(e.Detail.InnerXml.ToString());
        }
    }
}

Community Additions

ADD
Show:
© 2014 Microsoft