Answer Questions

• Rajwebdev Any clues why DTExec.exe is slower than Business Intelligence studio(SSIS Shell)?

  All, I have a simple package in SSIS that reads approx 2.5million rows from SQL2k5 source and exports it into 4 Foxpro files. The way I do it is as below 1) use and oledb source to read data from SQL2k5 2) use a conditional split component to divide the source into 4 streams ( I do a recId % 4 = 0, 1, 2, 3 to give 4 streams) 3) use an OLEDB destination to export to the 4 prexisting foxpro tables. This thing runs amazingly fast when I run(F5) it from Business Inteligence studio, but it is atleast 10 times slower when rightclick the package and execute using dtexec.exe I can't figure out why! any clues I would elimiate the 64 bit /32 bit problems because export to foxpro only works in 32 bit mode and my package has been configur ...Show All

• muthuraja Creating a dev database

  Hi, I have a test database running on the server. Now what I want to do is to create a dev db that has the exact same data model as the test one so that I can test out my application on the dev db and then migrate it to the test db. Can somebody tell me how I can achieve something like that. Thanks... Crazy: The easiest way to do this is: create a brandnew "dev" database with the name you wish to retain Make a backup of your original database Restore your original database onto the brandnew "dev" database You will have to be careful when you restore the original database onto the new database to make sure that the FILE names of the data and log files are differ ...Show All

• MaggieChan WM Shell

  hello all, how can run my application as a first application i mean before start up programs. hai, i created password protected screen application.i wnat to load my exe file first to authenticatate the mobile device. sudarsan. hai, i created password protected exe file using vc++.NET.i want to run this exe file first to authenticate the device. with regards, sudarsan. hi Could you please be more specific in your request ...Show All

• missbluebar Creating Report on Local XML File

  Hey All,   I am attempting to create a report on SQL Reporting Services that uses a local XML file as its datasource.  Although i did not find a way to directly do this, I found an MSDN article that walks a person through on how to use a report parameter to paste in your XML data from the page.  When I set up the report in this way, I get an "Invalid URI" error when I go to the preview tab. http://msdn2.microsoft.com/en-us/library/aa964129.aspx What would be the best way for me to use an XML file as a datasource using reporting services   Is there a way that I can use a local file and use a parameter to point at that file     Any info, links, tuts, etc. would help.  Thanks! ...Show All

• PiGuy Rowediting does not work?

  Hi there, I am not sure if I am right within this forum but it's worth a try: I try to build a GridView and receive the data from SQL Server 2005 - if I implement the source within the .aspx-file it works fine to make the rows able to be edited ( < asp : SqlDataSource ID ="SqlDataSource1" runat ="server" ConnectionString =" <%$ ConnectionStrings:ACUConnectionString %> " SelectCommand ="SELECT * FROM [Access_level]"> </ asp : SqlDataSource > But if I try to implement the datasource within the pageload nothing happens on a edit-click. Therefore I implemented an event onRowEditing but now I do not know how I make the fields editable Hopefully you know a solutio ...Show All

• arch_angel81 Cube not showing up in Metadata Browser

  I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios: Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube. Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down. Proclarity ...Show All

• TaylorClark Data Viewer does not show any data

  Hi all, I have a recurrent problem with Data Viewers, it happens quite often that the Data Viewer does not shows any data altought I can see that some rows have passed through as there is a "XX Rows" on the data path where the Data Viewer has been added. Sometimes it shows up sometimes not, I can't figure out why. Any idea I think I've seen this happen when the metadata of the data-path to which the viewer is attached changes. Could that be the reason -Jamie Well, apparently not, I've just been executing the same package without any change on the data flow and what shows up is that when I have more than one Data Viewer, the first one shows the data but not the second one ...Show All

• mr_superlove Connecting to Oracle on 64-bit (x64) machine

  Hi, Has anyone received the following error when trying to create a connection to an Oracle database using SSIS installed on a 64-bit (x64) machine "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open" The reason this is funny to me is because I have the same Oracle/SSIS setup on a 32-bit (x86) machine and I can connect successfully. On both machines I have SSIS RTM, Oracle 9.2 and using the Microsoft Ole Db Provider for Oracle. Thanks, - Joel I experieced the same issues and this is how i solved it. (Without patches) On Windows 2003 x64 with, SSIS(x64) Install a x64 version of the oracle client. Copy C:\Program Files (x86)\Microsoft SQL Se ...Show All

