Answer Questions
Mick Badran - MVP Data sources and deployment of packages
I notice that when deploying a package that uses data sources behind its connection managers, the deployed package has the connection string built within the package that gets deployed. From a previous post from Kirk - "What I'd suggest is that you create a Data source per machine and have all the connections reference it. You'll still need to create a connection manager in each package, but they will all reference the same data source. Moving t ...Show All
Rey_S2006 SQL Server Integration Tutorial- Lesson1 -Customers.xls
Hi, I'm fairley new to SQL Server 2005. I've started to work with the tutorials to get a grip of it all... but when I'm running the wizard to create a packade I cannot find the folder Samples in the 90-folder... and the file Customers.xls is nowhere to find in any of the folders in MS SQL Server 2005 folder... I downloaded and ran BOL from april2006 and also SP1 for SQL Server 2005... Where can I find the right material to run the tutorial ...Show All
edit_21 Funny problem (bug?) using MAX() on SQL Mobile
This sure looks like a bug, but I'm still new... First I create a simple database: SqlCeEngine eng = new SqlCeEngine ( @"Data Source=\My Documents\test.sdf" ); eng.CreateDatabase(); eng.Dispose(); Then I put something in it: SqlCeConnection conn = new SqlCeConnection(@"Data Source=\My Documents\test.sdf"); SqlCeCommand cmd = new SqlCeCommand("CREATE TABLE myTable (ID int, name nchar(10))"); cmd.Co ...Show All
Pete Brubaker IIS error on New Subscription
hi. i was following the newbie's guide: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp frame=true on the creating a new subscription i was doing okay until i get to the last part wherein i click finish and this error pops up when it starts synchronizing data.. An error has occured on the computer running IIS. Try restarting the IIS server. i already tried restarting the server.. is there ...Show All
bocean How to show two dataset with equal & non equal of multiple selection.
Dear Friends, In my report, I am having Listbox for users to choose Country, City & Company. The user can choose Country. Based on the country selection, cities will be listed out. Based on the city selection, Companies will be listed out. They can choose companies. Now, I have to show two set of results. A. List of Companies as per selection ( dataset with equal to selection ) B. List of Companies which are not selected ( ie dat ...Show All
Ken Grissom CD Install
I would like to extract the self extracting exe files to go to a directory so I can burn a CD. I have tried burning the CD's from the temp directory but it wouldn't install properly from the CD. Is there a command line parameter to get around this TIA Add "/x" (no quotes) to any of the express packages (e.g. SQLEXPR.EXE /x) and you will be prompted for a directory to extract the files to. Regards, ...Show All
Laitu store procedure
Hi, I am shine. I've created a store procedure create procedure sp_tab_nam @tab_nam sysname,@fk_id int,@fk_out int output,@nl_out int output as set @fk_out=1 set @nl_out=0 execute('if exists(select * from '+@tab_nam+' where categoryid= '+@fk_id+' ) begin select '+@fk_out+' = categoryName from categories print ''shine'' end ELSE begin select '+@nl_out+' as outputs print ''kumar'' end ') and it's giving one error when e ...Show All
wolka Get "Do you want to save this file?" when trying to launch Report Builder
This may be a simple setup issue on my XP client, but whenever I click "Report Builder" I get a "Do you want to save this file " dialog box and nothing happens. I believe Reporting Services is installed correctly on my Win Server 2003 because when I click "Report Builder" on the server itself it does the proper click-once stuff (checks to see if the app is there and downloads it if isn't) and launched Report Builder.&nbs ...Show All
Siddharth Patil Connection Timeout - Need Help
Hello, My app uses sql express on the client work station and has been installed by our application installer as a part of the prerequisites. The sql express install in standard and we've not changed any settings or brought in any tweaks. All is well in our dev center. However, some of our clients are experiencing a problem when the app starts up. After the PC has been restarted, running the application causes it to crash with a connection ...Show All
gtr1963 Import and Export Data tool bug
Hi, I'm tring to import an Access database to a MsSQL Server 2000 SP4 using Import and Export Data tool which comes with SQL server 2000. After the import finishes with result: "Success", I saw that there are records which aren't exported. These records type is Memo in the Access database. But some of them are filed in others aren't. Is there a fix for this Is there another way to import this records Using TSQL Thanks guys. ...Show All
MaheshAtchuthan Children of the Children in MDX
Hi, all I'm quite new to MDX. What I'd like to know is weather it is possible to select all the children of the children of a given node in one-line query. Say we have [Driver].[All Drivers] dimension level. And I want to do something like "[Driver].[All Drivers]. Children .Children" instead of obtaining the results with the use of "CrossJoin/Union" . E. g.: { Crossjoin({[Driver].[All Drivers].[564654 - Andrew]}, &nb ...Show All
yatingg Time Dimension error
Hi, I've created a cube and now i'm trying a add a time dimension, it gives me an error. the time dimension i've created is using server time dimensions which has year, quarter, month and date attributes, when browse the dimension it looks fine but i'm trying to add this to cube and try to process cube it give a me this error Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Ticket, Column: ...Show All
lfair Parameter that can change
In the sql statement underneath, the parameter @erkenning should change wether the user gave in an option or not. If the user selects 'Geen' in the combobox then there should be: erkenning IS NULL If the user selects 'something' in the combobox else then 'Geen' the statement should be: erkenning = 'Something' I've tried to implement this in the statement underneath but it's not working. The syntax is wrong. [CODE] SELECT a.jaar, a.maand, a.naam, ...Show All
SheRa Report Builder fatal error
and yeee it’s me again :-) cannot load the report buider from http://localhost/reports result is always: Source: .NET Runtime 2.0 Error Reporting EventID: 5000 EventType clr20r3, P1 reportbuilder.exe, P2 9.0.242.0, P3 4258a543, P4 reportbuilder, P5 9.0.242.0, P6 4258a543, P7 3558, P8 b, P9 system.argumentexception, P10 NIL. any possibiblities to solve this kindest regards from austria Irie Mikky hmm am i the only one who has to fig ...Show All
Jim Fafrak Excel functions in calculated measures or queries
We used the Excel function FINV() in a calculated measure in Analysis Services 2000. Supporting these Excel functions seeems to be default in Analysis Services 2005, because the ExcelMDX assembly is included in the general assemblies (although there is set no source in the assembly properties). However, it is not possible to use any Excel function in an query or a calculated measure. Does anyb ...Show All