Answer Questions

• flash.tato Adding Row Numbers to Flat File Source

  Hi, I was wondering if it was possible to add an identity column to a flat file data source as it is being processed in a data flow. I need to know the record number of each row in the file. Can this be done with the derived column task or is it possible to return the value of row count on each row of the data Any help on this is greatly recieved. Cheers, Grant Rafael, Jamie, Thanks for both your posts on this matter. I'm looking into Rafael's suggestion at present and see that the only way to access variables in the data flow section is within the PostExecute phase. That problem with this is that it doesn't seem to update the variable as i move through the rows in the dataflow. Is this because of how S ...Show All

• Kyndig Error "Msg 6522, Level 16, State 1" receives when call the assembly from Store Procedure to create a Text file and to Write text

  Hi, I want to create a text file and write to text it by calling its assembly from Stored Procedure. Full Detail is given below I write a code in class to create a text file and write text in it. 1) I creat a class in Visual Basic.Net 2005, whose code is given below: Imports System Imports System.IO Imports Microsoft.VisualBasic Imports System.Diagnostics Public Class WLog Public Shared Sub LogToTextFile( ByVal LogName As String , ByVal newMessage As String ) Dim w As StreamWriter = File.AppendText(LogName) LogIt(newMessage, w) w.Close() End Sub Public Shared Sub LogIt( ByVal logMessage As String , ByVal wr As StreamWriter) wr.Write(ControlChars.CrLf & "Log Entry:" ) wr.WriteLin ...Show All

• Horst Klein Sql 2005 DB Mail Setup Issues

  Hi, I'm trying to setup Database Mail on a production box running SP1. I've followed the directions listed in 2005 BOL for guidance during the setup process. I've configured Database Mail and attempt to send a Test Message. The message gets queued, the databaseMail Process gets started, but during the actual send process I get the following exception information : Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine I've done all the preliminary checks to verify that SMTP is set up p ...Show All

• J.Wadsack Email with attachments.

  I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out. Each time the subscription runs I am getting this error below: Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information. Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information. When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments Please let me know. Thanks ...Show All

• kata. How to compare table from SQLSERVER 2005 with oracle

  Hi, i am trying to compare the table which is existing in SQL server2005 with the same in oracle 10g. is there any short cut procedure for it.. Sreenivas What do you want to compare the schema of the data HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Jen, Could u mail me the script for SQL server comparison..i dont have any script for oracle ... I am trying to reach you at your mail id. but surprisely it bounce back to me.. i want to compare the table structure including the datatypes of some xxx table in sql server with oracle table which is having the same name and structure..these two are located in different databases and different locations with differe ...Show All

• Vista2007new Publishing OLAP based Pivotables from Excel

  Hi I want to publish an OLAP based pivottables from Excel to a HTML file using Office web componets. I have a server with SQL Analysis Services 2005 cubes and I can browse the cube from my desktop in Excel 2003 Pivottables. When I publish the Pivottable with Pivottable interactivity I get an error in the browser: The query could not be processed - An error was encountered in the transport layer - The peer prematurely closed the connection In the Pivottable I have set 'Save password' in properties. Any suggestions Thomas Black I'm having the same error msg and problem to access SSAS 2005 cube over http at client ...Show All

• Eddy-kun Numeric attribute keys

  Does it make sense to favor numeric columns for the attribute keys (e.g. 1,2,3, etc. for the month attribute) as opposed to names (e.g. January, February). I've noticed that the sample AdventureWorks UDM uses both approaches so I am not sure which one is best from a performance standpoint. In AdventureWorks, numeric columns are typically used for snowflake dimensions while name columns are used in star schemas (except Date dimension which uses numeric columns). Thank you, Edward. Is there any recommended member count threshold, above which integer keys should be considered Obviously, having a separate integer key column for each attribute hierarchy could be counterproductive. The best is to use numeric keys for your dime ...Show All

• Sree Prakash SQL backup (bak) fragmentation

  We backup a lot of SQL databases. The db admin uses SQL to dump the databases to a *.bak file on a network share, then we pick them up to tape. The problem is that for some reason, the backup files are MASSIVELY fragmented, which kills our backup speed to tape (via Netbackup Enterprise). If I defragment the drive (via the built-in tool on Win2K3 or PerfectDisk 8) our speed to tape more than doubles (can go from 16MB/sec to 36MB/sec). However, after the next SQL backup, the drive is completley fragmented once again (around 70%). Is there any way to improve how these files are written to disk (to keep them relatively in one piece) For some reason it appears this is a bigger issue with the SQL backup files than any other file type. Than ...Show All

