Answer Questions

• mitasid A Word about Meta-data, pass through columns and Derived columns

  Here's another one of my bitchfest about stuff which annoy the *** out of me in SSIS (and no such problems in DTS): Do you ever wonder how easy it was to set up text file to db transform in DTS - I had no problems at all. In SSIS - 1 spent half a day trying to figure out how to get proper column data types for text file - OF Course MS was brilliant enough to add "Suggest Types" feature to text file connection manager - BUT guess what - it sample ONLY 1000 rows - so I tried to change that number to 50000 and clicked ok - BUT ms changed it to 1000 without me noticing it - SO NO WONDER later on some of datatypes did not match. And boy what a fun it is to change the source columns after you have created a few transforms. This s**hit ...Show All

• Timo123 Change results

  I have created query As shown: SELECT distinct [Table] FROM [Database] The results i get back are A, B & C. What i am trying to do is show a result as a different word. i.e instead of displaying A is shows in drop down list as Apple, B shows Banana. etc. Can anyone help please. Thanks In that case then the answers previously given to your original post will work, however if in the short term you want to make this really simple then you could use this: SELECT 'Apple' AS [LookupValue], 'A' AS LookupCode UNION SELECT 'Banana', 'B' UNION SELECT 'Cranberry', 'C' ORDER BY 1 The LookupValue is the value that you would display in your drop-down list, the LookupCode ...Show All

• kevow Inserting data from text file to SQL ME table

  Hello, I have an application taht requires the use of a table. The device that this application works on, has a local memory that does not allow me to insert the 800,000 records that I need. Therefore I have two approaches: 1. To insert less records into my local memory database e.g 40,000 but not row by row, bulk insert is better. How do I do the bulk insert 2. This is the most prefferable way: To find a way to insert all 800,000 records into a table on the storage card which is 1GB. What do you suggest Will using threads be helpfull Any ideas I use C# from VS 2005, SQL ME, compact framework 2.0 and windows 4.2. Thanks in advance, John. SQLCE doesn't support bulk inserts. In my opinion ...Show All

• Toomas Installing SQL Server 2005 SP1 fails

  Hi, Trying to install SQL Server 2005 SP1 on a windows 2003 box and it fails for database services and reporting services patch. It installs successfully other components of the patch. Following errors are logged in the event log. 1) Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINNT\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log 2) Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user birendraa. To proceed, verify that the acc ...Show All

• SPECIALK_BC Hiding columns

  Hello! I want to hide/show my report's columns based on a multivalued parameter, but I don't want my table with a "gap" (this is what happens when I use a expression on the visibility property)! Is there anyway, any workaround I can do to achieve this Is it possible to shrink table size based on this parameter Thank you! Hello. I have a similar problem. I can hide my colums by putting the visibility for the column to "hidden". My problem is: How can I unhide the column in the preview tab What I actually want to achieve is the following: if you click on a textbox in column 1 (column 1 has product categories), colum 2 (the one that was hidden, it contains the pr ...Show All

• bmalinski Data Source View of Mining Structure cant be edited?

  Hi, all here, Thank you very much for your kind attention. I got a quite a strange problem with Mining structure for OLAP data source though. The problem is: I am not able to edit the mining structure in the mining structure editor. The whole data source view within the mining structure editor is greyed. Could please anyone here give me any advices for that Thank you very much in advance for any help for that. With best regards, Yours sincerely,   Hi, Jamie, thank you very much. Regards, You can't edit the data source view in the data mniing designer. The DM designer has a "read-only" view of the DSV. You need to switch to the DSV designer to make edits. Hi, Jamie, thank you very ...Show All

• caligula Computed columns

  Hi, Consider the following example create table sample (col1 int, col2 int , col3 AS col1 + col2) PERSISTED NOT NULL) basically col3 is a computed column. Now when ever a row in col1 or col2 is updated the computed column will reflect the new value. how does this happen in the background. does this use row level triggers or what other mechanism is used to maintain col3 - computed column I think the question is more about how you need the data. There will be a performance hit, whether you persist them, or not. The difference will be based on whether you modify data more, or read it more. If it is a frequently used column (or might be) try persisting it. If it doesn't slow you down too mu ...Show All

• sahridhayan Performance tuning issues

  I have built a solution which runs for two hours on a server with 4CPU 2GHz each and 2GB of RAM on windows 2000 server (CPU utilization almost 70% and almost out of RAM). I moved the two source databases and the solution to a new box runing 8 xeon's at 3GHz each and 16GB of RAM running widows 2003 server 32bit and it still runs for 2 hours (CPU utilization 10% and ample RAM left). I was expecting it to run much faster. So I started exploring the performance tuning features in SSIS and started tweaking the following: Control Flow: DefaultBufferMaxRows: Based on row size and buffer size, calculated the max rows. DefaultBufferSize: Set this to max 100MB DataFlow Destination: Rows Per Batch: Set this to equal to the numbe of ...Show All

