Bind SQL reporting services (Reports) to ASP.NET (Urgent)

Hi all,

Currently I have a project that require me to use reporting services (Reports) together with ASP.net web application.

However, I have the following problem.

I have an asp.net web application. From there, I have a textbox whereby user can type a specific date. The specific date should then be incorporate with the sql reporting services. The report that is being generated will contain data that is on the specific date.

How can I do that?

I try to search through the internet but to no result. Can anyone help out?

Thank you so much.Read a book on Reporting Services ... you can pass everything to Reporting Services through the webservices it exposes ...
Microsoft has some good books about Reporting Services ... Search for William Vaugh ... He's very good

Big Problem on Merge Replication

Hi, I'm working on a project taht involve SQLSever 2K and SQLSevre CE.
We have about 50 remote terminal that daily sincronize with one server but
each day something wrong happend.
The last one in order of time is this error
Error number 80004005
Native number 29006
Error descripcion: A call to SQL Server reconcilier failed. [,,,,,]
SSCE_M_SQLRECONCILIERFAILED
Followed by:
Source: Merge replication provider
Error number 80045063
Error descripcion: Failed to enumerate changes in the filtered articles
and then by this:
Source: srtv
Error number : 0
Native number: 0
Error descripcion: Call sp_MSsetupbelongs (?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)
Usually at this time the only possibility is to delete the sdf database and
to resincronize the remote terminal.
I have already found an article in KB 328314 - FIX: Cannot Upload Null
Values in Sql_variant Data Type by Using SQL Server CE Merge Replication
but without possible solution and the strange thing is that I have no
Sql_variant Data on my Db.
Please help me because the project is at high risk of crash!!!
Thanx in advance
Best Regards
Gianluca Padovani
what happens if you restart your application that runs the merge pull?
Normally this will clear this error.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Gianluca Padovani" <Gianluca Padovani@.discussions.microsoft.com> wrote in
message news:2F7758AC-A8C6-40B9-8EE1-3C2B0ACEBD1F@.microsoft.com...
> Hi, I'm working on a project taht involve SQLSever 2K and SQLSevre CE.
> We have about 50 remote terminal that daily sincronize with one server but
> each day something wrong happend.
> The last one in order of time is this error
> Error number 80004005
> Native number 29006
> Error descripcion: A call to SQL Server reconcilier failed. [,,,,,]
> SSCE_M_SQLRECONCILIERFAILED
> Followed by:
> Source: Merge replication provider
> Error number 80045063
> Error descripcion: Failed to enumerate changes in the filtered articles
> and then by this:
> Source: srtv
> Error number : 0
> Native number: 0
> Error descripcion: Call sp_MSsetupbelongs (?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)
> Usually at this time the only possibility is to delete the sdf database
and
> to resincronize the remote terminal.
> I have already found an article in KB 328314 - FIX: Cannot Upload Null
> Values in Sql_variant Data Type by Using SQL Server CE Merge Replication
> but without possible solution and the strange thing is that I have no
> Sql_variant Data on my Db.
> Please help me because the project is at high risk of crash!!!
> Thanx in advance
> Best Regards
> Gianluca Padovani
|||Hi Hilary,
thanks for your help, I'm waiting for the response to your test request and
asap i'll give you the answer.
In the meanwhile I can tell you another thing. In My previous post I put the
PocjePC error but at the same time I have a corresponding one on SQLServer
Merge Agent.
The erorr is :
Last Command: {call sp_MSsetupbelongs(?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)}
Failed to enumerate changes in the filtered articles.
(Source: Merge Replication Provider (Agent); Error number: -2147200925)
The merge process timed out while executing a query. Reconfigure the
QueryTimeout parameter and retry the operation.
(Source: srvtv (Data source); Error number: 0)
I made a quick search into the NG and I have found another couple of article
regarding this error.
I one of those article Paul Ibison suggest one FIX
(http://support.microsoft.com/?id=814916 ) to correct this error. May I use
it too?
Again thanks a lot for your help
Best Regards
Gianluca Padovani
|||Hi Hilary
I have got the confirm that if I reset the application and run it again the
error is cleared. This is a goal but is notthe solution because two session
of sincronization means an overhead of time not acceptable for our situation.
I hope in your answer about my previus message regarding the hotfix
Thanx again
Gianluca PAdovani
"Hilary Cotter" wrote:

> what happens if you restart your application that runs the merge pull?
> Normally this will clear this error.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Gianluca Padovani" <Gianluca Padovani@.discussions.microsoft.com> wrote in
> message news:2F7758AC-A8C6-40B9-8EE1-3C2B0ACEBD1F@.microsoft.com...
> and
>
>

BIDS interface question

Hi,

When I open a project in BIDS, for some reason it automatically opens a new tab for each and every package in the project, which is both time consuming and a bit annoying.

I don't want to open a tab for a package unless I do it myself.

Is there a way to turn off this behavior?

Thanks

BIDS is trying to open every single package you left open the last time closed it. I always try to open only packages that I am working on and close them before closing BIDS. One shortcut is to choose 'Close Solution (or project)' from File menu before exiting.

BI Studio shuts automatically

I am having a weird trouble with BI Studio. Whenever I start a integration services project the BI Studio just closes automatically. any idea whats going on here? is this a bug? I am already on sp2.

Hello,

are you sure you have necessary SSIS components installed. Has it been working on that machine at all?

Thanks.

BI on Windows XP

I want to create report through Microsoft Visual Studio 2005 (Business
Intelligence Project (Report Server Project) in Windows XP.
Which SQL Edition I can install in windows XP that gives me facility to
create report via Business Intelligence.
ThanksFirst, keep in mind that you are installing the BI Tools, you are not
installing SQL Server, you are not installing Reporting Services. Those are
server based and while they can be installed on XP (I know developers
edition, not sure what other editions) they are not needed for development.
The BI Tools are the same as far as I know for all editions. You can preview
the report, design the report. It is not until you are ready to deploy the
report to a server that RS even has to be installed somewhere.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rogers" <naissani@.hotmail.com> wrote in message
news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>I want to create report through Microsoft Visual Studio 2005 (Business
>Intelligence Project (Report Server Project) in Windows XP.
> Which SQL Edition I can install in windows XP that gives me facility to
> create report via Business Intelligence.
> Thanks
>|||Alright, that means when I installed SQL Server 2005 Developer Edition on
XP, the BI will also be installed?
Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u4wyxqXFIHA.3980@.TK2MSFTNGP03.phx.gbl...
> First, keep in mind that you are installing the BI Tools, you are not
> installing SQL Server, you are not installing Reporting Services. Those
> are server based and while they can be installed on XP (I know developers
> edition, not sure what other editions) they are not needed for
> development. The BI Tools are the same as far as I know for all editions.
> You can preview the report, design the report. It is not until you are
> ready to deploy the report to a server that RS even has to be installed
> somewhere.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>>I want to create report through Microsoft Visual Studio 2005 (Business
>>Intelligence Project (Report Server Project) in Windows XP.
>> Which SQL Edition I can install in windows XP that gives me facility to
>> create report via Business Intelligence.
>> Thanks
>>
>|||No, the install is a two step process. There is server side install which
includes reporting services (if you selected to install it) and then there
is installing client side tools. You have to do separate installs. Normally
the BI tools would not be on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rogers" <naissani@.hotmail.com> wrote in message
news:ugJQ2LKHIHA.6068@.TK2MSFTNGP05.phx.gbl...
> Alright, that means when I installed SQL Server 2005 Developer Edition on
> XP, the BI will also be installed?
> Thanks
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:u4wyxqXFIHA.3980@.TK2MSFTNGP03.phx.gbl...
>> First, keep in mind that you are installing the BI Tools, you are not
>> installing SQL Server, you are not installing Reporting Services. Those
>> are server based and while they can be installed on XP (I know developers
>> edition, not sure what other editions) they are not needed for
>> development. The BI Tools are the same as far as I know for all editions.
>> You can preview the report, design the report. It is not until you are
>> ready to deploy the report to a server that RS even has to be installed
>> somewhere.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rogers" <naissani@.hotmail.com> wrote in message
>> news:%23M9tGuWFIHA.3360@.TK2MSFTNGP04.phx.gbl...
>>I want to create report through Microsoft Visual Studio 2005 (Business
>>Intelligence Project (Report Server Project) in Windows XP.
>> Which SQL Edition I can install in windows XP that gives me facility to
>> create report via Business Intelligence.
>> Thanks
>>
>>
>

BI Development Studio: Crashes when viewing a Cube in the Browser

Hello, I created an Analysis Services project, defined the views and the cube itself. After I deployed the cube, I wanted to compare the results with the browser.

Everytime I try to open the browser, BIDS starts loading, but after a while it crashes.

Is this a known error?

Thanks in advance!

Are you running Office 2007 on the same machine as BIDS? Is it a beta version of Office 2007?

You have not told us about the sp for SQL Server 2005 or if you run a version of Office 2003 or later on the same machine.

Try downloading SP2 CTP3 (December 2006) from www.microsoft.com/sql and see if it helps.

Regards

Thomas Ivarsson

|||

Yes, I do run Office2003 on my machine, btw it is an Acer5102-notebook. I installed the SP2 CTP3, but the error still occurs.

Any other suggestions, it is really urgent?

Thanks in advance!

|||

I hope by the word "crash" you do not mean that you get a hour glass.

1. Do you run any Firewall? I have seen some issues with Integrity where one would not be able to browse the cube.

2. Did you try browsing the cube from any other application instead of VS? like Excel

3. Also are you trying to go to the Browse tab after the cube is completely deployed. I have some instances where if you try to shift tabs while the cube is being deployed the VS crashes (shuts down completely and launches again)

See, if it is related to any of the aboce behaviors?

|||

I have never had any problem with BIDS and Office2003 since SQL Server 2005 RTM.

Try to install this add in for Excel 2003 and connect to the cube: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

Have you runned windows update and especially office update lately?

Regards

Thomas Ivarsson

BI Development Studio: Crashes when viewing a Cube in the Browser

Hello, I created an Analysis Services project, defined the views and the cube itself. After I deployed the cube, I wanted to compare the results with the browser.

Everytime I try to open the browser, BIDS starts loading, but after a while it crashes.

Is this a known error?

Thanks in advance!

Are you running Office 2007 on the same machine as BIDS? Is it a beta version of Office 2007?

You have not told us about the sp for SQL Server 2005 or if you run a version of Office 2003 or later on the same machine.

Try downloading SP2 CTP3 (December 2006) from www.microsoft.com/sql and see if it helps.

Regards

Thomas Ivarsson

|||

Yes, I do run Office2003 on my machine, btw it is an Acer5102-notebook. I installed the SP2 CTP3, but the error still occurs.

Any other suggestions, it is really urgent?

Thanks in advance!

|||

I hope by the word "crash" you do not mean that you get a hour glass.

1. Do you run any Firewall? I have seen some issues with Integrity where one would not be able to browse the cube.

2. Did you try browsing the cube from any other application instead of VS? like Excel

3. Also are you trying to go to the Browse tab after the cube is completely deployed. I have some instances where if you try to shift tabs while the cube is being deployed the VS crashes (shuts down completely and launches again)

See, if it is related to any of the aboce behaviors?

|||

I have never had any problem with BIDS and Office2003 since SQL Server 2005 RTM.

Try to install this add in for Excel 2003 and connect to the cube: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

Have you runned windows update and especially office update lately?

Regards

Thomas Ivarsson

BI Development Studio not showing "create new project" on file menu

I just installed Reporting Services 2005 but when I start up SQL
Server Business Intelligence Development Studio I'm stuck. I don't
even have "create new project" as an option on my file menu, instead I
have "create team project" or "create file".
I previously had Visual Studio with Team Foundation Server on my
machine, but I only used it to log bugs. When I installed SS2005 and
reporting services I actually uninstalled the copy of Visual Studio I
had on my machine but that hasn't helped.
I don't want to create a teams project (and I don't haver permissions
anyway), I just want to use reporting services but it seems stuck in
some TFS mode. I'd take out the TFS part if I could figure out how
to.
Any ideas? Thanks in advance.Try to uninstall the TFS and reinstall visual studio 2005
Amarnath
"doug.andersen@.gmail.com" wrote:
> I just installed Reporting Services 2005 but when I start up SQL
> Server Business Intelligence Development Studio I'm stuck. I don't
> even have "create new project" as an option on my file menu, instead I
> have "create team project" or "create file".
> I previously had Visual Studio with Team Foundation Server on my
> machine, but I only used it to log bugs. When I installed SS2005 and
> reporting services I actually uninstalled the copy of Visual Studio I
> had on my machine but that hasn't helped.
> I don't want to create a teams project (and I don't haver permissions
> anyway), I just want to use reporting services but it seems stuck in
> some TFS mode. I'd take out the TFS part if I could figure out how
> to.
> Any ideas? Thanks in advance.
>

BI Dev Studio cannot connect ot SQL Server 2005

Hello,

I am new to SQL Server and I am trying to use BI Dev Studsio for a data mining project.The first problem I get is that I cannot see the SQL Server in the BI.

I am trying to create a data source and I cannot connect to the server at all.

Does anybody have an idea what could be going wrong?

I assume you mean the relational source? Can you connect from SQL management studio or any other client application?

BI Deployment Experiences

I'm trying to get some info on how other companies are handling BI
implementations. We have a data warehouse project that we expect will have
continuos changes. That is, new data sources coming in, more reports, etc.
That implies new Integration Services packages, new Reporting Services
reports, changes in tables, view, stored procedures, etc. We also have a 3
environment installation: Development, QA, Production.
I would appreciate any info on how other people are handling this. Can you
manage with only Visual Studio? Is there any third vendor tool anybody would
recommend? The issue is that we could potentially have the 3 environments
with different versions and we might want to move objects from development t
o
QA, for example, without just duplicating the 2 environments (we could have
different stages of development and only want to move finished objects).
Any help is appreciated,
Carmen.We have pretty much the exact same setup you do. We use Visual Studio and
Visual Source Safe to manage all our code. Using the new features for
managing environments within Visual Studio - makes promoting SSIS packages a
snap. Using DTS was more challenging when you for example moved from DEV to
TEST you had to change all your data sources to point to new places - but
SSIS makes that part easy.
If you tie your solutions into VSS and have your coders do all their work
inside of VSS - that will ensure it's managed correctly. Where I work won't
spring for the new Visual Studio Team Edition for DB Professionals - but
that def makes things easier in managing your DB code within the same
solution as your SSIS packages. You can still add the DB into your
solution, but not have ALL the cool features Team Edition offers.
So our developers, by using the VSS integration inside VS, it auto checks
out all the code, whether it be packages or stored procedures. Your
promoting to new environments from Visual Source Safe will endure you are
promoting the right stuff.
It's not that hard - once you get it sorted out and documented and follow
the process - you will be good.
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.|||Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
AS syncronize feature (again via XMLA scripts). Works fine - and no
Integration Services required.
Chris
www.activeinterface.com
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.|||Chris,
Thanks for the info!
Carmen.
"ChrisHarrington" wrote:

> Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
> AS syncronize feature (again via XMLA scripts). Works fine - and no
> Integration Services required.
> Chris
> www.activeinterface.com
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>
>|||Joe,
Thanks for the info. I'll definitely investigate the options you mentioned.
Carmen.
"Joe" wrote:

> We have pretty much the exact same setup you do. We use Visual Studio and
> Visual Source Safe to manage all our code. Using the new features for
> managing environments within Visual Studio - makes promoting SSIS packages
a
> snap. Using DTS was more challenging when you for example moved from DEV
to
> TEST you had to change all your data sources to point to new places - but
> SSIS makes that part easy.
> If you tie your solutions into VSS and have your coders do all their work
> inside of VSS - that will ensure it's managed correctly. Where I work won
't
> spring for the new Visual Studio Team Edition for DB Professionals - but
> that def makes things easier in managing your DB code within the same
> solution as your SSIS packages. You can still add the DB into your
> solution, but not have ALL the cool features Team Edition offers.
> So our developers, by using the VSS integration inside VS, it auto checks
> out all the code, whether it be packages or stored procedures. Your
> promoting to new environments from Visual Source Safe will endure you are
> promoting the right stuff.
> It's not that hard - once you get it sorted out and documented and follow
> the process - you will be good.
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>

BI Deployment Experiences

I'm trying to get some info on how other companies are handling BI
implementations. We have a data warehouse project that we expect will have
continuos changes. That is, new data sources coming in, more reports, etc.
That implies new Integration Services packages, new Reporting Services
reports, changes in tables, view, stored procedures, etc. We also have a 3
environment installation: Development, QA, Production.
I would appreciate any info on how other people are handling this. Can you
manage with only Visual Studio? Is there any third vendor tool anybody would
recommend? The issue is that we could potentially have the 3 environments
with different versions and we might want to move objects from development to
QA, for example, without just duplicating the 2 environments (we could have
different stages of development and only want to move finished objects).
Any help is appreciated,
Carmen.
We have pretty much the exact same setup you do. We use Visual Studio and
Visual Source Safe to manage all our code. Using the new features for
managing environments within Visual Studio - makes promoting SSIS packages a
snap. Using DTS was more challenging when you for example moved from DEV to
TEST you had to change all your data sources to point to new places - but
SSIS makes that part easy.
If you tie your solutions into VSS and have your coders do all their work
inside of VSS - that will ensure it's managed correctly. Where I work won't
spring for the new Visual Studio Team Edition for DB Professionals - but
that def makes things easier in managing your DB code within the same
solution as your SSIS packages. You can still add the DB into your
solution, but not have ALL the cool features Team Edition offers.
So our developers, by using the VSS integration inside VS, it auto checks
out all the code, whether it be packages or stored procedures. Your
promoting to new environments from Visual Source Safe will endure you are
promoting the right stuff.
It's not that hard - once you get it sorted out and documented and follow
the process - you will be good.
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.
|||Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
AS syncronize feature (again via XMLA scripts). Works fine - and no
Integration Services required.
Chris
www.activeinterface.com
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.
|||Chris,
Thanks for the info!
Carmen.
"ChrisHarrington" wrote:

> Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
> AS syncronize feature (again via XMLA scripts). Works fine - and no
> Integration Services required.
> Chris
> www.activeinterface.com
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>
>
|||Joe,
Thanks for the info. I'll definitely investigate the options you mentioned.
Carmen.
"Joe" wrote:

> We have pretty much the exact same setup you do. We use Visual Studio and
> Visual Source Safe to manage all our code. Using the new features for
> managing environments within Visual Studio - makes promoting SSIS packages a
> snap. Using DTS was more challenging when you for example moved from DEV to
> TEST you had to change all your data sources to point to new places - but
> SSIS makes that part easy.
> If you tie your solutions into VSS and have your coders do all their work
> inside of VSS - that will ensure it's managed correctly. Where I work won't
> spring for the new Visual Studio Team Edition for DB Professionals - but
> that def makes things easier in managing your DB code within the same
> solution as your SSIS packages. You can still add the DB into your
> solution, but not have ALL the cool features Team Edition offers.
> So our developers, by using the VSS integration inside VS, it auto checks
> out all the code, whether it be packages or stored procedures. Your
> promoting to new environments from Visual Source Safe will endure you are
> promoting the right stuff.
> It's not that hard - once you get it sorted out and documented and follow
> the process - you will be good.
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>

BI Accelerator experiences...?

Hi,
I'm just embarking on a data warehousing project for the first time. I have
a good understanding of the general principles - dimensional modelling, fact
tables, ETL, data staging, cubes, etc.
I am interested to get feedback from people who have used BI Accelerator for
SQL Server 2000 to automate the task of building a data warehouse and
analytical applications. Does it work as advertised? How productive can you
be compared to 'hand coding' the process?
Also, I would like to know why the production deployment of BI Accelerator
applications requires SQL Server Enterprise edition?
Thanks, in anticipation.
Chrisamong other reasons - partitioning
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community
Website: http://www.sqlJunkies.com/newsgroups/

BI Accelerator 1.1 and Bulk Insert

Dear Anyone,

I had been using BI Accelerator 1.1 for 2 years now. In our current project, I encountered the following error during the importing phase of BI.

I traced the problem to the bulk insert statement that BI Accelerator is executing which is ...

BULK INSERT [Project88_Staging]..[S_Fact_BrdcastAlert] FROM 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\Import\S_Fact_BrdcastAlert.txt' WITH ( FORMATFILE = 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\DTS\Import\Format\S_Fact_Brdcast Alert.fmt' , DATAFILETYPE = 'widechar', BATCHSIZE = 100000 , MAXERRORS = 100 )

The error that it generates is as follows:

Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.

We export data to text files that BI Accelerator picks up. All other files imports properly imported without problems except for one fact table text file. We use the same format file that BI Accelerator uses to export to file the data to make sure that there would be no incompatabilities. File size is about 2.3GB++, which is a standard size with our other fact table files that doesnt have any errors.

We also checked for data error which we found none. We also checked the txt file we generate, notepad confirms that it is a unicode file.

Can anyone please shed a light in what is happening. Is this a bug? As much as possible I dont want to place a workaround on this one since our entire framework for loading data is all the same and has already been set up. Any help would be apreciated.

Thank YouAny reply would be appreciated.

Joseph Ollero
jollero@.wizardsgroup.com

best way to write to DB for ASP 2.0 project?

Following is a stored procedure I'm thinking of using in my ASP 2.0 project and I need opinions so I can evaluate if this is the optimum way to access and write to my database. I will be writing to an extra table (in addition to the standard aspnet_ tables). If you can please let me know your opinion, I'd appreciate it.

@.UserNamenvarchar(128),
@.Emailnvarchar(50),
@.FirstNamenvarchar(25),
@.LastNamenvarchar(50),
@.Teachernvarchar(25),
@.GradYrint

DECLARE@.UserIDuniqueidentifier
SELECT@.UserID =NULL
SELECT @.UserID = UserIdFROMdbo.aspnet_UsersWHERE LOWER(@.UserName) = LoweredUserName
INSERT INTO[table name]
(UserID,UserName,Email,FirstName,LastName,Teacher,GradYr)
VALUES(@.UserID,@.UserName,@.Email,@.FirstName,@.LastName,@.Teacher,@.GradYr)

Also, add some error handling in the stored procedure after the insert. Something like as follows.

SET @.returnstatus = @.@.error

IF @.returnstatus <> 0
BEGIN
RETURN @.returnstatus
END

|||

From what you show, it seems like you are making a "custom" way to just write Profile data (email, First, last, Teacher, GradYr). If you enable the Profile provider and supply these fields, you can use the built-in provider to do this kind of stuff - - no need to write your own.

|||

pbromberg:

From what you show, it seems like you are making a "custom" way to just write Profile data (email, First, last, Teacher, GradYr). If you enable the Profile provider and supply these fields, you can use the built-in provider to do this kind of stuff - - no need to write your own.

OK, I give. I just read a bunch of articles on the subject of profile provider and none of them really helped me--seemed like they were talking about creating instead of enabling profiles. Where's some good, simple information on activating the built-in provider. The closest I've come is implementing _CreatingUser on the CreateNewUser wizard, and listing the field names from my new table in web.config. If you can educate we where to go from here in order to enable the profile provider, I'd appreciate it.

|||

I just read up on profiles in Walther'sUnleashed book, and came up with the stuff below for web.config. I get Intellisense in the code-behind, which is a good sign, but when I run the page, I can't get it right for "type = " and the book doesn't elaborate on it. Not having the correct entry for the type criteria or omitting it produces an error. If someone can help me on this, I think I'll be in good shape.

One other thing: Should I use a separate table (shown as tblAlumni below) or use one of the standard aspnet tables? I'd prefer the latter to keep things the most simple, but Walther shows an "outside" table. Thanks in advance for any help.

<profile defaultProvider="DNProfileProvider"> <properties> <add name="FirstName" /> <add name="LastName" /> <add name="GradYr" type="integer"/> <add name="Address1" /> <add name="Address2" /> <add name="City" /> <add name="State" /> <add name="Zip" /> <add name="SpouseName" /> <add name="Gender" /> <add name="MaidenName" /> <add name="Phone" /> </properties> <providers> <add name="DNProfileProvider" type="??" connectionStringName="sqlConnection" profileTableName="tblAlumni"/> </providers> </profile>

|||

It depends on how the Profile class is written. The default profile provider has its own table and it can hold any type and number of fields that you define for each profile. However, this data is "opaque" in the database - you cannot easily search on it. If you want to use a custom profile provide as it seems from the snippet you posted, then it may use it's own table. There are some samples for "Table Profile Provider" and "Stored Procedure Profile Provider" that you can use as a model if you want a custom table.

Here is an article with some examples:

http://www.eggheadcafe.com/articles/20060731.asp

|||

muybn:

Following is a stored procedure I'm thinking of using in my ASP 2.0 project and I need opinions so I can evaluate if this is the optimum way to access and write to my database. I will be writing to an extra table (in addition to the standard aspnet_ tables). If you can please let me know your opinion, I'd appreciate it.

@.UserNamenvarchar(128),
@.Emailnvarchar(50),
@.FirstNamenvarchar(25),
@.LastNamenvarchar(50),
@.Teachernvarchar(25),
@.GradYrint

DECLARE@.UserIDuniqueidentifier
SELECT@.UserID =NULL
SELECT @.UserID = UserIdFROMdbo.aspnet_UsersWHERE LOWER(@.UserName) = LoweredUserName
INSERT INTO[table name]
(UserID,UserName,Email,FirstName,LastName,Teacher,GradYr)
VALUES(@.UserID,@.UserName,@.Email,@.FirstName,@.LastName,@.Teacher,@.GradYr)

A new problem has arisen, having to do with database, that I need to resolve first. I make an entry to my form, save it to the database; then the next entry I make throws the error that the same UID can't be written to the database. I believe that, Mr. DB, but since when am I writing the same UID to you? I don't know where to start tracing this, except to show the stored proc again (above), and to describe my process and some of my code that might generate it.

 
Protected Sub cuwCreateUserWizard1_CreatingUser(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles cuwCreateUserWizard1.CreatedUser strEmail =CType(cuwCreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("Email"), TextBox).Text strUserName =CType(cuwCreateUserWizard1.CreateUserStep.ContentTemplateContainer.FindControl("UserName"), TextBox).Text.ToLower strFirstName =CType(cuwCreateUserWizard1.CreateUserStep.CustomNavigationTemplateContainer.FindControl("txtFirstName"), TextBox).Text strLastName =CType(cuwCreateUserWizard1.CreateUserStep.CustomNavigationTemplateContainer.FindControl("txtLastName"), TextBox).Text lngGradYr =CType(cuwCreateUserWizard1.CreateUserStep.CustomNavigationTemplateContainer.FindControl("txtGradYr"), TextBox).Text strTeacher =CType(cuwCreateUserWizard1.CreateUserStep.CustomNavigationTemplateContainer.FindControl("txtTeacher"), TextBox).TextEnd Sub Protected Sub cuwCreateUserWizard1_CreatedUser(ByVal senderAs Object,ByVal eAs System.EventArgs)Handles cuwCreateUserWizard1.CreatedUserDim cmdAs New SqlCommand("sp_CreateUser", con) cmd.CommandType = Data.CommandType.StoredProcedure cmd.Parameters.AddWithValue("@.UserName", strUserName) cmd.Parameters.AddWithValue("@.Email", strEmail) cmd.Parameters.AddWithValue("@.FirstName", strFirstName) cmd.Parameters.AddWithValue("@.LastName", strLastName) cmd.Parameters.AddWithValue("@.Teacher", strTeacher) cmd.Parameters.AddWithValue("@.GradYr", lngGradYr) Using con con.Open() cmd.ExecuteScalar() con.Close()End Using cmd.Equals(Nothing)End Sub
  

Please let me know any other info you'd need to help me determine what's wrong.

|||

Can you please start a new POST / Thread. By this way we can concentrate your new issue. Since a post is marked as answered, every one will think that your issue is resolved. Hope you understand.

Best Way to Upgrade SQL 2000 to 2005

Hello,

I have a project where I have to upgrade SQL 2000 to 2005. When we are upgrading we are going to move to new server so server name will change. Most of our applications have a hard coded connection string. Applications are developed with Classic ASP, .NET 1.1 and 2.0 as well.

Now the question is what is the best way to do this? Changing all the connection string will be a very painful task as we have many applications.

Can anyone suggest a way where we can achieve this without changing all the connection strings?

Thanks in advance.

Tareq

first go to the folder where the mdf files resides and copy it and detach the database in sql 2000...

go to the folder where the sql 2005 databse exists.. paste the files u copied.. and then reattach the databases to it..

Hope this helps..

Regards,

Karen

|||

How would that help with the servername changes in the connection string?

|||

why dont u move all your connection strings to webconfig so suppose if anything happens to a server and something like this all u got to do... change the setting in the webconfig instead of the whole application.

|||

Ideally that is how it should be done and that is how I do it. But our previous developers did not do so that is the problem. Also Classic ASP does not use web.config. They use include files or hard coded in the code. If all the previous developers did it the right way it would have been a breeze. But unfortunately they did not do it the right way. We have over hundred of applications and hence this problem.

|||

Try the Find/Replace. I dont think there's any other way. While you are doing it manually you might as well spend the time to use one connectionstring throughout and put that in the web.config value.

Best way to update database behind firewall?

Hello

I have a project where I need to update a few tables in a SQL Server 2000
database which resides behind a firewall, ie port 1433 is blocked. I also
need to verify the updates were successful.
I am a C# developer. What are my options in doing this.. web services?

John DalbergHi

Assuming that you are not allowed to use a different port or a different
method of communicating directly with the database, then web services seems
the way to go!

John

"John Dalberg" <john_dd@.hotmail.com> wrote in message
news:x8g4yff5ouij.1ew6u2lc8iovb$.dlg@.40tude.net...
> Hello
> I have a project where I need to update a few tables in a SQL Server 2000
> database which resides behind a firewall, ie port 1433 is blocked. I also
> need to verify the updates were successful.
> I am a C# developer. What are my options in doing this.. web services?
> John Dalberg

Best way to make a database not in use?

Hi.

I am almost wrapping up a project of my own and I will have the option to restore the database, so dropping the existing one and then running the SQL script to create the database, tables, stored procedures and so on.

My question is, (using .NET 2.0 C#) - what is the best way to resolve the "cannot drop database as it is currently in use" message, or some message of the similar sort?

Even though I specified "USE MASTER" in the commandText string, there will be somewhere, in a situation, where the database will still be in use.

How can I forcefully make it NOT in use, drop it and do other things I like to?

What is the best way?

Many thanks!

Commonly we just cursor through open spids and execute KILL session_id/spid:

--2005
select session_id
from sys.dm_exec_requests
where db_name(database_id) = 'your database'

--2000 and earlier
select spid
from master..sysprocesses
where db_name(dbid) = 'your database'

|||Are you using SQL 2005? If so, in Management Studio, in Object Explorer, navigate to [Database Name]\Management\Acticity Monitor. Double click Activity Monitor - the Activity Monitor appears.

Using the Activity Monitor (with "Process Info" selected in the left-hand pane), you can see all active processes. As you have noticed, you won't be able to drop your database with active processes. Simply right-click processes that you wish to terminate, and choose "Kill Process". Note that you can see the database name as part of each process' information.

--

If you are using SQL 2000, (from my memory) an easy way to terminate all processes is to right-click the database, choose "Detach", and then when the dialog appears, there's an option to clear all existing users. After this has finished, you can drop the database.|||

Many thanks, I will give this a shot.

It's just amazing, how we can do ALL of this using SQL Server, kill processes, query the master tables as well as each of our own created tables/databases - fasinates me always :)

|||If you have any problems, or need to post again (SQL or otherwise), it's always helpful to specify product & the version of the software you are using. (SQL 2000 or SQL 2005, VB, VB.NET, C#, VS.NET 2003/2005 ... etc.)|||

Just:

use [YourDb]

alter database [YourDb] set single_user with rollback immediate

-- if there are no users with dbo permissions, you may use restricted_user instead

go

-- do your restore here

go

alter database [YourDb] set multi_user

|||gavrilenko_s - good suggestion. |||

ok, thanks for that

one more Q

if we have more than 1 SPID for a database, how can I kill them all?

I was thinking about doing this, however I think it's bad practice and prefer to do it the proper way!

DECLARE @.numberOfProcess int
SET @.numberOfProcess = 0
SET @.numberOfProcess = (select COUNT (spid) from master..sysprocesses where db_name(dbid) = 'db')
--SELECT @.numberOfProcess
IF (@.numberOfProcess > 0)
BEGIN
WHILE (@.numberOfProcess IS NOT NULL)
BEGIN
SET @.numberOfProcess = (select TOP 1 (spid) from master..sysprocesses where db_name(dbid) = 'db')
-- SELECT @.numberOfProcess
DECLARE @.SqlStatement NVARCHAR (20)
SET @.SqlStatement = 'KILL ' + CAST(@.numberOfProcess AS CHAR(2))
SELECT @.sqlStatement
EXEC sp_executesql @.SqlStatement
END

END

|||

Hi,

The method gavrilenko_s posted before is the best (which is always use for kicking users).

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Best way to do a dynamic bulk insert to a table

My current project is creating a social network for the university I work for. One of the features allows members of a group to send a message to all other group members. Currently, I run a foreach loop over each of the group members, and run a separate INSERT statement to insert a message into my messages table. Once the group has several hundreds members, everybody starts getting timeout errors. What is the best way to do this?

Here are two suggestions I've received: construct one sql statement that would contain multiple INSERT statements. It would be a large statement like:

INSERT into [messages] (from_user, to_user, subject, body) VALUES (@.from_user, @.to_user, @.subject, @.body); INSERT into [messages] (from_user, to_user, subject, body) VALUES (@.from_user2, @.to_user2, @.subject2, @.body2); INSERT into [messages] (from_user, to_user, subject, body) VALUES (@.from_user3, @.to_user3, @.subject3, @.body3);

etc...

Or, do the foreach loop in a stored procedure. I know the pros and cons of sprocs versus dynamic sql is a sticky subject, and, personally, I'd prefer to keep my logic in the C# code-behind file. What is the best way to do this is an efficient manner? I'd be happy to share some code, if that would help. Thanks for your input!

I think what you want is something like this. 1 single query.

INSERT into [messages] (from_user, to_user, subject, body)
SELECT @.from_user,userid,@.subject,@.body FROM groupmembers WHERE groupid=@.groupid AND userid<>@.from_user

Your input parameters:

@.from_user = the sending user
@.subject = the subject
@.body = the body
@.groupid=the recieving groupid

|||

If you going to insert data to a table that alreay has some data, I suggest you to use whatgunteman wrote.

If not, I suggest you to use:

1SELECT *2INTO MyNewTable-- it will be created automatically here3FROM MyTable1 t14INNERJOIN5 MyTable2 t26ON (t1.rid = t2.rid)7

Good luck.

|||

Thanks that worked like a charm. I can't believe I never thought of putting a subquery in an insert statement.

Best way to connect from VB6

I'm currently working on a project that is going to read/write lot of data into a SQL EXPRESS 2005.

What is BEST WAY(faster and reliable) for connecting, reading, writing updating from VB6...

The code below is working except the RecordCount that always returns -1

I've tried to do a Movelast before, doing so produce this error --> rowset does not support fetching backward

Private ObjConn As New ADODB.Connection
Private ObjRS As New ADODB.Recordset

...

in a function....
Dim i As Integer, j As Integer

With ObjConn
.ConnectionTimeout = 30
.CommandTimeout = 30
.Provider = "SQLOLEDB"
.ConnectionString = "Driver={SQL Native Client};Server=MACHINE\SQLEXPRESS;Database=DSD;UID=sa;PWD=MYPass;"
End With
ObjConn.Open
strRequest = "SELECT * FROM dbo.Site"
ObjRS.Open strRequest, ObjConn
j = 0
MsgBox ObjRS.RecordCount ' How to get NUMBER OF RECORDS BEFORE LOOPING ?

Do While Not ObjRS.EOF
task(j).SiteID = ObjRS.Fields(ObjRS.Fields(0).Name).Value
' THIS SECTIONS WORKS
ObjRS.MoveNext

j = j + 1
Loop
ObjConn.Close
test = task
End FunctionThanks for helping ! I'm stuck in the middle...

Merci

For MsgBox ObjRS.RecordCount ' How to get NUMBER OF RECORDS BEFORE LOOPING ?

Try one of the following

1) ObjRS.CursorLocation = adUseClient

2) ObjRS.Open strRequest, ObjConn, adOpenKeyset

Hope this helps

|||

The reason you can not move backwards or get the record count is because of the fact that you are getting the SQL Server Firehose cursor as a result. You can not get the record count until you reach the last record for your query. Similarly Firehose cursors do not support going backwards. The advantage of firehose cursors is that they are the fastest way of fetching SQL Server data, however they do not support updates. If you want to perform updates you have to request different cursor types when calling Open on the Recordset object. For example if you use Static cursor using adOpenStatic parameter to Open you will get the Recordcount correctly. Read the section title : "Understanding Cursors and Locks" in the ADO documentation in MSDN.

Thanks

Waseem Basheer

|||

RecordCount returns -1 when you are using a forward-only cursor or a dynamic cursor (see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprorecordcount.asp). Since the default is a forward only cursor, that would explain the behavior that you're seeing.

As Waseem mentions, this cursor type would also explain the behavior you're seeing with MoveLast.

If you switch to using a static cursor, this property should have the row count value that you were expecting (the code snippet doesn't appear to have any need to update data, so this would presumably be sufficient).