Answer Questions

• denis123 Loading multiple files

  I have a security system that creates log files in a dbf format. I need to report from a weekly collection for files. I am trying to do this through Integration Services 2005. My hope is to use the for each loop.   My problem is the only way I know how to get the data out of the dbf file is to use a .Net ODBC provider connection. In this connection I use a select statement to pull the data from the dbf file and then an OLE DB connecti ...Show All

• computer_guy cannot install samples

  hi to all, i just installed sql server 2005 express edition.  I also downloaded and run the "Northwind and pubs Sample Databases" and i have problem installing them In the line of the guide that i have to run sqlcmd -s .\SQLExpress -i instnwnd.sql i get the following error: HResult 0x2, Level 16, State 1 Named Pipes provider: could not open a connection to Sql Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occured wh ...Show All

• j_o_h_n Foreach Loop Enumerator Question

  Any help appreciated here... I'm inserting a CSV file into my SQL Server 2005 Sept CTP which has approx 1700 rows.  It contains Companies and Contacts which I split in a data flow and determine if with Fuzzy Lookups whether dupes exist and perform either insert or update (That works great).  Here is my issue: The database does not use Sequence for the Pkeys and to make matters worse they are prefixed with letters.  I have to gene ...Show All

• Praveenkmenon SSIS CAL licensing

  Hello, How does licensing of SSIS work on a CAL basis As far as I'm concerned there are no users of it per se cos its a back-end process. Therefore, do you only need one CAL Thanks Jamie   That's a good point about installing it separately from you main DB.  Your understanding about server licenses is correct.  In the instance that you have SSIS on one box and SQL DB on another, you will need two distinct ser ...Show All

• Hawkmoth How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order

  How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order without using stored procedure Ex: Table: netComputers(3 rows) Column Name: ipAddress (string data type) ipAddress 0.0.18.1 0.1.1.2 0.0.0.1 Sql query : if I use the query Select ipAddress from netComputers order by cast( replace(ipaddress,'.','') as ...Show All

• Greg P How can I script object data in SMO?

  Hi could somebody give a suggestion or post some example on how I can script table Data Suppose I have a Customer Table I need to produce something like : INSERT INTO [dbo].[Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES('ALFKI', 'Alfreds Futterkiste', 'Maria Anders', 'Sales Representative', 'Obere Str. 57', 'Berlin', null, '12209', ...Show All

• Mickey J. Malone ReportServer activation logs

  I am supporting a web based application that utilizes Reporting Services to generate downloadable reports. We occasionally get the dreaded "Internal Error" when generating reports. While researching, I noticed in the event logs server activation logs: "The reportserver service has been activated". Is it normal for the server to reactivate frequently Yesterday, it reactivated 18 times. Would this only be associated with ...Show All

• june .net StoredProc

  Hi, I'm trying to use a LDAP request to simply fill a table.  I want to use the database agent to schedule the insert every night. So I was trying to make a storedproc to do it, but I can't make a import of "System.DirectoryServices".  Many references types look to be unavailable.  How could I do it Some ideas Regards Jacques System.DirectoryServices is not in the SQL Server's support ...Show All

• wireaudio IF calculated member

  I have a discrete Measure, where 0 = ValueA and ValueB = 'greater than 0'. The cube is aggregating the Measure but since it is discrete it has lost it's anlaytical value. I would like to create a calculated member in the cube that adds 1 to the count if the value is greater than 0. Something like... Iif([discreteMeasure]>0, Add 1 to calculated member count, Add 0 to count) Any ideas how I can do this Thanks ...Show All

• Ping06 OK button not working...

  I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK. I have installed the app, SP2, and a hotfix that is on the website. Help.... I only have the D:\In ...Show All

• SaliDM setting variable value

  hi ! I am trying to set the variables value through Execute SQL task and create directory through the FileSystemTask by setting the user variable as source. The User variable has the Directory path to create the directory, but when i set the source as the user variable it complains that its value is empty. Execute SQL TAsk happens to work correctly when i check the watch window the user variable is set correctly . but value is not setting ...Show All

• chamsoft Rendering reports on PDA, mobile devices

  Hi, I am using URL access method to render the reports in a browser. But the same URL does not work with PDA devices. Report is not displayed on the PDA device. Any idea how to render a report on PDA device using the URL access. Thanks. Kavita You could try to add the following device info to your existing URL (pointing to http://servername/reportserver/ ... to render to HTML 3.2 format: ... &am ...Show All

• KristianJ how to add report "Templates" to list during wizard?

  Hi, I'd like to customize the new report wizard to save me time in building reports. I know that with most of VS there are files I can copy and edit to do that for new projects, forms, classes etc... where are they for new reports   Jordi Rambla wrote: Hi, Well, it actually depends on what you are naming "templates" in the Wizard. 1- If you are referring to the Styles you see at the very end of the w ...Show All

• Nagendra Kumar Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.

  I'm getting the following error on two of my SQL Servers - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. The only solution that I have seen is the same solution that Microsoft has published in the following article - KB303287 [http://support.microsoft.com/ scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f303287%2fen-us%2f] The solution is to unflag the use of NT Fibers.  However, ou ...Show All

• Pyramid installing sql

  i have a problem installing sql server 2005 CTP editon,iam using  visual express beta 2 editions of  vb and vc# 2005 what is the compaitable sql version i can use with them hii thanks for ur reply where can i find the download of sql server express edition as i cudnt find it i think its download is removed ,sql server ctp edition did not work with express editions   ...Show All