import one table from one database to another database

if i have one table from database A, and i want to copy the table to database B, then how to do it in SQL server management studio express? is it i have to make sql query?

try

select * into databaseB.dbo.TableA
from databaseA.dbo.TableA

or go to database B and run

select * into TableA
from databaseA.dbo.TableA

This will not copy constraints only data.

if it will not work right click on database and from task select import or export and select source destination , table to copy and run created SSIS package.

|||

i don't try yet the query. anyway, i right click on the database but i don't find any task that saying select import or export?

|||

i don't try yet the query. anyway, i right click on the database but i don't find any task that saying select import or export?

|||

Right click on your database in Object Explorer and in menu select tasks and next import export, Sorry it does not work in Management studio express, nut if you have SP1 and integration developments studio installed you can do it inside it.

Import objects from SSAS to Business Intelligence Development Studio

Hi all,

Could anyone tell me how I can use Business Intelligence Development Studio to browse or even modify data source views, cubes, etc. on SSAS created by means other than the Studio?

Thanks,

hz

Two ways:

1. BI Dev Studio online mode:
Start BI Dev Studio . File->Open->Analysis Services Database.

2. Create new project based on the live version of the database.
Start BI Dev Studio . File->New Project and choose project type "Import Analysis Services 9.0 Database"

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward, your answer is very helpful. Thanks a lot!

If you don't mind, I have one more question regarding this.

If I modify the objects of SSAS by means other than BI Studio. Can BI studio detect these changes and modify its projects accordingly. This is a sort of the reverse process of project deployment.

hz

|||

Unfortunately the answer is: there is no easy way to compare an existing project to the live version of the database.

This is one of the things the next version of the product could be addressing.

For now there are several workarounds I can think of:

1. Export live version of the database into a new project and then use some sort of XML comparison tool to compare project files. Compare .dim files for dimensions, .cube file for cube definitions

2. Create a script of the live version of the database by using right click->Script Database as ... in the SQL Management studio.
And then compare the script to the script you get by running Deployment Wizard utility for your project.
Again you should be able to use XML compare to compare both scripts.

These are not perfect ways, but should give you some idea for extent of the changes done to your live database.

Hope that helps.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks again, Edward! You have offered all I need to know regarding this.

I use AMO to create and modify objects such as cubes, data mining structures. Without using BI Studio, it will be very difficult to check whether my code has created what I need. Now, I'll just import the objects to the studio each time I want to check them.

hz

Import objects from SSAS to Business Intelligence Development Studio

Hi all,

Could anyone tell me how I can use Business Intelligence Development Studio to browse or even modify data source views, cubes, etc. on SSAS created by means other than the Studio?

Thanks,

hz

Two ways:

1. BI Dev Studio online mode:
Start BI Dev Studio . File->Open->Analysis Services Database.

2. Create new project based on the live version of the database.
Start BI Dev Studio . File->New Project and choose project type "Import Analysis Services 9.0 Database"

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward, your answer is very helpful. Thanks a lot!

If you don't mind, I have one more question regarding this.

If I modify the objects of SSAS by means other than BI Studio. Can BI studio detect these changes and modify its projects accordingly. This is a sort of the reverse process of project deployment.

hz

|||

Unfortunately the answer is: there is no easy way to compare an existing project to the live version of the database.

This is one of the things the next version of the product could be addressing.

For now there are several workarounds I can think of:

1. Export live version of the database into a new project and then use some sort of XML comparison tool to compare project files. Compare .dim files for dimensions, .cube file for cube definitions

2. Create a script of the live version of the database by using right click->Script Database as ... in the SQL Management studio.
And then compare the script to the script you get by running Deployment Wizard utility for your project.
Again you should be able to use XML compare to compare both scripts.

These are not perfect ways, but should give you some idea for extent of the changes done to your live database.

Hope that helps.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks again, Edward! You have offered all I need to know regarding this.

I use AMO to create and modify objects such as cubes, data mining structures. Without using BI Studio, it will be very difficult to check whether my code has created what I need. Now, I'll just import the objects to the studio each time I want to check them.

hz

import flat file

I am trying to import a flat file using SQL Server Management Studio and am receiveing the error:

