Answer Questions

• consultutah Problems migrating DTS package

  Hi I have run the migration wizard. This is the error I am getting: TITLE: DTS Migration Wizard Error ------------------------------ The destination server must be an instance of SQL Server 2005. ------------------------------ BUTTONS: OK ------------------------------ I have selected (local) as my destination server, it is the same as source. The version is 8.0.194   Any idea I believe that you have answered yo ...Show All

• Rodi Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

  Hi I am trying to display  Microsoft Reporting Service Reports from windows application. I have application window with Report viewer control. I have  assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports Error is " "The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed w ...Show All

• neuber this should be easy but it's not.

  I have written 2 custom connection mgr’s. One connects the data from an oracle source One connects so I can put the data on a sql server. These both work well and it makes it a lot easier across development, test, production. But now I would like a good way to do this I have 10 tables to copy from oracle. The only difference is just the name of the table. static string [] g_tables = { &qu ...Show All

• Arnar Vilhjalmsson ODBC From Access to SQL Connection Wizard will not come up.

  When I choose ODBC from the link tables wizard it just disapears. No error message at all just poof. Any one have any ideas Thanks Thanks all, Turning off the office plugin did it. go to proformance then to spyware then to configure then to misc and uncheck the box. Preston http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=161918&SiteID=1 This guy s ...Show All

• Akash Maheshwari MSFT How many DBs can you have

  Excuse the newbie question. I know that SQLE has a limit of 4g on the size of a DB. Can you have multiple DBs We currently support our small customers on JET. They have large projects with seismic data. It can add up to bigger than 4G quickly if you are talking multiple projects. Can we support them with SQLExpress and each project can live in it's own DB Our bigger customers have SQL or Oracle servers. We are moving away from JET. ...Show All

• Bitnius DMX Tutorials for AdventureWorks

  Can anybody help me find a comprehensive tutorial on DMX executed against the AdventureWorks database on Analysis Services on SQL Server 2005   We don't have a dedicated DMX tutorial available currently but the DMX reference in Books Online as well as the Tips & Tricks  section at www.sqlserverdatamining.com would be good resources to start with. ...Show All

• Edwin Colon Report model

  Hi, In my database I have a table with user rights. For example: User 1 may see region 1 User 2 may see region 2 and 3 Is it possible to use this in my report model. When user 1 makes a report with the report builder he must not be able to see region 2 and 3. thanks in advance You can use the SecurityFilters property on the corresponding model entity to grant permission to specif ...Show All

• AsifLogs Audit task

  Hi, I have to compare the values of two fields which are in different tables and then generate a audit report. How to view the audit report . How to compare values Hi Jamie, I have a master database. Based on certain criteria's I will be creating one new database. Once I have finished the creation, I have to check the value of a particular column in both database tables. This is actuall ...Show All

• JDL440 Foreach Loop Container in SSIS

  Could someone send me any links or information on how to loop through an ADO.NET dataset in SSIS I need step by step information please. Thank you, Shiva Jamie, Using ADO enumerator to loop through an ADO.NET dataset seems stupid. Also, I have 200+ columns in my row and to keep mapping variables for each column seems insane!! Sebastien Nunes wrote: ...Show All

• Christian Damborg 64bit Server 32bit Client

  I installed SQL 2005 on a 64bit server. Can I still use enterprise studio on a 32bit client machine The install CD's are 64bit and when I try to find the enterprise studio to install on my 32bit machine i get an error. Is there a place to download the 32bit enterprise studio What are my options here Thanks in advance. Mike 32 bit tools can happily talk to a 64 bit server. ...Show All

• Mr.ink Can SQL Server 2000/2005 Co-Exist On One Server?

  Can I install SQL Server 2000 and SQL Server 2005 on the same physical server and be able to access them independently through their respective tools (E/M, Q/A, SSMS) and through ADO, OLEDB We have an upgrade issue that involves some parallel testing without buying a new server. Hey, i just work here right Yes this works just fine ...Show All

• Ethan Hunt Must I have a wildcard MIME type in order to see images?

  Is there a way to display images rendered by Reporting Services without applying MS KB 326965 on IIS 6   The workaround calls for setup of ".* - application/octet-stream" MIME type in IIS. Any direction is welcomed. Regards, Patrick hi  the report manager was not working when i give in the browser http://<servername>/reports it saying the error       The re ...Show All

• Bhavin111 Reporting Services 2005 Report Builder

  Does anyone know if RS 2005 report builder will work on databases other than SQL Server 2005 In other words, say I have SQL Server 2005 running Reporting Service 2005 and want to allow the end users to build their own ad-hoc reports against a SQL Server 2000 application database...  would this be possible Thanks, -Kirk So does it mean Report Builder will be supporting other databases such as Oracle or OLE DB datasources   What ...Show All

• New to VB how to do it without using cursor?

  Hi, I need to insert several rows into two tables like: table product and table productDetail. The product table has an identity column and the productDetail table has an id column references to the identity column. So when one row is inserted into the product table, the corresponding productDetail row should be populated. If there is only one row to insert, it won't be a problem. How can I insert several rows I know I can use cursor ...Show All

• drofdarb More installation issues.

  Hey everyone, I just downloaded the express edition and tried to install it. I passed all the sys reqs and it seemed to be going well, but it said that "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'." The full installation log is below. Microsoft SQL Server 2005 9.00.1399.06 ========================= ...Show All