Error running report: click

Showing posts with label click. Show all posts

Thursday, March 29, 2012

Error when trying to open report in VS.NET

Hi,
I'm trying to open a report that was created a few days ago to make
modifications. When I double click on it in the Solutions Explorer in
VS.NET, I get an Exception from HRESULT error.
The report has been published to the report server.
Does anyone know how I can troubleshoot this?
ThanksDoes this describe your problem?
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/1ab023b68d2ca2ed/4e31690c8f70c2fa?q=rdl++0x80131500&_done=%2Fgroups%3Fq%3Drdl++0x80131500%26&_doneTitle=Back+to+Search&&d#4e31690c8f70c2fa
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"T." <asdfasdf@.adfasdf.com> wrote in message
news:e1amHtoGFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm trying to open a report that was created a few days ago to make
> modifications. When I double click on it in the Solutions Explorer in
> VS.NET, I get an Exception from HRESULT error.
> The report has been published to the report server.
> Does anyone know how I can troubleshoot this?
> Thanks
>sql

Tuesday, March 27, 2012

Error when trying to create new databaase using SQL Server

Hi,

I have installed MS SQL server and I'm trying to create a database using the Web Matrix Project. I'm doing the following:

1. Click the Data tab in the Workspace pane.
2. Click on "Add Database Connection"
3. Select "SQL Server/MSDE Database" and click OK
4. Enter the following information:
server=localhost
Windows authentication is on
Database=somename

Click Ok

After I do all this, I get the following error:
Unable to connect to the database
SQL server does not exist or access denied.
ConnectionOpen (Connect()).

The SQL Service Manager is running with the option "Distributed Transaction Coordinator" displaying on Services. (I'm new to SQL server).

What could be causing this to happen?

Thanks a lot."Add Database Connection" is for connecting to an existing database...

use SQL Enterprise Manager to create the database first.|||1. Check if the DNS entries for the database servers are correct. These could be one of the reasons.
2. You must also see if you have sysadmin previledges to create a database.

These are some of the points that come to mind.

Sunday, February 19, 2012

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

Error 1 File system error: The following file is corrupted: Physical file: \\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.0.dim\1.Start Date.(All).sstore. Logical file . Errors in the metadata manager. An error occurred when loading the Product dimension, from the file, '\\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.1.dim.xml'. Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'.
This file has nothing to do with my database/project and is not even in the solution. Why is my deploy getting failed due to this file?
AllanDear Allan,

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

Since I am new to Analysis, I was practicing with the BI tool by setting up different dsvs, cubes, mining structures, etc. Most of them through the wizard. Every time I reached a level that I knew I was basically wrong and things were not working I would delete the previously generated output from the wizard. I started noticing this error, after I had deleted a two mining structures (outputs of wizard), followed by deleting I believe the dimensions first and then the cube (all related). I was working on another dsv and setting up the dimension and fact tables and everything seemed fine, I generated the cube fine as well. But processing the new cube results in this error. At the time I was working in the same soln. I started a new soln -> same error. Reregistered msolap90.dll same error. deleted the xml that seemed to be causing the problem and seemed to be corrupt (I did find it in the path specified) -> still the same error. Seems like I am stuck and can't do anything any more with analysis services. I was hoping that there was a soln for this problem online, but I guess short of reinstalling there is none.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

"file system error. The following error occurred during a file operation. The system cannot find the file specified. \\?\C:Program files\Microsoft Sql Server\MSSQL.2\OLAP\Data\Touch.45.db\Project4447005.dim.xml"

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

"Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\BudOlap07.45.db\Act List1.16.dim.xml"

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

|||We had this same problem. As soon as we upgraded the target machine to SP2, the problem went away.

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

|||We had this same problem. As soon as we upgraded the target machine to SP2, the problem went away.

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

|||We had this same problem. As soon as we upgraded the target machine to SP2, the problem went away.

Error that has nothing to do with my cube

I right click on my AS cube and click "Process". It tells me the server content is out of date would I like to build and deploy first. i say yes.

I get this error

I have same problems, anybody out there with an solution?

Regards
Michael|||Michael

Hast du etwas fruher getan? Ich hatte das AS beispiel Projekt aber in eine verschiedene loesung eingesetzt. Vielleich gibt's etwas kaputt?

Have you done anything earlier? I had deployed the sample AS project but in a different solution. Perhaps there is something broken?
Allan

|||Allan,

I added befor a second fact table, but even when I deleted the second one I can no longer deploy the solution.

Michael|||Try to clean up your data directory and re-deploy your solution.
You data directory by default is under C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data.

It would be also very helpful if you can post exact steps leading to the situation you describe.
Edward Melomed (MSFT)

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

Besides my data Directory for OLAP being in MSSQL.2 this works. i had already done this in fact. What I would like to hear though is why this happens.

Why does this happen?

Any way to stop it from happening again?

Thanks for anything you can offer.

Allan|||

One of the files in the data folder got corrupted and the error you are seeing indicates that Analysis Server was unable to load it.

Now, about how did that happen: the hope is that you would provide series of steps on how did you get in such situation :)