Error 0xc0202055: Data Flow Task: The column delimiter for column "Column 19" was not found.
(SQL Server Import and Export Wizard)

I would like to capture the rows that are causing the error and have the import continue. Am I able to edit the behavior somehow?

Thanks.

If I recall correctly; in one of the last steps of the import wizard you are asked to either execute the package immediately or to save it as a .dtsx file.

Chose to save it as a .dtsx files and the use BIDS to edit it according to your needs.

|||

Hi Rafael, thanks for responding. I get to the screen where it tells me that ' The package will be saved to the instance of the SQL Server Database Engine ...', but it doesn't allow me to choose the file extension. Yes, I'm very new at this.

Thank you again, I really appreciate your help.

|||

Hi, I was able to save the .dtsx file. Now on to BIDS.

Thanks.

|||

I've been trying to edit the package in BIDS but am not having success. I'm importing a flat file and am trying to write the records that do not get imported successfully to an error file. If anyone can help me out.....

Thanks.

|||

tantz wrote:

I've been trying to edit the package in BIDS but am not having success. I'm importing a flat file and am trying to write the records that do not get imported successfully to an error file. If anyone can help me out.....

Thanks.

You will have to tell us what you are not having success with first.|||

Well, I read that you can 'use the Error Output Page of the Flat File Source Editor dialog box to select error-handling options'. How do I do this? Thanks.

|||

tantz wrote:

Well, I read that you can 'use the Error Output Page of the Flat File Source Editor dialog box to select error-handling options'. How do I do this? Thanks.

On the data flow, you grab the red arrow of the flat file source and connect it to a destination (flat file, sql server, etc...)|||

Thanks Phil. I was able to connect it to a flat file, and am getting the same errors. Where can we find this file with the errors? Also, is there a way to make the package continue processing even when there are errors?

I really appreciate your time and help.

|||

Open the Flat file Source editor; go to the error output page and make sure all the values in Error and truncation columns are 'Redirect Row'. Tip You can Shift+ Select al of them and then use the 'Set this value to the selected Cells'. After doing that, make sure you connect the red arrow to a file or any other destination; so you can examine it later.

|||Hi, thanks for your reply.
I don't think I'm looking in the right place - can you tell me exactly how you're getting to the error output page. Thanks so much.|||When you double click on the flat file source, there is a button, "error output" or something like that.|||

Cool, I got it, but I still am not able to see the records. I've connected the flat file source with a red arrow 'flat file source error output'. What else am I missing? Anything with mappings? An error list is displayed at the bottom, but it has 0 errors, 0 warnings, 0 messages, but I know I am getting errors.

Thanks so much.

|||

Hi, I think I've worked out the error output, but I seem to have created a different problem. I am now getting a message 'cannot open the data file. the process cannot access the file because it is being used by another process'.

It's a .txt file. Nothing else is using it. I just ran something in SQL Server Management Studio using the same file and it works fine. Is it possible that I changed something in the .dtsx package when I was trying to get the error output to work?

If anyone can help me out -
Thanks.

Import Data in SQL Server 2005?

I'm using SQL Server 2005 Management Studio Express, and trying to import data from an Excel spreadsheet into a new table. I'm used to doing this through Enterprise Manager in SQL Server 2000, but I'm not sure how to do it in the new interface. Is there a way to do a simple data import without also installing Business Intelligence Development Studio?

hi,

nope..

all this "stuff" has now be included in SSIS (integration service), not available in SSMSE as SQLExpress does not include the required runtime at all..

but you can perhaps interact with "linked servers" scenario and perform INSERT ... SELECT ...

something like http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=670748&SiteID=1

regards

|||Thank you!

Import Data and Identity fields

When i run the "Import Data" task from SQL 2005 Managment Studio and select the "Copy data from one or more tables or views" option, I notice the task does not re-create the "Identity" field definitions on the destination table. (SQL 2000 EM did this.) Is there a way to tell the import task to include the identity field definition when creating the destiination tables?

The only work around i've found in SQL Mgmt Studio takes multiple steps:

1) run Generate scripts on the source database, and select all tables to create the table scripts (this includes the identity field on each table)

2) run the script on the destination database to created the tables

3) run the import task, edit mappings and select "enable identity insert".

this is really a pain since i could accomplish this all in 1 step in SQL 2000 EM.

