Answer Questions

• c_shah SSIS Dataflow OLEDB Source issue with DB2 connection.

  Hi, I have problem to extract data from DB2 table using SSIS dataflow task with OLEDB source selecting the data access mode with command. Here is the scenario.(Note:If I select the data access mode as a table then it works fine.) If I use the data access mode as SQL Command then it is not working. i.e. the flow stays yellow in controlflow nothing happens in dataflow and I noticed the SQL dumper and proc completes. I couldn't find any log to verify the issue including the package execution results.Any of your thoughts will help me to resolve this issue. Thanks..Mako I have not been able to make what you are trying to do work. Any time I use even a simple query it errors our with the OLEDB data source. There are other postin ...Show All

• Emmanuel Huna Web part report explorer/viewer

  Why is it that when i install the webparts,it cannot be seen from a certain site but visible from some others I found that the one which is visible is found in the server gallery and the other which is not visible is not in the server gallery...I thought a one time installation should make all visible Regards Alu solved the problem by using globalinstall..thanks. ...Show All

• Davids Learning Encryption - importing keys

  Is it possible to load data into MSSQL 2005 that has been encrypted externally with a symmetric key algorithm, such as AES, and then import the key to SQL Server After browsing through Books Online, I don't see any way to import a symmetric key from an external file, but maybe I'm missing something. No, at this time, it is not possible to do that. You would have to decrypt the data and then encrypt it again using SQL Server's encryption functions. Thanks Laurentiu If your primary concern is protecting data in transit, you should be able to use SSL to accomplish this: http://msdn2.microsoft.com/en-us/library/ms189067.aspx Sung ...Show All

• vasudupe Skipping Rows with OPENROWSET

  I was wondering if anyone happen to know how to skip the first and last row within a fixed length file i saw the firstrow and last options but they dont seem to work. SELECT top 10 * FROM OPENROWSET ( BULK '\\servername\e$\text.txt' , FORMATFILE = '\\dbservername06\e$\test_format.fmt' )   Any Thoughts Thanks DM Hi, sorry for the late reply.. Had some fires to put out. in reply to your post. the firstrow option works well because i know that the first column ( HEADER ) will always need to be skipped , though the trailer on the other hand is unknown( meaning i don’t know what the last record position will be.) there for i cannot pass in anything for the lastrow ...Show All

• dpatfield66 ADO find method too slow, how should I do this

  I need an efficient way to get the absolute position of a record in a query matching a specific key value. The Find method is a serial search, too slow for big data sets. I am using both SQL Server Express and Jet 4 via ADO. One example of why I need this ..... I have a list control with a subset of a table (controlled by where clause in query). I want to save the current state of the list control and later restore it when the app restarts. I want to preserve and restore the current line selection in the list control. So, I save the key value for the current line, upon restart use the find method to locate the key, and set the list control current record index to the current absolute position. This is too slow for big data sets since the f ...Show All

• AndyPham Issues Filtering a chart

  I am trying to filter a series in a chart by specifying a paramter. I am showing a chart where the data returned from the SP has many employees, but I only want the employee specified in the parameter. However, when I enter the following: =Parameters!employee_id.Value into the filters tab for the employee series, the chart is blank and I know for sure that there is data for the employee I have specified in the parameter because when I remove the filter, that employee shows up in the legend along with 20 others. This should be simple and it's driving me nuts! Can someone point out what I'm doing wrong Turns out the SSRS "like" operator does not ignore spaces like SQL does.  I had spaces coming back at the end of each ...Show All

• Ephi Identifier! [problem in passing a lengthy string to an SP]

  exec sp_SearchProductAdvanced "(name LIKE '%a%' Or name LIKE '%b%' Or name LIKE '%c%' Or name LIKE '%d%' Or name LIKE '%e%' Or name LIKE '%f%')and (salesprice between 3 and 10) " ,null after executing i got this error: The identifier that starts with '(name LIKE '%a%' Or name LIKE '%b%' Or name LIKE '%c%' Or name LIKE '%d%' Or name LIKE '%e%' Or name LIKE '%f%')and (salesprice ' is too long. Maximum length is 128. how can i solve this problem. so that i can use more values . my lenght exceeds 128. is there any way to get rid of this. in my SP i have declared the parameter variable as @criteria nvarchar ( 1000 ) Just in conjunction with the above post, ...Show All

• Mark Wilkins sql 2005 dts and job

  please would you help me Nowadays we have DTS's in SQl Server 2005 Nowadays I have DTS's in sql 2005. How I can do a job of a dts that this in sql server 2005 It is necessary to install some tool to dts's do a job of this dts Please anyone of you provide some solution for this. The post is hard to understand but I will take a stab at it. If I misinterpret what you are asking, maybe it will at least make it easier for you to rephrase your question. It seems to me that you want to run some DTS packages (maybe some from SQL SERVER 2000) in SQL SERVER 2005. If that is what you are asking, it is possible to run those packages in SQL SERVER 2005 but you will have to configure SQL Server 2005 to do so. SQL SERVER 2 ...Show All