We are looking into every instance of such corruption, it usually indicates bug in the product, and in order to fix the problem we need to be able to reproduce it.

Edward Melomed (MSFT)

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

|||

I'm getting this same error, have cleaned up my data directory, and still it is not resolved. Any other ideas?

|||

Hi,

I am getting the same error. I will try to give as much info regarding this issue as possible. Hopefully it will help.

If there is anything I would love to know, thanks,

Amadelle

|||

I had similar errors but they referred to the correct project but said they could not find a certail dim.xml file.

I refreshed the data source views

I right clicked the database and selected validate database. That seemed to clean up the problem.

the error has reoccurred when I try to process the cube, which has a legitmate error (missing filed).

However, the dimensions can no longer be processed.

|||

I had a similar problem.

1. I restored a database from an .abf file. The database was now visible in SQL Server Management Studio.

2. I was unable to browse or view properties for any cube, not just the cubes in the restored database. I was also unable to delete the restored database.

3. I stopped the Analysis Services service (not sure whether this was necessary)

4. I deleted the folder in my data directory (under mssql.2) corresponding to the restored .abf

5. I re-started the service

6. I was able to surf my other cubes

7. I was also able to delete the folder in Analysis Services for the corrupt database.

I'm piling on to an old post. Has this been fixed yet?

|||

I have a similar problem, and I could not fix it by deleting the folder in data directory and restarting the service.

I have AS database witch works on my computer. When I tried to restore it on another computer I received:

I’ve deleted the folder in data directory and restart the service, but I could not still use it.

I didn’t see no cubes and dimensions in it.

I appreciate any help!

|||We had this same problem. As soon as we upgraded the target machine to SP2, the problem went away.

Error testing sql mail

Hi,
In the properties of the sql mail, when i click in botton
'Test' i receive the following message :
Error 18025 : xp_test_mapi_profile : failed with mail
error 0x80040111.
Who can i resolve this problem ?
Best regards,www.aspfaq.com/2403
"catdido" <catdido@.iol.pt> wrote in message
news:019801c35d05$dbf85310$a301280a@.phx.gbl...
> Hi,
> In the properties of the sql mail, when i click in botton
> 'Test' i receive the following message :
> Error 18025 : xp_test_mapi_profile : failed with mail
> error 0x80040111.
> Who can i resolve this problem ?
>
> Best regards,

Error Starting Script Editor in SSIS

I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states:

Cannot show the editor for this task. (Microsoft Visual Studio)

For the Script component I get:

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

How odd! I havent' idea.. Maybe this is a stuff related with the own assembly?

Look at c:\windows\assembly and make sure that exists Microsoft.Vsa.Hosting.Design Time assembly.

I'm sorry

|||

reedcbr wrote:

I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states:
Cannot show the editor for this task. (Microsoft Visual Studio)
For the Script component I get:
Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)
For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

does other control flow objects and data flow transformation experience the same

|||Those are the only two that I have noticed it in. Are there other objects that have Design Script buttons. If so, I will test them and reply with an answer.|||Yes, the assembly is there. Its' version is 8.0.0.0 and its' public key token is b03f5f7f11d50a3a|||Yes, the assembly is there. Its' version is 8.0.0.0 and its' public key token is b03f5f7f11d50a3a|||I am wondering if anyone is monitoring this forum, I posted answers to the questions that I was asked and haven't received any more responses.|||Well, perhaps a reinstall is in order... Nevermind... Just read the whole thread.|||I was just wondering if this could be happening because this desktop is running Windows XP Media Edition?|||

Do you have Visual Studio installed?

