Answer Questions

• Enrique0210 Data integration challenge. Will SSIS help?

  Hi, We have a requirement to do ETL on large EDI batch files into SQL Server. For this we have to map several X12 schemas - which are fairly complex - into relational schema. Right now they use Biztalk but that is not a good option for batch processing of large EDI files. Performance is really bad. Is this possible using SSIS Are there any 3rd party tools which might integrate with SSIS to make this easier or can do this as a stand-al ...Show All

• Kevin Xiao Is it possible to modify Report Builder template ?

  Hi I would like to be able to modify the basic report template offered by Report Builder , so as to be able to include custom fields that I would like to be present in every report (Company name , Logo , Date , etc) to achieve consistency in the presentation of the reports created with Report Builder In Bob's Blog he explained how to include RDL expressions in Report Builder http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx What I ...Show All

• Amenti Multilingual Support in Analysis Services

  Hi Currentely i am using analysis Services with SQL SERVER 2000 OS:- Windows 2000 Server Datasource:-Oracle We need to show the data in the cubes for multiple countries. But we are not able to show the data for diferent languges at the same time becoz in windows 2000 default language on the server can be set to only one language and the data in the cube can be shown in same language Ex Let say we wud liket see ...Show All

• Dome C. filter in table

  hi.. i'm using table to display the dataset. when i edit group at the tablerow, there's a tab for filtering. however the or/and column is disabled. is this because i'm using the evaluation version or i need to manually enable this option please help... thanks alot! hi suresh, thanks for your answer, but the and/or column is still disabled and defaulted as and when i set the 2nd filter... is it beca ...Show All

• lukha RSS feed with ISO8859 encoding

  We have an XML source that reads an RSS feed. The document uses ISO8859 encoding, which causes an error in SSIS: "System does not support ISO8859 encoding". Is there any way around this Thanks, Dirk Is there no one who can assist me with this topic Is it maybe possible to get a list of supported encodings from somewhere Best regard, Dirk You were all right. I had the code IS ...Show All

• kamila Report Textbox Properties / Formats

  Greetings - Am having problems setting a normal SSN xxx-xx-xxx format for a report textbox using the Textbox Properties / Format tab. The data is stored as text, and am using the "Format Code .... " option. When I choose "Custom" option, and attempt any formatting string containing the "-", the SSN is displayed without the "-". Nothing I have tried works. What is the correct context string for this ...Show All

• Bastari change distributor ?

  Hi There Ok i have the following setup. Server 1 - OLTP publisher Server 2 - Remote Distributor Server 3 - Warehouse subscriber Server 4 - New Server (new computer name etc, brand new). I need Server 4 to be the new remote distributor for Server 1's publication. I could disable replication and reconfigure from scratch with new server 4 as distributor. Problem OLTP tons of data , downtime required for initial snapshot to long. How can i do t ...Show All

• Bill Kinney Sql server 2000 required but only have SQL server 2005

  I have recently purchased SQL server 2005 for a new install of bespoke software - I have however just been told that it only runs on SQL server 2000 at the moment - is there a way I can install sql 2000 server from the 2005 cd any help would be greatly appreciated. thanks I bet it would work with 2005 But It should work just fine with msde. http://www.microsoft.com/downloads/details.aspx fam ...Show All

• IceX Dynamically modifying flat file connector based on variable header row

  I'm loading daily polling files from 3000 store POS systems. The data is csv with a header row containing the column names.    Unfortunately, the POS system allows the order of the columns in the polling file to be modified at the store level.  The same columns will always be there, just in a different order.  Again, the first row of each file contains the column headers, in the appropriate order. Is it possibl ...Show All

• Scott Stubbs Unable to retrieve Column information when using Ole Db Provider for sybase

  Hi All, I am in process of transfering data from Sybase to Sql Server using SSIS 2005 have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0 For Destination, I am using Sql Server 2005 database In Ole Db Source Editor , For OLe Db Connection Manager, I choose Sybase Connection For Data ...Show All

• vasu4us Replication between SQL CE 2.0 and SQL Server 2005 not working

  Hi, I've been trying to get my merge replication to work with a sql ce 2.0 on sql server 2005, but it keeps generating shapshot scripts my pocket pc can't execute. Example of my table.sch file in my snapshot folder: drop Table [dbo].[Application] go SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Application]( [AppID] [nvarchar](20) NOT NULL, [AddOnInfo] [nvarchar](50) NULL, [MaxClients] [int] NULL, ...Show All

• Roger Williamson Cannot Start SQL Server Database Services - SQL Server Express April CTP

  I am new to SQL Server.  I tried to read as much as possible in newsgroups prior to this post.  I have tried several different ways to install this without success.  The last time I attempted to install as a local service and I unchecked hide advance configuration.  I am running Windows XP SP2 with all the latest updates.  Is there a solution to install this properly   Any help would be greatly appreciated! -------- ...Show All

• norpe Getting sample databases in Management Studio

  How to get sample database AdventureWorks and AdventureWorksDW deployed in Management Studio. I selected to install sample database entire feature on my local hard drive and I can see it did installed all the .mdf,.ldf,.dim,.cube and the rest in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ How can I get the database in Management studio. I tried to use Attach db and it didn't worked, gave me following error Msg 1813, Level 16, State ...Show All

• Jim Weisz Cannot link to SQL tables using ODBC Link table in Access 2003

  When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning.  The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases(). The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source.  Observations:  This function has worked normally in the recent past and works on other compu ...Show All

• Qiao Grant Select

  I am getting a syntax error in SQL 2005 with the command "Grant Select to user". I get "Incorrect syntax near the keyword 'to'". This worked in the previous version, and according to what I can find in the documentation, it should work in this version. I hope I don't have to specify each table individually. Anybody know any more about this Why not add the user to db_datareader role ...Show All