|
Home > Archive > MS SQL XML > October 2005 > Importing Reporting Services RDL files into database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Importing Reporting Services RDL files into database
|
|
|
| I am trying to import RS RDL files using SQLXMLBulkload. I am currently
trying this from a DTS package ActiveX script task as follows:
Set objBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objBulkLoad.ConnectionString =
"provider=SQLOLEDB. 1;SERVER=P19864L;UID
=fdfd;PWD=fdsfs;DATA
BASE=RDL"
objBulkLoad.KeepIdentity = False
objBulkLoad.SchemaGen = True
objBulkLoad.BulkLoad = True
objBulkLoad.Execute " c:\sql\ReportDefinit
ion.xsd", "c:\sql\report.rdl"
Set objBulkLoad = Nothing
I am getting my ReportDefinition file from
"http://servername/reportserver/reportdefinition.xsd". Whenever I run the
Active X script task, I get the error: "schema: relationship expected on
DataSource"
Any ideas???
| |
| Bertan ARI [MSFT] 2005-10-27, 9:26 am |
| Have you specified the annotations in your XSD file? If you haven't, check
out this link for information on sqlxml annotations:
http://msdn2.microsoft.com/en-us/library/ms205984
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"DBA72" <DBA72@discussions.microsoft.com> wrote in message
news:8001B02B-36A6-455C-9DA7- 16611ABA97D2@microso
ft.com...
>I am trying to import RS RDL files using SQLXMLBulkload. I am currently
> trying this from a DTS package ActiveX script task as follows:
>
> Set objBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
> objBulkLoad.ConnectionString =
> "provider=SQLOLEDB. 1;SERVER=P19864L;UID
=fdfd;PWD=fdsfs;DATA
BASE=RDL"
>
> objBulkLoad.KeepIdentity = False
> objBulkLoad.SchemaGen = True
> objBulkLoad.BulkLoad = True
>
> objBulkLoad.Execute " c:\sql\ReportDefinit
ion.xsd", "c:\sql\report.rdl"
> Set objBulkLoad = Nothing
>
> I am getting my ReportDefinition file from
> "http://servername/reportserver/reportdefinition.xsd". Whenever I run the
> Active X script task, I get the error: "schema: relationship expected on
> DataSource"
>
> Any ideas???
>
|
|
|
|
|