If yes, can you try and and run : Tools-> Macros-> Macros IDE... and see if that works?

Thanks,

Ovidiu

|||

hi,

Weird thing happen to SSIS when

the integration service does not have sufficient right

in the Box.

check to see if the integrarion service has sufficient rights

click start>run>type "service.msc"

look for the integration service and supply it with a powerful account in your box

perhaps an administrator account.

regards,

joey

|||

I'm having the same problem, except when I click the Design Script button nothing happens, I don't even get an error message. Has anyone been able to find the solution for this?

Tom

|||

(I think the underlying cause is something to do with .Net 3.0 install, Maybe the installation of SQL2005 SP2, or maybe the order of install between VS2005 and SSIS, but whatever the reason, there is a registry issue.

First, do make sure your SSIS service has appropriate login rights.

Also, navigate to the following folders:

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\common\

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\vsa

In each of those folders run this command to re-register everything in there.:

for %i in (*.dll) do RegSvr32 -s %i

You will be very pleased with the results I think. May be a little blunt, but it worked for me.

I had determined this was the issue from the detailed error message provided in the dialog, where it indicated the problem was the program Microsoft.VisualBasic.Vsa.Dt.get_extensibility.... blah blah, and another message saying "interface not registered". Putting 2 and 2 together, I did a search for that dll, and registered everything in that folder and the other one.

There are a few people on forums starting to post this issue, and there don't seem to be any responses, so tell everyone you know, because I'm sure it will be a common problem among SSIS developers who use scripting.

|||

Your idea is on the right path. My initial error pointed me to the DTS folder under C:\Program Files\Microsoft SQL Server\90\DTS\Binn. I registered what you did above, but it did not work. I decided, hey lets try the DTS\Binn folder. What do you know, I no longer get the error and can see all my work flow in SSIS. Thanks for the tip (it appears security does not have to be set to Local User, but rather a solid Admin account).

Thanks,

Error Starting Script Editor in SSIS

Cannot show the editor for this task. (Microsoft Visual Studio)

For the Script component I get:

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

How odd! I havent' idea.. Maybe this is a stuff related with the own assembly?

Look at c:\windows\assembly and make sure that exists Microsoft.Vsa.Hosting.Design Time assembly.

I'm sorry

|||

reedcbr wrote:

I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states:
Cannot show the editor for this task. (Microsoft Visual Studio)
For the Script component I get:
Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)
For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

does other control flow objects and data flow transformation experience the same

Do you have Visual Studio installed?

If yes, can you try and and run : Tools-> Macros-> Macros IDE... and see if that works?

Thanks,

Ovidiu

|||

hi,

Weird thing happen to SSIS when
the integration service does not have sufficient right
in the Box.
check to see if the integrarion service has sufficient rights
click start>run>type "service.msc"
look for the integration service and supply it with a powerful account in your box
perhaps an administrator account.

regards,

joey

|||

I'm having the same problem, except when I click the Design Script button nothing happens, I don't even get an error message. Has anyone been able to find the solution for this?

Tom

|||

First, do make sure your SSIS service has appropriate login rights.

Also, navigate to the following folders:

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\common\

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\vsa

In each of those folders run this command to re-register everything in there.:

for %i in (*.dll) do RegSvr32 -s %i

You will be very pleased with the results I think. May be a little blunt, but it worked for me.

|||

Thanks,

Error Starting Script Editor in SSIS

Cannot show the editor for this task. (Microsoft Visual Studio)

For the Script component I get:

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

How odd! I havent' idea.. Maybe this is a stuff related with the own assembly?

Look at c:\windows\assembly and make sure that exists Microsoft.Vsa.Hosting.Design Time assembly.

I'm sorry

|||

reedcbr wrote:

I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states:
Cannot show the editor for this task. (Microsoft Visual Studio)
For the Script component I get:
Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)
For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

does other control flow objects and data flow transformation experience the same

Do you have Visual Studio installed?

If yes, can you try and and run : Tools-> Macros-> Macros IDE... and see if that works?

Thanks,

Ovidiu

|||

hi,

Weird thing happen to SSIS when
the integration service does not have sufficient right
in the Box.
check to see if the integrarion service has sufficient rights
click start>run>type "service.msc"
look for the integration service and supply it with a powerful account in your box
perhaps an administrator account.

regards,

joey

|||

