Answer Questions

• VikasGoyal Report Paramert problem

  I am trying to put a parameter on my report to select a field from my query but keep getting this error. What am I doing wrong [rsInvalidReportParameterDependency] The report parameter ‘Program’ has a DefaultValue or a ValidValue that depends on the report parameter “Program”. Forward dependencies are not valid. Build complete -- 1 errors, 0 warnings I don't understand Mahima, this is what I have done and the reason I'm getting the error mr4100. Parameters are evaluated and executed before your data is return from the dataset, so I would suggest on your parameter "default values" - do a returnset of all avaliable problems. Also, you should be able to pass this parameter value into your stored procedure ...Show All

• CS05pp2 Looking for a SQL Database Administrator with working knowledge of SQL Server 2002

  This is a permanent/full-time position based at Simi Valley, CA, 93062 Please see the enclosed job description: Primary Responsibilities Include: This position demands a Microsoft SQL Server Database Administrator in a Production DBA role with a working knowledge of Microsoft Clustering and operating systems . The candidate should be proficient in trouble shooting, performance tuning, replication and backup/recovery strategies. The individual should possess excellent communication, facilitation and negotiation skills. The individual must be comfortable adapting to a rapidly moving client focus and must be adept at multitasking. Knowledge and expertise in SQL high availability and EMC SAN environment is a ...Show All

• MisterMoon Bulk Insert error file does not exist

  Hello I am trying to bulk insert a text file into SQL 2005 table. When I execute the bulk insert I get the error "Msg 4860, Level 16, State 1, Line 1. Cannot bulk load. The file "\\ENDUSER-SQL\EnduserText\B1020063.txt" does not exist." The text file that it is saying does not exist I recently created thru my code. I can open the file but only when I rename the file will the Bulk Insert work. After creating the text file I am moving it to the server that SQL server is running on. Also if I run sp_FileExists it also says the file does not exist unless again I rename the file then this stored procedure recognizes the file. I dont' know if I have a permission issue or what is the problem. Any help would be apprei ...Show All

• Elroacho Conversation Handle processed by an activated stored procedure service can not be invoked by a CLR Service instance?

  I have a initiator and a target service broker peer. Both are controlled by a C# unit test. The initiator uses the Microsoft.Samples.SqlServer class. The target service uses stored procedure activation. Sending a message from the initiator to the target, saves the content of the message, along with its conversation handle in the target's database specific table. The unit test needs - at a later time - to instruct the target to send a message back on the same conversation handle to the initiator service. For this the C# unit test creates a Conversation off of the saved conversation handle: Service client = new Service ("cleintservicename", conn, tran); Conversation dialog = null ; dialog = new C ...Show All

