Answer Questions

• DotNet_Student Flat File, Fixed Width import with Nulls always fails

  More SSIS woes. DTS was so much easier. I have a flat file. It's fixed-with with CRLF record delimiters (a.k.a. Ragged Right format). Some fields are null, and represented by the text NULL . I'm trying to import the file into SQL via an OLE DB connection. The target table is a SQL 2000 data table. Two of the fields in the target database are of type smallint. When I run PREVIEW on the data source (Flat File), everything looks good & correct. I added the convert columns task to convert my strings to smallint. This is where things go haywire. After linking everything up, the conversion gives me a "Cannot convert because of a possible loss of data." All of my numbers are < 50, so I know this isn't the case. Ano ...Show All

• MadamJ MDX ORDER() QUESTION

  Hello, I'm trying to re-order my time hierarchy, from ascending to descending. When I use the following order statement, the years order descending, but the months remain ascending. How can I simply reverse the default order Thanks. ( ORDER ([Period Dim].[Calendar Hier].[Calendar Month]. MEMBERS ,[Period Dim].[Calendar Hier]. CURRENTMEMBER . MEMBER_KEY , DESC ) results: Calendar Year Calendar Month 2006 "JANUARY 2006 2006 "FEBRUARY 2006 2005 "JANUARY 2005 2005 "FEBRUARY 2005 2005 "MARCH 2005 Try using MEMBER_VALUE instead of MEMBER_KEY. That seemed to work when I tried to reproduce using Adve ...Show All

• Tylerdx index question???

  I do have a dump table "table1" Table1: UniqueId varchar(4) scandate datetime courseno varchar(5). This table is not related to any other tables in the database. This is used to track the student attendance for a particular course. There can 60000 distinct uniqueid's in the table and 300 disticnt courses. I query this table most of the time on uniqueid and coursecrn combination. This table can grow up to 5 million records. can anybody tell on what fields do I have to create indexes and also of what type(clustered or non-clustered). This table doesnt have a primary key. Thanks   i just mentioned the order as an example...I will create two non-clustered indexes as you s ...Show All

• MikeRutherford Help on one colum

  Hi, I have a column in SQL that needs to be created. This column needs to start with 10 zero's. If I add a number, say 135 the column needs to read : 0000000135. Is this possible If it is how do I need to go about to do this. If I need to create a view or something like that I do not mind. I am open to all suggestions and appreciate the help. This one should remove the dot and pad the necessary 0s in front. SELECT RIGHT('0000000000' + REPLACE(CONVERT(VARCHAR(10),col1),'.', '') , 10) FROM yourTable DECLARE @AnyStringNo NVARCHAR(10) SET @AnyStringNo = '135' SELECT REPLICATE(0,10-LEN(@AnyStringNo)) + @AnyStringNo SET @AnyStringNo = '47593' SELECT REPLICATE(0,10-LEN(@AnyStringNo)) + @AnyStrin ...Show All

• Eric Robert SSIS OLE DB Source Error

  I am creating an OLE DB Data Source in an SSIS Data Flow - it is calling a SQL Server 2005 stored procedure, which accepts 3 parameters and returns a result set, but I get the following error: "There is a data source column with no name. All data source columns must have a name." I have have tested the output of this proc a million times, and every column has a name! I am also able to call a different proc in the same way, without error: EXEC pProc @DT = '20060928', @Id = 1015, @Debug = 0 Any ideas what could possibly be causing this error - assuming all of my columns DO have names Thanks : ) mary.oneill wrote: Yes, but I was trying to avoid adding mor ...Show All

