Answer Questions

• TigerPhoenix Views Very Slow!

  Hello, From what I have read from various sources, views as an Oledb Source component source are very slow. In practice I have experienced this as well - they are painfully slow. One of the most recent books out on SSIS documents this fact and says to use an ad hoc query instead. I'm curious if someone from Microsoft could expxlain why this is in more detail. I have clients ask this question, and would like to know for my own purposes as well. Further it would be nice to know if this is expected to change in v.next. Thanks much There is nothing specific about views that makes them slow. The benefits of encapsulating logic in a view should not be dismissed. This is not really a SSIS issue, consid ...Show All

• LutherW Mirroring problem between pcs in different location (Witness Issue)

  I am facing this problem here. Well , I did setup mirroring in LAN successfully (using certificates). Then I try to implement the same method for WAN. Here's the info : Principal : location A (111.222.333.444,1234:5022) Mirror : location B (444.555.666.777:5022) Witness : location A (111.222.333.444,5678:5022) For the mirror side, I didn't put any firewall settings at all; and both principal n witness , i did open the specific port for mirroring endpoint n sql. However, when I start mirroring , it shows 'The server network address "TCP://444.555.666:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Se ...Show All

• rajesh_batchu sqlev maintenance utility

  Hi We are devloping a database management utility for MSDE,sql server enterprise and sql EV There are system queries available for performing index rebuild and setting minimum and max memory on msde and sql server by using the following statements below "DBCC DBREINDEXALL(S)" "SP_configure 'min server memory',1024 Reconfigure" "SP_configure 'max server memory',6144 Reconfigure" But is there a way I can perform the same on SQL Ev. I tried using the above statements, but it doesn't work out, can anyone help me with statements specific to SQL Mobile or Ev. Thanks Mani But can pls let me know if I can set that (max db size and buffer pool size) programatically , say for exampl ...Show All

• Chirag Patel insert only time in sql server database

  hi, i want to insert only time in my sql server database.but when m try to insert time in database it takes time+default date. i want to eliminate this default date. plz any one know this then tell me. Regards, shruti. And I want a pony.  Looks like neither of us will get what we want today, so we both have to work within the bounds of reality.  Reality is, there is no way to do what you want.  But work with the tools you have, and you can achieve the same end result.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < shruti.makwana@discussions.microsoft.com > ...Show All

• Joao Pinto Data Transfer from SQL200o to SQL2005

  I need to transfer data from SQL Server 2000 to SQL Server 2005 nightly. Replication DB1.T1 table in SQL 2000 to DB2.T1 table (the same table structure) in SQL 2005. What are my options I need to extract a daily data and do this daily. Some example would be greatly appreciated. Thanks, create a simple SSIS and schedule it as per ur timings...u'll just need to moniter the logs to confirm the success of task.... How can I create link server in SQL2005 to SQL2000 SSIS is probably new for me, is there any instruction/example that show how I can do this u can use the import-export wizard to create one...then save it and schedule it....as ur requirement is minimal (only data transfer and no transformation), ...Show All

• Karl Kelly PDF Rendering bug

  We are trying to publish a group of financial reports using SQL Server Reporting Services. We have hit a snag when we try to render the reports in PDF format. The leading spaces of each line are stripped in the output file. For example: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Becomes: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Does anyone know a solution for this problem By the way, we did upgrade to SP2. That did not correct the problem. This blog entry (actually the comments for the entry) discusses same. Long story short, the PDF extension strip ...Show All

