Reporting Services and Programming - Learning SQL Server Reporting Services 2012 - page 446

dim parentPath as string
parentPath="/Data Sources"

dim extension as string="SQL"
definition.CredentialRetrieval = CredentialRetrievalEnum.
Integrated
definition.ConnectString ="DataSource=HODENTEKWin7\NJ;Initial
Catalog=Northwind;Integrated Security=True"
definition.Enabled = True
definition.EnabledSpecified = True
definition.Extension = extension
definition.ImpersonateUser = False
definition.ImpersonateUserSpecified = True
'Use the default prompt string.
definition.Prompt = Nothing
definition.WindowsCredentials = False

Try
rs.CreateDataSource(dsname,parentPath, False, definition,
Nothing)
Console.WriteLine("Data source {0} created successfully",
dsname)

Catch e As Exception
Console.WriteLine(e.Message)
End Try
This is the data source created on the Report Server.
End Sub

2. pen the command prompt and type the following:

C:\rs -i rsDataSource.rss -s "http://hodentekwin7/ReportServer_HI

3. Open a command prompt and type the following:
C:\rs -i rsDataSource.rss -s "http://hodentekwin7/ReportServer_HI