• Plum117 Namespace Microsoft::AnalysisServices not recognised.

  Hi, I was trying to write a stored procedure for MSAS 2005 in C++. But when including the namespace "Microsoft::AnalysisServices", i am getting compiler errors: CubeInfo.cpp(6) : error C2039: 'AnalysisServices' : is not a member of 'Microsoft' CubeInfo.cpp(6) : error C2871: 'AnalysisServices' : a namespace with this name does not exist Also, the compiler is unable to find namespace System::Collections::Generic. Do i need to upgrade or include some other files in order to get around these errors I am currently using Microsoft Visual C++ .NET 2003 version. Any pointers on this would be highly appreciated as it is blocking my work :-( Thanks in advance, Santosh. I am not able to add even that reference ...Show All

• prrao Browsing cubes through interfaces other than the BI Studio?

  I've built a cube, deployed it and processed it. I can use the brower in the BI Studio to see the data subsets and can manipulate it. How do I get this cube to the user without having to install BI Studios on their computer Basically how do I get the cube into IIS so the user can just open a web browser and go to it Similar to how cognos does it with their cubes. Or is this not possible I see no way to view the cube unless you are using the BI Studio to open it. Am I missing something If your cube is relatively simple and your reporting requirements are elementary, Report Builder is also a good (and free!) option. Try to use RadarCube ASP.NET for MS AS . ...Show All

• Trevor2006 Permisisons need to view a DB diagram

  What are the minimum permissions needed to view a sql 2005 Database diagram While "dbo" can create a diagram others often want to see the daigrams and I don't want to make them dbo rights! TIA, barkingdog Hi Jens, Can't get this working on SQL Server 2005. I have a new user account that can view table definions and browse tables and should also be able to see the diagrams (but not modify). Based on the link, I executed: GRANT EXEC ON dbo . dt_addtosourcecontrol TO public GRANT EXEC ON dbo . dt_addtosourcecontrol_u TO public GRANT EXEC ON dbo . dt_adduserobject TO public GRANT EXEC ON dbo . dt_adduserobject_vcs TO public GRAN ...Show All

• eric shih Join problem

  Hi CREATE TABLE [dbo].[Users]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO [dbo].[Users] VALUES('Unal') INSERT INTO [dbo].[Users] VALUES('Volkan') INSERT INTO [dbo].[Users] VALUES('Duygu') INSERT INTO [dbo].[Users] VALUES('Elif') INSERT INTO [dbo].[Users] VALUES('Mehmet') INSERT INTO [dbo].[Users] VALUES('Demir') CREATE TABLE [dbo].[Agenda]( [Id] [int] IDENTITY(1,1) NOT NULL, [ActivityName] [nvarchar](50) NULL, [UserId] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO [dbo].[Agenda] VALUES('school excursion','1,3,4') INSERT INTO [dbo].[Agenda] VALUES('party','6,2,3,1') Table Name : Users Id UserName 1 Unal 2 Volkan 3 Duygu 4 ...Show All

• rajendra patel XML Task: How to pass arguments to XSLT

  In the XML Task if you set the OperationType to XSLT, how do you pass arguments to the Transform like you would in .Net by using the XsltArgumentList class Thanks. I want to keep my SecondOperandType as 'File connection' to point to a .xlst file. I want the pass the value of a variable to the XSLT so it is picked up by the <xsl:param> tag that is in the .xslt file. 1) In XMLTask UI, set SecondOperandType to "Variable" (it can be a file, or a direct input text , or a variable) 2) Let "SecondOperand" point to the variable you want to use for XSLT. (please also note, the variable itself is "expressionable"). HTH Wenyang ...Show All

• Timothy Chan Using Flat File Connection Manager Editor with delimited format

  Hello everyone: I am new with SSIS and I have a problem that I don’t know solving it. I have a simple package with a delimited flat file source which is loaded into a table in a SQL Server database. Below is the import format: - Row delimiter: carriage return and line feed {CR/LF} - Column delimiter: Comma {,} - Text qualifier: “ In the source file, the data looks like this: “string1 ”, 34, “”, , ,” string2 “text1” string2” , “ “, This package with DTS works, but now with SSIS does not, when I see the “previous rows” in the Flat File Connection Manager Editor, the last column has incorrect information and when I create a new file without spaces and without twice “” in the sa ...Show All

• kmbarz SQL Server Bug in handling of getutcdate() during DST time change?

  During this latest time change, the value of getutcdate() was offset by one hour as called from SQL Server. True UTC time should never be impacted (or changed) by any Daylight Savings Time activity. This is likely not an OS issue, since IIS logs did show the correct UTC time (unchanging) during the DST time change. Here is a record of how the time change was handled by a running SQL 2000 sp4 Server as these functions were called: getutcdate() = Oct 29 2006 5:50AM //ran at the same time as// getdate() = Oct 29 2006 1:50AM getutcdate() = Oct 29 2006 7:05AM //ran at the same time as// getdate() = Oct 29 2006 2:05AM @@Version=Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Mi ...Show All

• CyberPl Trying to connect to SharePoint database

  I am having trouble connecting to the SharePoint database on my web server. Our company intranet is accessed by http://webservername/ and the SharePoint site is accessed by http://webservername:2020/ (I wanted to put it on a different port to not interfere with our old intranet). Anyway, I need to connect to the DOCS table on the content database, but I can't seem to connect with SQL Server 2005. When I connect to webservername I see our company database but I don't see anything that has to do with our SharePoint stuff. I've tried connecting to webservername, webservername:2020 and webservername\SharePoint and webservername:2020\SharePoint with no results. If this isn't the right MSDN forum for this I apologize, but any advice would ...Show All

• AjayB SQL Server 2005 connection

  Dear All, While I am connecting to my server, Its showing error.. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider) Could anybody can help me!! The complete details as : TITLE: Connect to Server ------------------------------ Cannot connect to SMAHROOF\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this ...Show All

• Steven Rosenthal Custom Log Provider - Notification Services

  Hi... I am trying to do custom log provider that will post events to Notification Services...The idea is that if I could post the "SSIS events" to Notification Services, with a Custom Delivery Channel in NS, I would be able to do NS Subscriptions with real time monitoring of SSIS packages.. I have tried to use the sample custom log provider code in MSDN. The problem is after I added the custom log provider dll to the C:\Program Files\Microsoft SQL Server\90\DTS\LogProviders folder and install to global assembly using gacutil... The custom log provider is not showing up in the Provider Type under Configure SSIS logs... The attribute and its values are the most important settings. Can you paste what you have for th ...Show All