• Daigu Cannot Set Connection String For Bulk Insert Source Connection

  I came across something strange today. I was wondering I was doing something wrong. I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection,  Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert . Did you come across this or am I doing something wrong - Expressions     ConnectionString  @[User::FileName] Did anyone come across this before Thanks Sutha   See this link for a Dec 27 Blog. http://denster.spaces.live.com/ ...Show All

• ajain Why the Results of Cluster Alogotytm are coming in the following way

   Hi I have data in the following format Custid Age Product 101    25     ProdA 101    25     ProdB 102   25      ProdA 103   50      ProdC 104   55      ProdA 105   50      ProdC when I am using Clustering algorithm with 2 clusters and trying to perdict the product column the results are coming as below Custid Age Product  PerdictProd 101    25     ProdA    ProdA 101    25     ProdB  &nbs ...Show All

• Will Merydith Programmatically creating reports in VB.NET

  Hi! I am trying to write a script in VB.NET that will run a report that already exists in the system and export the results to my local machine.  We are using MS Reporting Services to manage and manipulate the reports.  So here's my question: Is it possible to programmatically create a report in VB.NET based on an existing report   I noticed that crystal reports has a nice export method, but I have not been able to find anything similar for my situation.  Basically I believe I would need some sort of reporting services object in .NET that would allow me to run the report and export the results.  Does anyone know of such a structure, or if this is even possible   Thanks!! Best regards, Jos ...Show All

• kymaita SQLEXPRESS Merge pull subscription

  Hi all I have a question, I am trying to enable a replication process between a SQL 2005 server and sqlexpress instances and i run into the following problem. On the publisher a subscription (sp_addmergesubscription) is added for each 'machine' that participates in the replication. Is there a way to get around this Because when we distribute the installation we dont know all the machine names. I have made the publication accesible for anynymous access. But when the replication script is installed on the client ,the Error message that the subscription does not exists appears. The only difference between the instal script for the client is that we do not add a sp_addmergesubscription on the server. Is it possible to let SQL serve ...Show All

• BBesser Use Aggregate or lookup?

  Hi All, I want to check if a row already exists for a column value. A flat file source will provide a single column-single row that contains a string value. What I want to do is perform this aggregate query: SELECT Count(*) As MyOutputcolumn WHERE MyDatabaseColumn = MyInputColumn It seems like either the Aggregate or Lookup Transformations should do this, but I've not figured out how. All help will be appreciated. Roger Hi Again, How would I reference an input column in a query TIA, Roger Not exactly sure what you mean but perhaps this will help: http://www.sqlis.com/default.aspx 311 -Jamie Lookup will do it. The rows th ...Show All

• markovuksanovic SharePoint Add In Install Problem

  I upgraded my SQL Server Enterprise 2005 instance to SP2 CTP. I also have sharepoint server 2007 b2tr running on same machine. The portal is running fine off port 80, and Reporting Services is running fine off poer 8080. I configured reporting services with in Sharepoint Integrated mode, using the report services config utility. I downloaded sql server 2005 reporting services addin for sharepoint (SharepPointRS.msi dated 11/9/2007). When I try to install the add in I get the following error: "You must first install Sharepoint Server before installing SQL Server 2005 Reporting Services Add In for Sharepoint Technologies" I'm running SQL Server Enterprise 2005 x64 and Share Point Server 2007 B2TR x64. Any thou ...Show All

• Adriaan W Using SQL2000,upgrade OS from W2K to W2K3

  Hello, We're planning to upgrade our OS from Windows2000Svr to Windows2003,my question is,will there be problem on my SQL2000 installed is there patch needed for the SQL2000 to run in Windows2003 environment thanks&regards, jerico No, not one that I know of. never tried an inplance update od 2k to 2k3 (don’t know if you will do this). But the preferable method for me was to backup the databases on the old system, then for schizophrenic reasons :-) made a clone image of the old server, Update / reinstall the new one to Win2k3 and restored the data’bases on the "new" server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All