Answer Questions

• libyan Logging MDX queries in AS 2005.

  Hi, I was using the connection string property DBPROP_MSMD_LOG_FILE for getting MDX queries in a log file in AS 2000. But, it looks like this property has been dropped in AS 2005. Is there any alternate approach for achieving the same functionality in AS 2005 programatically Thanks in advance, Santosh. Dont know of any sample code working with OLEDB. Not sure at all OLEDB supports subscibing to a trace. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. In AS2005 you have way more poweful and robust way to look at any activity happening in your server. Now you can use SQL Server profiler to connect to Analysis Server and see any MDX, or XMLA command executed aga ...Show All

• hellomcv Configure a Child Package to use the configuration file of a Parent Package?

  Hi guys, Here's the deal. I have a child package, (say, pack01.dtsx), which uses a dtsconfig file for its connection string, which can be called from other packages, but which also can be called by itself. However I also have another package (say, pack02.dtsx) which uses the same dtsconfig file for its connection string. It calls on pack01.dtsx. When I use DTEXECUI and run pack01.dtsx, specifying the proper .dtsconfig file, it goes well. But when I try and run pack02.dtsx, an error occurs saying pack01.dtsx connection cannot be established. How do I pass the connectionstring being used by pack02 to pack01, without having to remove the configuration file setting of pack01 Can a Parent Package configuration and a configuration file try and m ...Show All

• Michael Schreuder some problem of Querie for "Select" & "Insert"

  I would like to run a query for get contious data ( like data_no=1 and data_no=2 ..... and data_no=2) I only know to run a query for get single data for example: select data_no from tableA where data_no=1 if I want to select mutiple and continue data what can I do after get data how can I insert mutiple data to DB for 1 query many thanks thanks but that's not what I mean ( sorry for confused) if I want to select No 2348~ NO 2982 .. I can't do "order by" select member_no from member where member_no= 2348 --------------------------------------- select member_no from member where member_no =2349 ..... I hope I can ...Show All

• chris441962 Credentials used to run this report are not stored

  Hi all, When I create a new report subscription in report manager, I got this error Credentials used to run this report are not stored any idea Thanks, Jone Jone, If you select the 'Credentials stored securely in the report server', you should not check the boxes for 'Use as Windows credentials when connecting to the data source' or 'Impersonate the authenticated user after a connection has been made to the data source'. After entering user name = 'sa' and password = 'access' , press Apply at the bottom and try to view your report. If this still doesn't work, you should try to login to the database using user name = 'sa' and password = 'access' through Management Studio to see ...Show All

• rodniko Domain group logins failing on SQL 2k5 workgroup

  This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're supposed to be able to access. The SQL Server is not a domain controller, but is a member of the domain, and domain logins do work for Windows-login purposes on this box. The problem is that when users try to connect to the SQL server, they are denied access. An error 18456 is thrown, and logged in the Application event log stating "L ...Show All

• Quinn01 value is null remotely - non null locally

  ok here is a WIERD issue. I've NEVER EVER had this issue, I have always done this and it works great both locally and remotely.   I have a table, which is a "customers" table. I have a stored procedure which takes in parameters (name, address, password etc...) and returns me back, via a parameter declared as output - the customer ID. I've always done this, and works great. Now, this works fine locally.   IF I try to run this/do the exact same execution of commands (create a customer) remotely (where the database is stored, so copying everything from local to "over there") it does not work. I get a DBNULL value back from the parameter, declared as an int output.   IF I copy and paste this Stor ...Show All

• cssjm How to Link to an existing SQLExpress 2005 table from Access 2003

  I initially created an Access application within Access 2003 which I subsequently migrated to SQLExpress 2005 (Tables only) using Microsoft SQL Migration Assistance for Access 2003 (SSMAA) and continue to use Access 2003 as a front end, this really was easy and worked perfect. Now I added a new table to my SQLExpress DB and need to link to it from my Access application but can not find a way to do so in the same way that the SSMAA does. I need to run the Access 2003 application in share mode from multiple PC in the LAN. If I try linking to the table using an ODBC connection I can only access from the PC where the link was done! Any ideas THanks in advance. Hello Carlos,   I think the problem must search where it is. ...Show All