I'm having the same problem, except when I click the Design Script button nothing happens, I don't even get an error message. Has anyone been able to find the solution for this?

Tom

|||

First, do make sure your SSIS service has appropriate login rights.

Also, navigate to the following folders:

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\common\

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\vsa

In each of those folders run this command to re-register everything in there.:

for %i in (*.dll) do RegSvr32 -s %i

You will be very pleased with the results I think. May be a little blunt, but it worked for me.

|||

Thanks,

Error Starting Script Editor in SSIS

Cannot show the editor for this task. (Microsoft Visual Studio)

For the Script component I get:

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

How odd! I havent' idea.. Maybe this is a stuff related with the own assembly?

Look at c:\windows\assembly and make sure that exists Microsoft.Vsa.Hosting.Design Time assembly.

I'm sorry

|||

reedcbr wrote:

I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states:

Cannot show the editor for this task. (Microsoft Visual Studio)

For the Script component I get:

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help!

does other control flow objects and data flow transformation experience the same

Do you have Visual Studio installed?

If yes, can you try and and run : Tools-> Macros-> Macros IDE... and see if that works?

Thanks,

Ovidiu

|||

hi,

Weird thing happen to SSIS when

the integration service does not have sufficient right

in the Box.

check to see if the integrarion service has sufficient rights

click start>run>type "service.msc"

look for the integration service and supply it with a powerful account in your box

perhaps an administrator account.

regards,

joey

|||

I'm having the same problem, except when I click the Design Script button nothing happens, I don't even get an error message. Has anyone been able to find the solution for this?

Tom

|||

First, do make sure your SSIS service has appropriate login rights.

Also, navigate to the following folders:

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\common\

C:\Program Files\Common Files\Microsoft Shared\VSA\8.0\vsa

In each of those folders run this command to re-register everything in there.:

for %i in (*.dll) do RegSvr32 -s %i

You will be very pleased with the results I think. May be a little blunt, but it worked for me.

|||

Thanks,

Wednesday, February 15, 2012

Error Scripting Procs: Failed to retrieve dependency information

How can I resolve the following error when I try to script out some procs. In SSMS I right click the db and I choose 'Tasks > Generate Script', then I select 10 stored procs (without changing any of the default options). If I don't include the proc mentioned in the error below, then it works OK.

TITLE: Microsoft.SqlServer.SqlEnum

Failed to retrieve dependency information (object_id(System.Int32) 1271727633.object_type(System.Int16) 4.relative_id(System.Int32)

1879729799.relative_type(System.DBNull) .object_name(System.String) usp_SEL_RCEPCompanyHistory.object_schema(System.String)

dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).

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

ADDITIONAL INFORMATION:

Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)

I'm having this problem, too. Any resolution?|||

Please help us understand what kind of object caused the problem better by running the following queries and telling us what do they return.

select * from sys.objects where object_id = xxxx

select * from sys.sql_dependencies where object_id = xxxx or referenced_major_id=xxxx

select * from sys.assembly_modules where object_id = xxxx

You want to replace xxxx with the number that shows in the error message after relative_id.

Thanks,

Ciprian Gerea

|||

The object is a user-defined aggregate function ('Microsoft.Samples.SqlServer.Concatenate'). I think this problem has already been submitted in feedback here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125881

|||

I set up my machine as directed in the above issue report, using our current sp2 build, and was unable to reproduce the error reported here.

It may be the case that the two feedback items are evidence of two issues, with distinct repro scenarios, but I am assuming that we have fixed this, and that you can expect to see it in the upcoming release of sql server sp2.

|||

I was experiencing the same type of error. Your script above was helpful to me in identifying the SQL_dependencies for the procs that was throwing the errors. It turns out in my situation there were procs which were referencing the service queue objects and for what ever reasons it did not like those procs. I excluded those procs from my script generator and it worked.

Error Scripting Procs: Failed to retrieve dependency information

TITLE: Microsoft.SqlServer.SqlEnum

Failed to retrieve dependency information (object_id(System.Int32) 1271727633.object_type(System.Int16) 4.relative_id(System.Int32)

1879729799.relative_type(System.DBNull) .object_name(System.String) usp_SEL_RCEPCompanyHistory.object_schema(System.String)

dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).

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

ADDITIONAL INFORMATION:

Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)

I'm having this problem, too. Any resolution?|||