• GCB Problem on this forum - "deleted post"

  Hello all, I just got the bellow error twice: "The post you requested cannot be found or no longer exists. The administrator or moderator may have deleted the post." Am I the only one that see this or is it a know problem. Is there a forum moderator that can check this out (I didn't saw any contect options on this page). Thanks. Now that I replayed to you its look like every thing is ok... strange... If you were the creator of the post you always get an information about the cause of the deletion of that post. Make also sure that your email client uses the correct link to open the post, otherwise there could be the chace that you opened a link which is not c ...Show All

• shunt date parameter issue

  hi all We are a multi site / multi language company so do not want to hardcode the date format - these reports will be on intranet Using MS Sql - Reporting Services 2005 Using no formatting on fields = yyyy-mm-dd - is how it is displayed. I added a @startdate and an @enddate parameter I read up and saw this information: Report properties set 'Language' setting to '=User!Language' to detect user culture automatically My regional settings are set to English (New Zealand) but whatever I do I receive no data - (data is definately there eg when run without parameters) so it is obviously the dates incorrect. Can someone give me some advice on what else to check. hi there this i ...Show All

• dayjur Microsoft VBScript runtime error

  Hello, I am currently getting the following error: Microsoft VBScript runtime error '800a000d' Type mismatch: 'QueryString' /admin/equipment/addequipment.asp, line 128 This is when i try to submit a new database item in Dreamweaver. The DB I am using is SQL Server 2005. My code is as follows: Dim equipspec__urlid equipspec__urlid = "1" If (QueryString("ID") <> "") Then equipspec__urlid = QueryString("ID") End If %> <% Dim equipspec Dim equipspec_numRows Set equipspec = Server.CreateObject("ADODB.Recordset") equipspec.ActiveConnection = MM_intranet_STRING equipspec.Source = "SELECT * FROM EquipSpec WHERE " + Replace(equipspec__urlid, "'", "''") + ...Show All

• Aaron Silverwatch Loop throught columns of an Excel file using dtsx package!

  Hello, I'd need an help because I'm stucked!! I have to import an Excel file into my DB. The Excel file is made by 2 worksheets but I need only one and inside this worksheet I have to loop through the columns and for each column I define a Data Flow that trasform the data as necessary and then insert into the table. I started with a "Foreach ADO.NET Schema Rowset Enumerator" with connection=excel file and the schema was set to "Columns" but the loop go also through the worksheet that I don't need.. after 4 hours of tries I'm lost... Someone could give me an advice ThankX Marina B. I'm stucked on the Foreach loop because I'm not able to find the right enumerator ... For me it mak ...Show All

• deen T-SQL Reporting

  is there anyway to run complex reports using T-SQL including variables and cursors and such Amythyst wrote: Why don't you just put it in a stored procedure, schedule it, dump it to a table, then use reporting services to just select * from the table and display it tabular so they can then export it to excel or something from the web thanks for your help guys, this is how i ended up doing it. Why don't you just put it in a stored procedure, schedule it, dump it to a table, then use reporting services to just select * from the table and display it tabular so they can then export it to excel or something from the web If you jus ...Show All

• Javahar Deployment of analysis services on windows 2003(Very urgent Please)

  I have window 2000 as my development machine. I am using visual studio 2003 and sql server 2000. I was able to develop a web application which uses the pivot table componant. Every thing was working fine with out any problem. I deployed my Project to windows 2003. I am able to see the pivot table control. I am not able to get any data into my pivot table. I am not sure what is going wrong. Is there anything I need to take care in windows 2003 specifically. I don't have microsoft office on windows 2003. Does it make a difference Please help!!! Anil If you are using MSOWC for your pivot table component and if yout new server do not have riyhrt MSOWC installled or Office instaled,then you will not be abl ...Show All

• Sergey D export to excel - formatting number output

  Hi all, Once again, SSIS is giving me a 'F.U.N.' time (ask for definition of the F.U.N. acronym another time ). I have a relatively simple task - create an excel spreadsheet with 3 columns of data - Id, Description and Sales. ID and Description are text, sales is int. So my SP aggregates and creates my resultset in my OLE DB Source in the Data Flow. It proceeds to the Excel destination, and that all seems fine. My issue is that the data is being written as text. Looking at the excel destination in Advanced editor: the Excel Destination Input, Input columns are formatted as I expected: DT_WSTR 8 for the ID, DT_WSTR 100 for the Description and DT_I4 for the Sales. Excel Destination Input, External columns refuse to fall in line, tho ...Show All

• AShukri DataFlow Task & Filters

  Hi, I am getting data from an external source. External data has a column called "Type". I have a variable in my package which contains the list of types as shown below: Filtered_type_List = 2,4,8,10,11 If this variable(Filtered_type_List) is blank, then I need all the data from the external source and if it is not blank then I only need the records matching to his list. How can I implement this in DataFlow Task Thanks Hi Jamie, Where should I put this "Select" statement, 1.  Source using SQL Command as variable using OLE DB Source or 2.  Lookup transformation Thanks You could do this in an expression. Something like: "SELECT * FROM MyTable " + (LEN(MySSISVariable ...Show All

• sitha Add/Remove DataViewers makes VS to crash

  Hi all, I'm sick of VS crashing when I add/remove DataViewers any idea why this could happen Sebastien. No idea why, but I get it quite a bit also. BobP In my case it happens when a dataviewer is assiocated with a deleted item. When you delete an control flow item on the control flow the dataviewers are not deleted. When you try to delete one VS will crash Workaround: Create a new control flow item with the same name as is used for the dataviewer. Delete the dataviewers in the breakpoint window Delete the control flow item. At least it did the trick for me (after a few dozens of crashes before I discovered this workaround) Sander Created ...Show All