• mrmrjr Linked server from SQL 2005 64-bit to SQL 7

  I've experienced the problem with creating a linked server from SQL 2005 64-bit to SQL 2000. "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.". I have resolved this by upgrading the system stored procs on the 2000 machine by running instcat.sql, documented in http://support.microsoft.com/default.aspx/kb/906954/en-us . Works great. However, I'm now experiencing the same error when linking from SQL 2005 64-bit to SQL 7. I'm concerned about applying 2000 code onto a SQL 7 machine. Any ideas on how to handle this case Thanks Paul Hi Paul, You can gohead and apply the 2000 code instcat.sql in SQL server 7.0, Upg ...Show All

• Jonathan Allen Different Data Types in Data Source View

  I have 2 views in my data warehouse where the dimension table primary_key has a data type of tinyint and the fact table foreign_key has a data type of tinyint. When I bring these into SSAS 2005 data source view, the data types change. The dimension key is now a system.int32 and the fact key is now a system.byte. I can no longer relate these two tables together because I get an error of "different data types". Has anyone encountered this yet Thanks, Brian Brian, There is a section on this issue in the "Project REAL: Analysis Services Technical Drilldown" whitepaper by Dave Wickert. You can find the paper at the following URL: http://www.microsoft.com/technet/prodtechnol/ ...Show All

• Yasir Imran Jump to Report Without Parameters

  Hi, Is there any way in Rs2000 "Jump to Report" Action, to pass only some off the target report parameters, and when the report opens fill the rest from the target report parameter area I can make this work in VS2003 but not in Report Manager. In Report Manager when you click the link it just clear the screen and stays like that. Thank you for your help Rgranada i do have a crude way of doing it and i still looking out for the best way to do it. for example, lets take @Empno is the parameter and u want to make it optional so declare another variable like @ES when u r passing employee number , then pass @ES = 'S' ( means selected) when u do not want to use @EmpNO , then pass @ES = 'A' (me ...Show All

• sennekeennes adding dbo to db_owner

  Im duplicating a database by running the script below. This works fine. My only problem is that the dbo user does not by default have any role memberships in the new database hence no access. I have tried using sp_addrolemember but dbo is not a valid user for this procedure. Adding dbo to the db_owner role through the sql2005 MS works fine, but I would very much like to script this. Any suggestions --copy database use master; alter database polaris_regular set single_user with rollback immediate; DROP DATABASE polaris_regular; backup database polaris to disk = 'c:\tmp\polarisbak.bak' with INIT,format; restore filelistonly from disk = 'c:\tmp\polarisbak.bak'; restore database polaris_regular from disk = 'c:\tmp\polarisbak.bak' with ...Show All

• mri WHAT NEXT AFTER INSTALLING SQL SERVER EXPRESS?

  I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases. However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed. Could I have downloaded the wrong package And the last tip.... by default through t ...Show All

• Kennon2005 how can i create view within declare ?

  dear all how can i create view within declare if i had one script contains declare if it is possible to combine both table with union declare @a varchar(20) select @a = ptraceno from phonelevel where(ptraceno = '0913787170' or otherno = '0913787170') select * from phonelevel where ptraceno = @a declare @b varchar(20) select @b = ptraceno from phonelevel where(ptraceno = '0913011676' or otherno = '0913011676') select * from phonelevel where ptraceno = @b I don't know what you mean by "create view within declare," but the two result sets here can be expressed as one this way: select * from phonelevel where ptraceno in ( select ptraceno from phonelevel where ptraceno in ('0913787170','0913787170') or ...Show All

• Jehan Badshah Encryption and bulk insert

  Hello, I need to build a table with encrypted data with the source data coming from a .csv. The account number from the .csv will need to be encrypted in the final table and I will also need to have a hashed or MAC index on the account number. I'm guessing that I can do this with a stored procedure using a temp table to load the unedited data and then load the actual table from there. The table will be built from a download every evening. The key and certificate for the encryption are already set. I have been able to load data directly to the table providing values. But, I have been struggling getting a bulk insert to work. I'd appreciate any ideas or examples. Thanks! Thanks for your quick ...Show All