Please help us understand what kind of object caused the problem better by running the following queries and telling us what do they return.

select * from sys.objects where object_id = xxxx

select * from sys.sql_dependencies where object_id = xxxx or referenced_major_id=xxxx

select * from sys.assembly_modules where object_id = xxxx

You want to replace xxxx with the number that shows in the error message after relative_id.

Thanks,

Ciprian Gerea

|||

The object is a user-defined aggregate function ('Microsoft.Samples.SqlServer.Concatenate'). I think this problem has already been submitted in feedback here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125881

|||

I set up my machine as directed in the above issue report, using our current sp2 build, and was unable to reproduce the error reported here.

|||

Error Scripting Procs: Failed to retrieve dependency information

TITLE: Microsoft.SqlServer.SqlEnum

Failed to retrieve dependency information (object_id(System.Int32) 1271727633.object_type(System.Int16) 4.relative_id(System.Int32)

1879729799.relative_type(System.DBNull) .object_name(System.String) usp_SEL_RCEPCompanyHistory.object_schema(System.String)

dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).

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

ADDITIONAL INFORMATION:

Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)

I'm having this problem, too. Any resolution?
|||

Please help us understand what kind of object caused the problem better by running the following queries and telling us what do they return.

select * from sys.objects where object_id = xxxx

select * from sys.sql_dependencies where object_id = xxxx or referenced_major_id=xxxx

select * from sys.assembly_modules where object_id = xxxx

You want to replace xxxx with the number that shows in the error message after relative_id.

Thanks,

Ciprian Gerea

|||

The object is a user-defined aggregate function ('Microsoft.Samples.SqlServer.Concatenate'). I think this problem has already been submitted in feedback here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125881

|||

I set up my machine as directed in the above issue report, using our current sp2 build, and was unable to reproduce the error reported here.

|||

Error Scripting Procs: Failed to retrieve dependency information

TITLE: Microsoft.SqlServer.SqlEnum

Failed to retrieve dependency information (object_id(System.Int32) 1271727633.object_type(System.Int16) 4.relative_id(System.Int32)

1879729799.relative_type(System.DBNull) .object_name(System.String) usp_SEL_RCEPCompanyHistory.object_schema(System.String)

dbo.relative_name(System.DBNull) .relative_schema(System.DBNull) .).

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

ADDITIONAL INFORMATION:

Specified cast is not valid. (Microsoft.SqlServer.SqlEnum)

I'm having this problem, too. Any resolution?
|||

Please help us understand what kind of object caused the problem better by running the following queries and telling us what do they return.

select * from sys.objects where object_id = xxxx

select * from sys.sql_dependencies where object_id = xxxx or referenced_major_id=xxxx

select * from sys.assembly_modules where object_id = xxxx

You want to replace xxxx with the number that shows in the error message after relative_id.

Thanks,

Ciprian Gerea

|||

The object is a user-defined aggregate function ('Microsoft.Samples.SqlServer.Concatenate'). I think this problem has already been submitted in feedback here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125881

|||

I set up my machine as directed in the above issue report, using our current sp2 build, and was unable to reproduce the error reported here.

|||

error running ssis package

I run an ssis task with right click in the BIDS.

the task transform data of the tables between sql2005 DB to another sql2005 DB.

this is the error I get:

Code Snippet

An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description:

"Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description:

"TCP Provider: The semaphore timeout period has expired.

helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

Task failed: CopyTables2

i have a similar task, only diffrent tables that being transfered, same settings. this task run succesfully.

for the task that fails it takes a long time to run (something like half an hour, maybe more) and then it falils. the task that succeeds finish fast (something like 5 minutes). the data in the tables that being transeferred in the good task is much smaller than the data in the tables in the failed task.

Anyone knows the reason to the error.

Thanks.

It sounds like a timeout issue. You say that the task which is failing is moving a large amount of data, and taking more than 30 minutes? Is it always failing after the same amount of time? If so, you might check the timeout on the connections.

|||

it looks like a timeout issue also to me. when i remove a very big table from this package (a 40 milion records table) the package run faster and finish successfully. how can i set the timeout of the connection in the BIDS. i didn't see timeout property in the connections manager.

anyway, i dont understand this SSIS. in sql2000 i transferred very large tables with no problem using the dts. since i upgraded to sql2005 i encounter lots of bugs in the SSIS.