• KevinBurton Last recompilation date of the procedure / view

  Hi, Kindly let me know How will we find the last recompilation date of the procedure / view in sql server. Regards, S.Balavenkatesh perhaps what you seek is in: select refdate, crdate from sysobjects or select create_date, modify_date from sys.system_objects -- 2005 Dave   ...Show All

• parlance Cannot connect using ADO with Excel Microsoft Jet Provider 4.0

  Hi: I have a vb 6 app that exports data from sql to excel. The user has the ability to select either local or server. When they select server, the connection string is modified to include the server name instead of the local msde instance to look like this: "provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase" I'm using Microsoft Jet Provider 4.0 and OpenDataSource. SELECT * INTO TempXL FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\test\xltest.xls;Extended Properties=Excel 8.0')...[Sheet1$] This code works fine when user is accessing msde on local, but when using above DSN, I receive the following message: "2147217900 - OLE ...Show All

• Jason Jaegers Connection Issue to SQL Express form VB Express

  Anyone know how to fix this error: System.Data.SqlClient.SqlException was unhandled Class=16 ErrorCode=-2146232060 LineNumber=65536 Message="Directory lookup for the file "C:\Documents and Settings\zimmerman_e\My Documents\Visual Studio 2005\Projects\MGM_REPORTS\MGM_REPORTS\ImportFile.mdf" failed with the operating system error 5(Access is denied.). Could not attach file 'C:\Documents and Settings\zimmerman_e\My Documents\Visual Studio 2005\Projects\MGM_REPORTS\MGM_REPORTS\ImportFile.mdf' as database 'dbname'." Number=5133 Procedure="" Server=".\SQLExpress" Source=".Net SqlClient Data Provider" State=1 StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlExc ...Show All

• Sergio L. VarCharMax Stored proc parameters

  I'm creating stored procedures using SMO. I create an insert procedure for a table and the procedure takes in all of the table's columns as parameters. Here is the code I use to accomplish this: foreach(Column column in dboTable.Columns) { StoredProcedureParameter param = new StoredProcedureParameter(); param.Name = DBTransforms.GetStoredProcParameterName(column.Name); proc.Parameters.Add(param); param.DataType = column.DataType; param.IsOutputParameter = column.Identity; } The problem is, once I've created the proc on the database (by calling proc.Create()), if I open the procedure the parameter declaration looks like this: @partyId [int] OUTPUT, @uniqueRef ...Show All

• bob yoplait Absolute Beginner in SQL 2005 EE, needs help.

  Hi everyone. Using C# 2005 EE with SQL 2005 EE I am really new to SQL, got qns here. Can my program with SQL database run correctly on another com using win xp home edition, with only C# 2005 EE installed Is it compulsory for every table in a database to have a primary key Can I extract a data from a specific cell in a database table(click button get data) How do I go about doing it (the simplest n straight forward method) Many Thanks in advance. Regards, dragoncells.   No and no as the answer :-) "That means Xcopy deployment is obsolete nowadays." Seems that my description was too fuzzy. It is absolutely nice that you can do Xcopy deployment. Assuming that you want to upd ...Show All

• joe25 Web service will not completely run SSIS package

  Hi, After many days of searching i have eventually been able to set up a web service to call and execute my SSIS package. The SSIS package is set up completely with windows authentication,the web service is run from an application using the same credentials with all necessary access for the SSIS package. I can run the package from the SQL management studio and it works fine, however when i attempt to run it from the web service it appears to work once round the for each loop and then fails for every other time. The error i am getting is as follows: Executing the query "Set = (select max(URC_ID) AS URC_ID FROM VIEW_A1021_URC WHERE SerialNumber = ) " failed with the following error: "Syntax err ...Show All

• CostasZ Data Flow Task - Conditions to add value for a field.

  Hi: I have a data flow task in which i have multiple OLEDB sources going to a one OLEDB destination via UNION component. I also have a derived column component sitting behind the union, because there are some columns, which exist in the destination table, but are not coming from source, but I am responsible of providing values for those fields. The question is that some of those values are conditional, for eg. Lets say we have a column called RecStatusCode in the derived column component. The value for that column depends on a condition/criteria, so I need to query a db and based on the value of another field, I set the value of the recstatus code. How do i accomplish that I am thinking expressions, but I need clear direction in steps i ...Show All