• toadspit Very confusing error about timeout and estimated-cost of query

  Hi, I created a cube from one fact table named Revenue. It's total records was about 16.8 million, consists of 12 partitions, distributed quite even (so about 1.4 million records per partition). The partition was based on month. Each partition is mapped to different file-group. The data file for each file-group was 340-360 MB (350 MB in average). The total size is about 4.2 GB. The cube involved 5 dimensional-tables. One of dimensional tables was time-dimension table. 3 out of 5 was for hierarchical region tables. The last one of dimensional tables was product- dimension table. Each of these dimensional tables are very small, less than 1 MB. The cube contains very few columns. It contains 6 columns from 3 (dimensional) region tables, 3 col ...Show All

• Sunil Virmani Access 2000 Upsizing Wizard add-in

  Hi, I want to upsize a db from Access to SQL Server. I have a version of Access 2000 that has not got the Upsizing Wizard add-in loaded, and can't find the install disc. Does anyone know if it is downloadable, and if so, from where Thanks Thanks, I finally managed to find the install disk so all is good now. I did a google search for "Access 2000 Upsizing Wizard" +download and didn't find it... Without the install disk, I'm not sure how you get it. ...Show All

• heist_rulz Fuzzy Lookup Error

  Hi I get the following error when I use Fuzzy Lookup in a Data Flow task with TransactionOption property set to “ Required ” [Fuzzy Lookup [61]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: " Cannot create new connection because in manual or distributed transaction mode .". When I Change the TransactionProperty to “ Supported” it works fine. I need the property set to Required for it does an undo in the event of a failure. Any ideas on how to get the Fuzzy Lookup to work Are you executing the package containing the ...Show All

• Glenn Haworth SQL Server 2000 Connects to Remote DB but not Local DB. Why?

  I am using MS SQL Server 2000, installed on my local machine. I use JCreator 3.50 as my development IDE for Java. I have Norton Internet Security, but it does not block port 1433, which I use for SQL Server. Windows Firewall is turned OFF. My hard drive died, and my backup died then as well (it had been fine 1 week before). I had to start from scratch. I installed Windows XP SE2, JDK version 5 (version 1.5.0_06, I had previously used 1.40) and SQL Server 2000 with SP 2 as well. When it didn't work, I uninstalled SQL Server 2000 and did a clean install of SQL Server 2000. Instead of the default instance, I gave the instance a specific name, so I would know what to put in the Java code. I can connect with a remote DB using the standard URL a ...Show All

• AnaC DB index performance

  I'm not an index expert, but I think I need help from one. I have a table with 4.9 million rows. Its PK is a composite key on 2 unique FLOAT columns. The floats are actually long ints; there are no decimals. The 2 fields are a LOW and a HIGH, and together they define a unique numeric range. Given a number input, I need to retrieve THE row where the input number falls within that row's LOW & HIGH range. Here's essentially what I'm doing: SELECT * FROM theTable WHERE @inputNumber BETWEEN RangeLow AND RangeHigh My question is on the best way to do the indexes -- right now I'm getting results, but the query takes a good 15 seconds. Isn't there a way to make such a search faster, even though there are tons of rows ...Show All

• iamdon how to create chart in the cube browser

  Hi, I have a cube and I am trying to browse the cube in the BI studio. When I slice and dice the cube the browser pane shows the data in a list format. If I want to see the data in a chart how do I do that. thanks Hi. You can find the add-in at the link below on the microsoft site. http://www.microsoft.com/downloads/details.aspx FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en PGoldy I don't know how to create a chart within the cube browser of BI studio (not sure it's possible). However, a viable alternative is using the Cube Analysis add-in in Excel to query the data and use the native charting capabilities of Excel on your query results. Hope this helps. PGoldy ...Show All

• Joshizzle Problem whit "." or "," in field MONEY

  Hi guys... UPDATE PRODUCT SET PRICE='1,11' WHERE COD='001' but, in field "PRICE" = 111,00 I don’t need "." but i need to use "," UPDATE PRODUCT SET PRICE='1.11' WHERE COD='001' Works perfectly... but all sql commands in applications use "," In Server User’s set LANGUAGE=PORTUGUESES DEFAULT LANGUAGE = PORTUGUESES Tks All If i'm correct then you are using money or decimal for price. use varchar for price and use CHAR(44) for ',' and format the string. ...Show All