Answer Questions

• Dimitri J. Query:Source from multiple tables to a Fact table

  Greetings, Iam new to SQLl2005. Iam using DTS to transfer data from my source to the warehouse. I have a couple of tables in my source whein I have to join these to tables fields and insert the same in teh warehouse fact table. I have used a Join query in my Oledb source component, What other component needs to be used to insert the data into the fact table. I also need to extract same data with aggregation and insert the same into an another F ...Show All

• Joy19101 Sybase OLE DB and Variables expressions

  I just tried to read data from a sybase db by using a simple "select * from " + @[User::Tablename] defined as expression in a variable, using this variable as command in a Sybase OLE DB source. EvaluateasExpression is set to true, connection usually works fine. When I try the preview now in the ole db source I receive an error from the [DataDirect ADO Sybase Provider] "Incorrect syntax near the keyword WHERE" My Vari ...Show All

• StephK Insert / Update Trigger based on a column's value

  I am new to triggers and surely could use some help. I can create a trigger to insert related records based on the main tables ID and insert that value into other related tables fine... but... How do I create a trigger that can insert a record into one table for a columns given value and then insert a record into another table for another given value For instance: New row... Table1, Column1 (PK) has a value of 101 Table1, Column2 has a value of ...Show All

• Blueshark006 How can I take this example Flat file and parse out each section to a new flat file? Each section starts with HD (header row)

  How can I take this example Flat file and parse out each section to a new flat file   Each section starts with HD (header row) http://www.webfound.net/flat_file_example.txt e.g. an example output file based on above (cutting out the first section) would be: http://www.webfound.net/flatfile_output.txt Also, I'll need to grab a certain value in each header row (certain position in the 100 byte header row) to use that as part of th ...Show All

• chechsan123 Import Wizard using a PosgreSQL Source

  I am trying to use the Import/Export Wizard to import all the tables and table data from a PostgreSQL database into dynamically created tables in my SQL 2005 database.  I have done this many times in SQL 2000 by selecting the PostgreSQL data source from the drop-down list in the wizard.  However, in SQL 2005 this data source is not available. Yes, I did make sure the driver is installed, and I even created a saved Data Sou ...Show All

• Steadyonabix [OLE DB] how can i use IRowChange::Insert() to insert data ?

  i have some objects like this:CDataSource   ds; CSession         ss; CCommand<CDynamicsAccessor> rs; and i successfully opened rs like this: ...// connect to MS-SQL Server CDBPropSet* DBPropSet = new CDBPropSet(DBPROPSET_ROWSET); DBPropSet->AddProperty(DBPROP_IRowsetUpdate, true); DBPropSet->AddProperty(DBPROP_UPDATABILITY,DBPROPVAL_UP_CHANGE|DBPROPVAL_UP_DELETE| DBPROPVAL_UP_I ...Show All

• Stuart Holdstock 2 Data Sources for 1 Dimension

  I have 2 data sources : One for my business data and one containing the state / countries tables. I want to use a foreign key between the two datasources and use these two tables in a dimension, but when deploying the project I get the error (translated from french) : Error 1 Error OLE DB : Error OLE DB or ODBC : Impossible to create Registry Entry for provider OLE DB 'SQLNCLI.1'.; 42000; Trace of error : OLE DB [Non-interface error: Provi ...Show All

• Balthasar unable to connect to SSIS using SSMS

  Hi, We are running SQL Server 2005 standard edition. I got the error when I tried to connect to SSIS from my desktop SSMS: "The RPC server is unavailable". I tried the way this URL described but got the same error. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=254204&SiteID=1 Anyone has a suggestion Thanks in advance ! ...Show All

• rbellamy Remote Connection problem on MS SQL 2000

  Hello, First, I want to say I read all threads similar this thread and I couldn't solve problem. My firewall is always off when I tried to connect remotly to SQL Server. I opened 1433 port from my router's configuration page and forwarded it to 10.0.0.4:1433. When I started SQL Server service and checking "netstat" with "-na" paramters. It shows only one row as "TCP - 0.0.0.0:1433 to 0.0.0.0:0". What "0.0.0.0" means and why foreign ad ...Show All

• Canary Error getting output.Buffer on synchronous custom transform

  I am having difficulty with a custom transform that I am developing.  Specifically, I believe that either I am missing something, or the documentation is not current.  I am writing a custom synchronous transform that looks up additional values from a web service, and inserts the additional columns into the current row. The problem that I am specifically having is that even though the samples in BOL show that there is an output.Buffer ...Show All

• GanjaDoc query distribution using service broker

  Hello , I am wokring on an application where in I am migrating the legacy application to SQL server. for this when ever I make any changes to the legacy application,I immediately move this changes to SQL, using insert/delete/update to SQL. I also want all these data on 2 to 3 other SQL servers which are on different remote machines. for this i thought of using the service broker to send the query as messages. So on the initiator(w ...Show All

• stu5601 Troubles viewing parent child hierarchies

  i was configuring one parent child hierarchy from BI Intelligence Studio but i get some visual inconsistences the hierarchy show the parent member in the child member list, How i could fix this inconsistence Regards. deniscuba. Make sure that your child attribute has 'Usage' property set to 'Key', and your parent attribute has 'Usage' set to 'Parent'. It sounds like they are reversed. ...Show All

• Shripathi Kamath High CPU utilization on Merge Replication with SQL 2005 Mobile

  I have a question for anyone who mas some tips/pointers for optimizing SQL merge replication publications.  The front end web server is running IIS 6.0 on Windows 2003 x86 Server Standard (Server A).  The back end database server is running SQL 2000 Standard on Windows 2003 x86 Standard (Server B).  The merge replication clients connect via HTTPS over the Internet from a custom C#.NET 2005 application using SQL 2005 M ...Show All

• Adam Gregrory Cant insert and delete

  Hi, Can anyone help me I am using MSDE 2000 with VS.NET. I can SELECT from the database but i cant insert and delete and update. Below are my code public static int Add( string tmpSql, string connectionString) { oleConn = new OleDbConnection(connectionString); oleConn.Open(); oleTran = oleConn.BeginTransaction(); try { oleCom = new OleDbCommand(tmpSql, oleConn); oleCom.Transaction = oleTran; int a =oleCom.ExecuteNonQu ...Show All

• srbietho SQL Server Import Copy or Query

  Hi All, I have an issues with running the above. I am trying to import tables from an Oracle Database and want to use this wizard. The problem is that when I use the wizard it is not letting me select the "Copy data from one or more tables or views" it is not selectable, it's greyd out. It will only let me select "Write a query to specify the data to transfer". Or if someone can provide me with basic a script that will ...Show All