Answer Questions

• Missis Crystal SP2 Slows Down Time Intelligence

  Can somebody else verify that performance decreases in SP2 where time intelligence is concerned. Below is my simple repro on AdventureWorks. I already have an open question in a prior thread to ask why [Year to Date] is so much slower than [Current Date] where fiscal semester [2004][1] is concerned. [Current Date] runs in 2 seconds after clearing the cube cache. My question for this thread is why did my [Year to Date] query go from 1 minute in SP1 to 2 minutes in SP2 Does anyone know how to get the 2 second execution that I would expect from a [Year to Date] query Step 3 below runs in 1 or 2 minutes depending on if you have SP1 or SP2 Step 4 runs in 2 seconds 1. Create Time Intelligence Select Ti ...Show All

• JohnnyX147 Still Getting computername\Guest error

  Thanks for the responses but I'm still getting this error. computername\Guest. Simple Filesharing is OFF on the xp server maching. My lap, where I wrote the app i'm using that connects to the server works OK..I connect after intering the computername\sqlexpress, dbname, username and password. But on another laptop I'm still getting error that shows computername\Guest. I can't figure it out. the only difference I see in the user accounts on both laptops is that under "manage network password" mine show only one entry "passport.net" where the other laptop(where I'm having trouble connecting) show two entries 1.email account and 2 passprot.net. I'm using sqlserver and windows authentication. ...Show All

• pessi Transfering a file from a FTP server to a SQL Server Table

  Hi I currently trying to construct a package where a file is picked up from a FTP site and then is inserted into a SQL table. I have created the FTP Connection Manager and I have linked the FTPTask object to this connection. Where does one go from here. Thanks Stephen use the SSIS data-flow to insert the contents of the file into SQL Server. A good way to build this for beginners is to use the Import wizard within SSMS. That will build you the basic data-flows inside a package which you can then modify accordingly. -Jamie ...Show All

• JamesPang question on using xp_cmdshell

  I am trying to run an exe file like: EXEC master.dbo.xp_cmdshell '\\Share\sharepoint\folder1\folder2\test.exe "input parameter"' And executing the above with the input should give me an output.But the input parameter is not recognised. Any help. Thanks The test.exe is a tool to extract output when an input is given. EXEC master.dbo.xp_cmdshell '\\Share\sharepoint\folder1\folder2\test.exe input' if i do like above i should be able to get the output. Thanks Not recognized by whom The test.exe command What do you mean by input parameter. Can you post an actual example so we can try it you may want to note that XPs are to no longer e ...Show All

• efriese SSIS Data Flow task fails to load all text from flat file

  Hi Guys, I have a flat file which is loaded into the database on a daily basis. The file contains rows of strings which I load into a table, specifically to a column of length 8000. The string has a length of 690, but the format is like 'xxxxxx xx xx..' and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle. Previously I used SQL 2000 DTS to load the files in, and it was just a Column Transformation with the Col001 from the text file loading straight to my table column. After the load, if I select len(col) it gives me 750 for all rows. Once I started to migrate this to SSIS, I allocated the Control Flow Task and specified the flat file source and the oledb destination, and gave the output column ...Show All

• Rothariger Hidden Columns Problem in Excel

  Hi there, Been so annoyed to get rid of all the hidden columns after exporting my report to Excel which when I merge and centre then unhide, shows blank columns. The hidden column could appear in the middle of report or at the end of each report. Known from somewhere that this might cause by the below mentioned facts and i've got some of the solutions with me but may i know is there a guideline to follow when designing a report for Excel and meanwhile get rid of hidden column's problem i. The width of each and every tables are not aligned when there are more than 2 tables presented in a page vertically (each one on top of another) and therefore, gotta m ake sure the location from the left (start location) for all tables ...Show All

• GMan5309 DataSet Question (Should be easy :)

  This should be simple. If I have a DataSet... lets call it ImageDataSet in a report and it is a collection of ImageObjects that have two properties, lets say Photo and Caption. So if i were writing in c# to access the second image in the collection, I would say something like ImageObjectsCollection[1].Photo to access the second photo in the collection. My question is how can I do that within the reportviewer. Just access a specific image. Everything I have read only shows =Fields!Photo.Value in which it would get all of them or =First(Fields!Photos.Value) which would get the first in the collection and =Last(Fields!Photos.Value) which would access the last one in the collection. So I ask how could I specificaly access an im ...Show All

• akin_l How to check whether SSIS is installed

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)         Messages         * Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - inSsrc_txt" (1).          (SQL Server Import and Export Wizard)      ...Show All