Any suggestions? Please help!

Microsoft? You there? Anybody?|||

You might get more traction on this in the SSIS forum, but I'll give it a try. By the way, this is an all-volunteer forum, so if you need immediate support, see http://microsoft.com/support. It's not only us Microsoft working folks in here, we just maintain the forum and try to help as much as we can.

This series of posts might help:

http://www.developerdotstar.com/community/node/727#comment-8456

Basically it involves the "FAST LOAD" option.

Buck Woody

SQL Server Team

Import Data and Identity fields

When i run the "Import Data" task from SQL 2005 Managment Studio and select the "Copy data from one or more tables or views" option, I notice the task does not re-create the "Identity" field definitions on the destination table. (SQL 2000 EM did this.) Is there a way to tell the import task to include the identity field definition when creating the destiination tables?

The only work around i've found in SQL Mgmt Studio takes multiple steps:

1) run Generate scripts on the source database, and select all tables to create the table scripts (this includes the identity field on each table)

2) run the script on the destination database to created the tables

3) run the import task, edit mappings and select "enable identity insert".

this is really a pain since i could accomplish this all in 1 step in SQL 2000 EM.

Any suggestions? Please help!

Microsoft? You there? Anybody?|||

You might get more traction on this in the SSIS forum, but I'll give it a try. By the way, this is an all-volunteer forum, so if you need immediate support, see http://microsoft.com/support. It's not only us Microsoft working folks in here, we just maintain the forum and try to help as much as we can.

This series of posts might help:

http://www.developerdotstar.com/community/node/727#comment-8456

Basically it involves the "FAST LOAD" option.

Buck Woody

SQL Server Team

Import an Access Database

I am trying to import an Access database and I am using SQL Server Express. The instructions say to

In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.

When I point to Tasks, the Import Data is not listed.

If someone can help. Should I be able to use the Import Wizard?

Thanks,

Dougins

Import/Export is not available on SqlExpress.

Integration and Interoperability Feature Express Workgroup Standard Enterprise Comments

Import/Export

|||http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||did this answer your question?

Import an Access Database

I am trying to import an Access database and I am using SQL Server Express. The instructions say to

In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.

When I point to Tasks, the Import Data is not listed.

If someone can help. Should I be able to use the Import Wizard?

Thanks,

Dougins

Import/Export is not available on SqlExpress.

Integration and Interoperability

Feature

Express

Workgroup

Standard

Enterprise

Comments

Import/Export

|||http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||did this answer your question?

Import Access File

Is there a way to import an access table into Microsoft SQL Server Express with Server Management Studio? I prefer not to use the upsize tool from access. Another option would be to import from a text file, if someone can explain how to do this.

Thanks

hi,

nope, this is not "available"... but you could use a linked server approach..

regards|||

Microsoft has an excellent tool for migrating Access tables: SQL Migration Assistant for Access. Try:

www.microsoft.com/sql/solutions/migration/access/default.mspx

If you just search the Microsoft site for SQL Migration Assistant for Access it will give you several links to follow.

Hope that helps.

Don Seydel

Import & Export disabled in Management Studio

I find that sometime the menu item "Import" and "Export" of the database popup menu in SQL Management Studio are disabled. Why and how can I enable them?

Thanks

Any suggestion is appreciated.

Import & Export