Thanks.

|||

Open up your connection manager, then click on the 'All' page, under the 'Initialization' category there is a 'connect timeout' and 'general timeout' properties. It seems like by default these are both set to 0, which I would interpret as unlimited though.

Could you give a more detailed explanation of your package. Are you transferring the data through a stored procedure in an execute sql task or a data flow task?

|||You might also check the SQL Server to make sure the query governor is not enabled. The setting is located in the Server Properties, under the Connections page.|||

Thanks for your answer.

I'm sorry, i can't find the 'all' page and i can't find the 'initialization' catrgory in the connections manager.

I created a task in the control flow in the BIDS. i dragged from the toolbox to the control flow, transfer sql server object. i configured the source DB and destination DB and the tables I want to transfer. I only transder the data in the tables.

appreciate your help.

|||The query governor is indeed not enabled. thx.|||

When you open the connection manager, you should see Connection and All listed on the left hand side of the dialog box. Click All to see all the information realted to the connection.

|||

Thanks for your answer.

i don't see it. Under the control flow and data flow area in the BIDS there is the connection managers.

I see there 2 connections: one of the source DB and the other is the destination DB.

when i click on each one of them i get the SMO connection manager editor dialog box, there i can configure the connection of the source or destination DB. other than that i don't see the 'all' button than u mention.

where can i find it?

Sorry for all the questions...

Thanks.

|||

kubyustus wrote:

Thanks for your answer.
i don't see it. Under the control flow and data flow area in the BIDS there is the connection managers.
I see there 2 connections: one of the source DB and the other is the destination DB.
when i click on each one of them i get the SMO connection manager editor dialog box, there i can configure the connection of the source or destination DB. other than that i don't see the 'all' button than u mention.
where can i find it?
Sorry for all the questions...

Thanks.

Hi,

Please double-click the icon of the "Connection" in the "Connection Managers" tab.

You get a window called "Connection Manager".

Here you must have a left pane where you see "Connection" which should be highlighted.

In the main portion of the window you see the "Server Name", "Log on to the server" (for Authentication) and "Connect to a database".

On the left pane, just below "Connection" you should be able to find a tab called "All". Click on this tab and the main portion of the window should now show you properties like "Advanced", "Initialization", "Named ConnectionString", "Pooling", "Security", etc.

Please check the value against "Initialization" > "Connect Timeout".

Thanks and Regards,

B@.ns

|||

in the BIDS:

i double click the icon of the "Connection" and got the SMO connection manager editor dialog box, there i can configure the connection of the source or destination DB. i didn't find the window called "Connection Manager".

where is it ?

|||OK, it finally clicked. You are using the Transfer SQL Server Objects task. Try using a data flow with an OLEDB Source and OLEDB Destination instead.|||

yes, I'm using the sql server object task.

I try now the data flow oleDB source and destination.

now when I double click the connection in the connection manager i indeed see the 'ALL' in the left side.

the value 0 is what I need for the connection and general timeout property, right?

However, I'm not so familiar with this way of transfering data. i dragged the oleDB source and oleDB destination from the toolbox. i configured the connections but i see there an option to select only one table to transfer. i need to transfer data of many tables.

in the oleDB source editor dialog window i have: oleDB connection manager, then data access mode where i can choose table of view, sql command or sql command from variable and then i can choose table or view, but only one.

How can I transfer many tables?

Thanks alot for your answers.

|||You'd have to create more data flows with their own source and destination. I'd recommend that you use the SQL Server Transfer Objects task to move your smaller tables, and use the data flow tasks to move only the large tables.|||Thanks, I will try it and let u know.

Thursday, March 29, 2012

Error when trying to open report in VS.NET

Tuesday, March 27, 2012

Error when trying to create new databaase using SQL Server

Sunday, February 19, 2012

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error that has nothing to do with my cube

Error testing sql mail

Error Starting Script Editor in SSIS

Error Starting Script Editor in SSIS

Error Starting Script Editor in SSIS

Error Starting Script Editor in SSIS

Wednesday, February 15, 2012

Error Scripting Procs: Failed to retrieve dependency information

Error Scripting Procs: Failed to retrieve dependency information

Error Scripting Procs: Failed to retrieve dependency information

Error Scripting Procs: Failed to retrieve dependency information

error running ssis package

Error running report

Blog Archive

About Me