• Darren1 capture delta

  how can I capture delta in SQL Server 2005 to refresh base tables in a data warehouse Ideally you will write your extract query to only return changed rows. This depends on having some date for similar indicator columns in the source that would indicate if a row has changed, and therefore should be included in the query result. If this is not possible, then you need to extract all data and compare for any changes. The SCD Transform (Wizard) can help you build a package that does this. What is "delta" Changes Is this a SQL Server question or an SSIS question well we are infact replicating that table. Does transactional replication mean that you can capture/replicate only the DML(insert,update,delete) ...Show All

• nate-d-o-double-g ldf file lost

  somehow i lost my ldf file and now my sqlexpress is not working. I have the mdf file though. Is there a way to restore my database using mdf file Please help. When I use sp_attach_single_file_db, it gives me this error "The log file cannot be rebuilt because the database was not cleanly shut down"    Any ideas. thank you for your answers. Can you tell me how can I use sp_attach_single_file_db Thank you If you don’t make it through the GUI, try the sp_attach_single_file_db. This will allow you to attach a single database file and will create (if possible a new log file) HTH, Jens ...Show All

• Biju S Melayil any other plugin algorithm developed??

  hi, as we know we get clustering algorithm with managed plugin algorithm API does anyone have developed any other plugin algorithm as i want to check what are the things that needs to be modified. i am not data mining algorithm developer but i just want to check where we have to make changes. i would be better if i get source code for algorithm other than clustering ANOTHER PLUGIN ALGORITHM REQURIED thanks in advanced We haven't made any other samples available as of yet. Angoss and KXEN, among others, both have implemented plug-in algorthms that they sell commercially. I don't know of any parties that have made source code available for their plug-ins - maybe someone will start is it possible to get deta ...Show All

• Kevster454 Generate SQL for a table

  Hi I have two questions i) is there any SP which will generates SQL Script for a table including all constarint(PK,FK), index etc. and the table data in the format of "INSERT INTO" . if NO, how can i create to do so, or any other SP which will help me( may be third party one) ii) Where had "Scptxfr.exe" gone in SQL Server 2005 Regards, Thanks. Gurpreet S. Gill I know about scptxfr.exe, I want only one table Script(not all), with Data too. joey I dont want to create it by .NET code infact only by using the some SP, or inside SSMS only. I read the artical but i dont find any thing about where is the SCPTXFR.EXE had gone, only one line say, "this is missing", ...Show All

• ahmedWebDev works fine in designer but when i load the report it doesn't work

  works fine in designer but when i load the report services I get the following error anybody know what to do there is one subreport with this report maybe the passing value but what could be wrong Item has already been added. Key in dictionary: '9' Key being added: '9' It hapened to me, exactly the same. For what I know it can be a problem with the default values of the Report Parameters... they should not be originated by a query. I had this problem and puting this as static or calculated values solved the issue... Not the best way as by default the user's are not getting the data shown, but that's a solution. Hope Microsoft solves the issue.. as this is a serious bug. Regards, Jose ...Show All

• Mike Howes Copy Database Wizard Problem

  I am trying to copy a database from SQL server 2000 to SQL server 2005. In using the Copy Database Wizard I am getting an error. I have selected the SQL Management Object method as the transfer method. The error is occurring on the create package step when running. The error code is: "While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Client unable to establish connection)." The destination server must be running SQL Server 2005 Service Pack 2 or a later version. The computer on which the Copy Database Wizard runs may be the source or destination server, or a separate computer. This computer must also be running SQL Server 2005 Service Pack 2 or a la ...Show All

• Tony Maynard-Smith failed to load sqlcu.dll

  On installing SQL Express, getting the error: failed to load sqlcu.dll how to proceed thank you. ...Show All