• tigerlil Report Model Generator freezes VS2005

  Hi, I'm trying to generate data source model from appropriate relational data source view with Report Model Wizard. But at the end of "Step 2: processing rules on relations" Visual Studio devenv process aquires all CPU resources and freezes VS. What's wrong with my view May be it contains some features that aren't supported by model generation process. Regards, Anatoly. - DSV, DSV ...Show All

• COBOLBeginner Installing SQL Server 2005 on Windows VISTA ULTIMATE

  Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help. Right...but for SP2 it should allow me to install SQL Serevr2005 1st. It's giving me the warning and on moving ahead it's not giving me option to installing SQL Components (SQL Server, Analisys Server, Reporting Services etc.)...what I am getting is just to install Nat ...Show All

• Capt. KDS Remote Deployment

  What's the easiest way to deploy a project to a remote server Keep in mind there won't be any machine level access to the server housing the sql server. Your question is bit short. If you are talking about deployment of Analysis Services project you have several ways. 1. Change your BI Dev project properties to tell it to deploy to remote machine. 2. Use Deployment utility. 3. deploy your project first to the local Analysis Server and then use Synchronization or Backup/Restore to move data and metadata to a remote server. I am sure you can be quite creative and find other ways to deploy your solution. Edward. -- This posting is provided "AS IS" with no warranties, and confers no r ...Show All

• DavideB SQL Server 2005 OLAP Cube on SQL Server 2000?

  Hello, I have designed a OLAP-Cube with the SQL Server 2005 Analysis Services. Is there a way to publish this Cube on a SQL Server 2000 with Analysis Services Or is there a way to connect the Server 2005 through the 2000 Server Thanks a lot! Are you trying to deploy as an 2000 olap cube I am trying to find out if SSIS can process a 2000 olap cube, but your request would be better if it worked. I do not know, but let me know if you find out! Dave I thought as much that is not possible. Ok, Thanks all of you for your answers. Go to the deployment tab and define the Target Server. IMRAN I do not think this is possible. ...Show All

• Roni Schuetz Service Broker and AS400 MQ Series

  Hi, Does anyone using SQL Server broker to send message to a queue outside SQL Server. I mean to non-SQL environment like AS400 MQ Series. Thanks Shafiq Is there any example code or url reference regarding building adapter service Service Broker uses proprietary wire protocol to communicate between SQL server instances. Hence it cannot directly talk to MQ Series. However, you could build an adapter service that can receive messages from a service broker queue and send them to an MQ Series queue in a distributed transaction. ...Show All

• Steve_fr88 SQLCMD error

  hi i am using the SQL Server 2005(Express Ed). I am at the client end, i mean i have installed the client tools on the workstation & server is over the network(local). when i try to execute the command at dos prompt C:\>SQLCMD it throws Missing Data Source Name Usage: SQLCMD -d dsn -u user -p password -i filename Why but if i execute the same on the server its working fine. now i wan to execute a set of sql statment from the client (at dos prompt) how can I do this if i do like this C:\>sqlcmd -d dm2006 -u sa -p sysadm -i ss.txt (that is with dsn,username,password, filename) it ok but when i use the SQL Query as C:\>sqlcmd -d dm2006 -u sa -p sysadm -q "SELECT * FROM MISC ...Show All

• Shag how do i strip the time portion from the getdate() value?

  the ssis expression language getdate() function returns the current date with the current time. i only need to get the current date, without the current time. for example: 9/1/2006 how would i construct the proper expression to return this value thanks in advance. (DT_WSTR,2)DATEPART("dd",getdate()) + "/" + (DT_WSTR,2)DATEPART("mm",getdate()) + "/" + (DT_WSTR,4)DATEPART("yyyy",getdate()) use convert(varchar(10),getdate(),101) ...Show All

• BryanCaf Current package reference.

  hi Iam developing a custom ssis source component, in that i need to get the reference of the current package where this component is added. I can get get the reference of the current package using this line of code Microsoft.SqlServer.Dts.Runtime. Application app = new Microsoft.SqlServer.Dts.Runtime. Application (); Microsoft.SqlServer.Dts.Runtime. Package pak = app.LoadPackage(@"C\DTS\Package1.dtsx" , null ); Here i need to pass the path of the package. Is there any other way to get it (without the path) Thanks Mani HI, Thank you very much for the forum. It is very helpfull to us to create new variables at runtime in UI. But we need to fill varibale details in ...Show All