• Boo79 The process could not bulk copy into table '"dbo"."MSmerge_genhistory"'.

  Hi guys I have a new one.... Still in my republisher scheme I added a trigger at the publisher server created the snapshot than reinitialized the subscription , started the merge agent and the trigger passed. But at the republisher I followed the same technic that worked previously and now it gives me those errors when I start the merge agent..... The process could not deliver the snapshot to the Subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) --------------------------------------------------------------------------------------------------------------- The process could not bulk copy into table '"dbo"."MSmerge_genhistory"'. (Source: ********\********* (Agent); Error number: 200 ...Show All

• JPedroFS Modify dataflow mapping in a script task

  HI, I have to copy tables (approx. 60) content from one database to another using SSIS. I know that I can call an execute SQL task to execute an INSERT INTO <target table> SELECT * FROM <source table>. I was wondering if I could use a single dataflow and change its source and target transform data source to do the same as above. In a script component, is it possible to load a package and modify its dataflow to simulate the INSERT INTO <target table> SELECT * FROM <source table> Thank you, Ccote Thanks Jamie, I will buy Kirk book as soon as it is available (next week as of Amazon). But I will try this piece of code ASAP. Thanks again, Ccote ...Show All

• sobo1 Error adding two OledbCommands to a package programatically

  Hi, I need to add two oledbcommand tranformations in my package. i add the commands like this: ----------------------------------------- this .OledbCommand1 = this .dataflow.ComponentMetaDataCollection.New(); this .OledbCommand1.ComponentClassID = "DTSTransform.OleDBCommand.1" ; this .OledbCommand1.Name = "ChangingColumnAttribute" ; this .OledbCommand1.Description = "ChangingColumnAttribute" ; CManagedComponentWrapper oledbinstance = this .OledbCommand1.Instantiate(); oledbinstance.ProvideComponentProperties(); ------------------------------------------------------------ this .OledbCommand2 = this .dataflow.ComponentMetaDataCollection.New(); this .OledbCommand2. ...Show All

• Zero_ Scripting the SQL db along with data

  i'm working on sql 2000. I would like to take the db script and also have the data of static tables. so that If i run the script, at once it should create my db and also fill my static tables data. plz help me.urgent. When you script a table you are basically just rebuilding the structure. You can copy the table and data with ex: use database select * into table2 from table1 This will not recreate PK or FK you could also look into a backup, or if you are moving between servers an export / import I don't know exactly what you are trying to do with this. Also maybe detach the database copy it where ever and attach it. either backup and restore, or better still detach, copy ...Show All

• nowhereman1960 storedproc return

  for some reason i keep getting a exception heres the code for the app int returnvalue = 0; DateTime dateCreated = DateTime.Now; // All users are added to Guests role upon registration. Roles.AddUserToRole(username, "Users"); String connectionString = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); SqlCommand command = null; try { conn.Open(); command = new SqlCommand("InsertMember", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@AspNetUsername", username)); command.Parameters.Add(new S ...Show All

• Jim Altrichter Virtual Cubes

  Hi, I am working on creating virtual cubes in Analysis Services 2005. I dont know where to create virtual cubes from a regular cubes. I searched the internet to know more but all they say is Analysis Manager Tree pane, right click select virtual cube. I dont understand where the Analysis Manager Tree is is in SQL Managment Studio or in MS Visual Studio I even tried in SQL Server Managment Studio 2005 by connecting to Analysis server, then selecting the cubes under databases and right clicking it. But only a REFRESH option appears. Please guide to how to create it... Thanks in Advance. Somu Hi Somu, Virtual cubes don't exist any more in AS2005 - I suspect on your internet search you f ...Show All

• mbr_rptusr Formatting dates on a chart when sourced from SSAS2k5

  I am creating a few charts in SSRS that are sourced from a cube in AS. On the x-axis is time, which is what I assume a date-like field in the cube. On the y-axis is the measure. My problem is that I cannot seem to get the dates to format on the chart - regardless of the format code I use, the dates appear in long format, like "Thursday, November 23 2006". Are the dates from SSAS just string values I feel that you may have mentioned some expression or modification done on that field.I faced this problem before where i came to know that Format expression which will be like (#000# Something...) when some operation is being performed on that date. Take out that any operation on that field and give ...Show All

• DaveM60 Using SQLExpress on a network

  Hi, I have a VS2005 application that I run with a SQL server 2003 database. In order to make the application distributable, I'm trying to get it to run with SQLExpress. I've installed SQLExpress on a spare machine and changed the connection string in my application to use SQLExpress c:\databases\mydatabase.mdf (and the database is obviously in that location!). This works fine on the spare machine. However the problem is getting the application to run on another machine but using the same database. I note that SQLExpress won't let me put the database on a networked drive. On another machine I've also installed SQLExpress, I've enabled the tcpip stuff and the browser but to be honest don't really know what I'm doing! How do ...Show All

• CodeJingle Creating a Proxy Account

  I am trying to run SSIS packages under SQL Server Agent 2005 and I keep getting a package failed error in the event viewer. I've heard that I need to set up a proxy account. I have found the following code and need a little explanation on what all the parts mean since I am very new to this: Use master CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword' Use msdb Sp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential' Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy' Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS' Let's say for the sake of argument my domain is called CompanyInc and I log into wind ...Show All

• Ben Hall &amp;#40;UK&amp;#41; choosing a collation in SQL 2005

  I have been searching for advice on the 'right' collation to choose in SQL 2005. I am US based and can assume any language required not supported by Latin1_General will be in unicode. I have SQL 2000 servers using SQL_Latin1_General_CP1_CI_AS and SQL_Latin1_General_CP850_CI_AS. The ones using CP850 will be converted to whatever collation is chosen in SQL 2005. I do not know the implications of choosing the default SQL collation as opposed to choosing Latin1_General_CI_AS. I have seen warning messages when installing analysis services if the SQL_Latin1_General_CP1_CI_AS is chosen saying that analysis services will use the colaltion Latin1_General_... . I also use non-updating subscribers in transactional replication currently in teh SQL 2 ...Show All

• dnyanesh PredictProbability with Association Rule model..

  I have run into a .. somewhat of a "duh" question. I'm running association rule to run a basket analysis, and I'm trying to get probability of each prediction. I know this is wrong, but how do I go about running PredictProbability on each ProductPurchase prediction When I run the below DMX query, I get this error message... Error (Data mining): the dot expression is not allowed in the context at line 5, column 25. Use sub-SELECT instead. Thanks in advance... -Young K SELECT t.[AgeGroupName] , t.[ChildrenStatusName] , (Predict([Basket Analysis AR].[Training Product], 3)) as [ProductPurchases] , (PredictProbability([Basket Analysis AR].[Training Product].[ProductName])) as [ProductPurchases] From [Basket Analysi ...Show All