Hi,
I'm using Reporting Services and MOM 2005.
How can I import existing reports to Visual Studio for design mode?I means to import all the reports and not one by one
Also, is it possible in Visual Studio to configure each report to a
different TargetFolder in the same project?
"×¢×?×?×?" wrote:
> Hi,
> I'm using Reporting Services and MOM 2005.
> How can I import existing reports to Visual Studio for design mode?|||Hi,
I try to upload my report to the reporting services using
PublishSampleReports.rss
I try to upload to a subfolder parentFolder="All SQL Report/performance"
but I ger an error message,
How can I do that ?
"×¢×?×?×?" wrote:
> I means to import all the reports and not one by one
> Also, is it possible in Visual Studio to configure each report to a
> different TargetFolder in the same project?
> "×¢×?×?×?" wrote:
> > Hi,
> >
> > I'm using Reporting Services and MOM 2005.
> > How can I import existing reports to Visual Studio for design mode?|||What error message are you getting?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"'" <@.discussions.microsoft.com> wrote in message
news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> Hi,
> I try to upload my report to the reporting services using
> PublishSampleReports.rss
> I try to upload to a subfolder parentFolder="All SQL Report/performance"
> but I ger an error message,
> How can I do that ?
> "'" wrote:
>> I means to import all the reports and not one by one
>> Also, is it possible in Visual Studio to configure each report to a
>> different TargetFolder in the same project?
>> "'" wrote:
>> > Hi,
>> >
>> > I'm using Reporting Services and MOM 2005.
>> > How can I import existing reports to Visual Studio for design mode?|||The error message:
C:\Reporting>rs -i PublishSampleReports.rss -s
http://momreporting/reportserver/
-v parentFolder="Microsoft Operations Manager Reporting/idanl"
System.Web.Services.Protocols.SoapException: The name of the item 'Microsoft
Ope
rations Manager Reporting/idanl' is not valid. The name must be less than
260 ch
aracters long, must not start with slash; other restrictions apply. Check
the do
cumentation for complete set of restrictions. -->
Microsoft.ReportingServices.D
iagnostics.Utilities.InvalidItemNameException: The name of the item
'Microsoft O
perations Manager Reporting/idanl' is not valid. The name must be less than
260
characters long, must not start with slash; other restrictions apply. Check
the
documentation for complete set of restrictions.
"Jeff A. Stucker" wrote:
> What error message are you getting?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "'" <@.discussions.microsoft.com> wrote in message
> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> > Hi,
> > I try to upload my report to the reporting services using
> > PublishSampleReports.rss
> > I try to upload to a subfolder parentFolder="All SQL Report/performance"
> > but I ger an error message,
> > How can I do that ?
> >
> > "'" wrote:
> >
> >> I means to import all the reports and not one by one
> >>
> >> Also, is it possible in Visual Studio to configure each report to a
> >> different TargetFolder in the same project?
> >>
> >> "'" wrote:
> >>
> >> > Hi,
> >> >
> >> > I'm using Reporting Services and MOM 2005.
> >> > How can I import existing reports to Visual Studio for design mode?
>
>|||Sorry I can't help you on the RSS issue.
But I can answer the question about Visual Studio. Unfortunately, at this
time there is a one-to-one mapping between project and folder. I set up a
VS solution with multiple projects -- one for each folder I need to publish
to.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"'" <@.discussions.microsoft.com> wrote in message
news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
> The error message:
> C:\Reporting>rs -i PublishSampleReports.rss -s
> http://momreporting/reportserver/
> -v parentFolder="Microsoft Operations Manager Reporting/idanl"
> System.Web.Services.Protocols.SoapException: The name of the item
> 'Microsoft
> Ope
> rations Manager Reporting/idanl' is not valid. The name must be less than
> 260 ch
> aracters long, must not start with slash; other restrictions apply. Check
> the do
> cumentation for complete set of restrictions. -->
> Microsoft.ReportingServices.D
> iagnostics.Utilities.InvalidItemNameException: The name of the item
> 'Microsoft O
> perations Manager Reporting/idanl' is not valid. The name must be less
> than
> 260
> characters long, must not start with slash; other restrictions apply.
> Check
> the
> documentation for complete set of restrictions.
> "Jeff A. Stucker" wrote:
>> What error message are you getting?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "'" <@.discussions.microsoft.com> wrote in message
>> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
>> > Hi,
>> > I try to upload my report to the reporting services using
>> > PublishSampleReports.rss
>> > I try to upload to a subfolder parentFolder="All SQL
>> > Report/performance"
>> > but I ger an error message,
>> > How can I do that ?
>> >
>> > "'" wrote:
>> >
>> >> I means to import all the reports and not one by one
>> >>
>> >> Also, is it possible in Visual Studio to configure each report to a
>> >> different TargetFolder in the same project?
>> >>
>> >> "'" wrote:
>> >>
>> >> > Hi,
>> >> >
>> >> > I'm using Reporting Services and MOM 2005.
>> >> > How can I import existing reports to Visual Studio for design mode?
>>|||Hi Jeff
I succeed to solve the problem with the path problem by run this command
without the http://momreporting/reportserver/
But while I import the report to the reporting services I get in all the
report a new text box to enter user name & password, why ?
Thanks and have a happy new years
Idan
"Jeff A. Stucker" wrote:
> Sorry I can't help you on the RSS issue.
> But I can answer the question about Visual Studio. Unfortunately, at this
> time there is a one-to-one mapping between project and folder. I set up a
> VS solution with multiple projects -- one for each folder I need to publish
> to.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "'" <@.discussions.microsoft.com> wrote in message
> news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
> > The error message:
> >
> > C:\Reporting>rs -i PublishSampleReports.rss -s
> > http://momreporting/reportserver/
> > -v parentFolder="Microsoft Operations Manager Reporting/idanl"
> > System.Web.Services.Protocols.SoapException: The name of the item
> > 'Microsoft
> > Ope
> > rations Manager Reporting/idanl' is not valid. The name must be less than
> > 260 ch
> > aracters long, must not start with slash; other restrictions apply. Check
> > the do
> > cumentation for complete set of restrictions. -->
> > Microsoft.ReportingServices.D
> > iagnostics.Utilities.InvalidItemNameException: The name of the item
> > 'Microsoft O
> > perations Manager Reporting/idanl' is not valid. The name must be less
> > than
> > 260
> > characters long, must not start with slash; other restrictions apply.
> > Check
> > the
> > documentation for complete set of restrictions.
> >
> > "Jeff A. Stucker" wrote:
> >
> >> What error message are you getting?
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "'" <@.discussions.microsoft.com> wrote in message
> >> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> >> > Hi,
> >> > I try to upload my report to the reporting services using
> >> > PublishSampleReports.rss
> >> > I try to upload to a subfolder parentFolder="All SQL
> >> > Report/performance"
> >> > but I ger an error message,
> >> > How can I do that ?
> >> >
> >> > "'" wrote:
> >> >
> >> >> I means to import all the reports and not one by one
> >> >>
> >> >> Also, is it possible in Visual Studio to configure each report to a
> >> >> different TargetFolder in the same project?
> >> >>
> >> >> "'" wrote:
> >> >>
> >> >> > Hi,
> >> >> >
> >> >> > I'm using Reporting Services and MOM 2005.
> >> >> > How can I import existing reports to Visual Studio for design mode?
> >>
> >>
> >>
>
>|||Check the report permissions in Report Manager (http://<server>/Reports)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"'" <@.discussions.microsoft.com> wrote in message
news:5DE0A914-146E-46B9-AF6A-F77127BE5A47@.microsoft.com...
> Hi Jeff
> I succeed to solve the problem with the path problem by run this command
> without the http://momreporting/reportserver/
> But while I import the report to the reporting services I get in all the
> report a new text box to enter user name & password, why ?
> Thanks and have a happy new years
> Idan
>
> "Jeff A. Stucker" wrote:
>> Sorry I can't help you on the RSS issue.
>> But I can answer the question about Visual Studio. Unfortunately, at
>> this
>> time there is a one-to-one mapping between project and folder. I set up
>> a
>> VS solution with multiple projects -- one for each folder I need to
>> publish
>> to.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "'" <@.discussions.microsoft.com> wrote in message
>> news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
>> > The error message:
>> >
>> > C:\Reporting>rs -i PublishSampleReports.rss -s
>> > http://momreporting/reportserver/
>> > -v parentFolder="Microsoft Operations Manager Reporting/idanl"
>> > System.Web.Services.Protocols.SoapException: The name of the item
>> > 'Microsoft
>> > Ope
>> > rations Manager Reporting/idanl' is not valid. The name must be less
>> > than
>> > 260 ch
>> > aracters long, must not start with slash; other restrictions apply.
>> > Check
>> > the do
>> > cumentation for complete set of restrictions. -->
>> > Microsoft.ReportingServices.D
>> > iagnostics.Utilities.InvalidItemNameException: The name of the item
>> > 'Microsoft O
>> > perations Manager Reporting/idanl' is not valid. The name must be less
>> > than
>> > 260
>> > characters long, must not start with slash; other restrictions apply.
>> > Check
>> > the
>> > documentation for complete set of restrictions.
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> What error message are you getting?
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "'" <@.discussions.microsoft.com> wrote in message
>> >> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
>> >> > Hi,
>> >> > I try to upload my report to the reporting services using
>> >> > PublishSampleReports.rss
>> >> > I try to upload to a subfolder parentFolder="All SQL
>> >> > Report/performance"
>> >> > but I ger an error message,
>> >> > How can I do that ?
>> >> >
>> >> > "'" wrote:
>> >> >
>> >> >> I means to import all the reports and not one by one
>> >> >>
>> >> >> Also, is it possible in Visual Studio to configure each report to a
>> >> >> different TargetFolder in the same project?
>> >> >>
>> >> >> "'" wrote:
>> >> >>
>> >> >> > Hi,
>> >> >> >
>> >> >> > I'm using Reporting Services and MOM 2005.
>> >> >> > How can I import existing reports to Visual Studio for design
>> >> >> > mode?
>> >>
>> >>
>> >>
>>|||Thanks jeff
I know I can change the report permission under each report,
but if I have a lot of report I need to change it each one, Why the import
process cause this ?
"Jeff A. Stucker" wrote:
> Check the report permissions in Report Manager (http://<server>/Reports)
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "'" <@.discussions.microsoft.com> wrote in message
> news:5DE0A914-146E-46B9-AF6A-F77127BE5A47@.microsoft.com...
> > Hi Jeff
> > I succeed to solve the problem with the path problem by run this command
> > without the http://momreporting/reportserver/
> >
> > But while I import the report to the reporting services I get in all the
> > report a new text box to enter user name & password, why ?
> >
> > Thanks and have a happy new years
> >
> > Idan
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Sorry I can't help you on the RSS issue.
> >>
> >> But I can answer the question about Visual Studio. Unfortunately, at
> >> this
> >> time there is a one-to-one mapping between project and folder. I set up
> >> a
> >> VS solution with multiple projects -- one for each folder I need to
> >> publish
> >> to.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "'" <@.discussions.microsoft.com> wrote in message
> >> news:1DA41224-9065-4713-8169-D9F1EE29CAED@.microsoft.com...
> >> > The error message:
> >> >
> >> > C:\Reporting>rs -i PublishSampleReports.rss -s
> >> > http://momreporting/reportserver/
> >> > -v parentFolder="Microsoft Operations Manager Reporting/idanl"
> >> > System.Web.Services.Protocols.SoapException: The name of the item
> >> > 'Microsoft
> >> > Ope
> >> > rations Manager Reporting/idanl' is not valid. The name must be less
> >> > than
> >> > 260 ch
> >> > aracters long, must not start with slash; other restrictions apply.
> >> > Check
> >> > the do
> >> > cumentation for complete set of restrictions. -->
> >> > Microsoft.ReportingServices.D
> >> > iagnostics.Utilities.InvalidItemNameException: The name of the item
> >> > 'Microsoft O
> >> > perations Manager Reporting/idanl' is not valid. The name must be less
> >> > than
> >> > 260
> >> > characters long, must not start with slash; other restrictions apply.
> >> > Check
> >> > the
> >> > documentation for complete set of restrictions.
> >> >
> >> > "Jeff A. Stucker" wrote:
> >> >
> >> >> What error message are you getting?
> >> >>
> >> >> --
> >> >> Cheers,
> >> >>
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "'" <@.discussions.microsoft.com> wrote in message
> >> >> news:CB82802F-3506-4BEA-973C-24D0D35813F8@.microsoft.com...
> >> >> > Hi,
> >> >> > I try to upload my report to the reporting services using
> >> >> > PublishSampleReports.rss
> >> >> > I try to upload to a subfolder parentFolder="All SQL
> >> >> > Report/performance"
> >> >> > but I ger an error message,
> >> >> > How can I do that ?
> >> >> >
> >> >> > "'" wrote:
> >> >> >
> >> >> >> I means to import all the reports and not one by one
> >> >> >>
> >> >> >> Also, is it possible in Visual Studio to configure each report to a
> >> >> >> different TargetFolder in the same project?
> >> >> >>
> >> >> >> "'" wrote:
> >> >> >>
> >> >> >> > Hi,
> >> >> >> >
> >> >> >> > I'm using Reporting Services and MOM 2005.
> >> >> >> > How can I import existing reports to Visual Studio for design
> >> >> >> > mode?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>