Answer Questions

• Dundealing Database Constaint Violation Error in SQL for Great Plains

  Hi there. We're doing a save on a MS Great Plains with SQL Server screen and get the following error: "A save operation on table 'WS_Time_Sheet_TRX_WORK' failed because a database constraint was violated." If I hit More Info it says: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_WS10702_UPR00100'. The conflict occurred in database 'NSP', table 'U00100PR', column 'EM ...Show All

• Rozan How to skip records in script component

  In DTS activex task, you can use skipinsert to skip a row, how to do that in script component That is not entirely correct. If you change the exclusion group to something other than 0 then you can "delete" rows to a synchronous output. Call DirectRow on any row you want to keep and just don't call anything on any row you don't want to keep. This is slightly different for a script component since it does the looping for you, ...Show All

• JonHAL For each container - performance problem?

  I have a for each container configured to iterate over files in a directory (around 2600 files). The for each container contains only one data flow task. The data flow task is very simple. Only 3 steps. Read from file using flat file source (ragged right), format column values (eg. converting YYYYMMDD into yyyy/mm/dd and TRIM spaces - 13 such conversions) using derived column transform and inserting them into a table (23 columns - mostly nvarcha ...Show All

• mralbert SQL Express on LAN

  Hi All, We'd like to install SQL Express 2005 on a small network, with databases simultaneously accessed by several users over LAN via MS Access .adp front-ends. Are we likely to be affected by limitations of Express edition re: number of concurrent users What connection would you recommend: ODBC or TCP, or... Many thanks! There is no limit to the number of concurrent users in SQL Express. The only ...Show All

• Joao Rocha Cluster nodes

  Hi All, I've heard in a presentation that the number of supported nodes in a cluster on 64bit system is going to be limited to 4. Can you confirm that What about the number of instances These are the informations that I have: 25 in a cluster (a drive letter is required per cluster group) 50 in a standalone server with Enterprise Edition 16 on the other Edition Can you confirm as well Thanks for your response. Jerome ...Show All

• Robert Swirsky Getting RecordCount with TableDirect

  Hi, I would like to know if there's any method to get the total number of records in a table without using query. I have the following codes. Dim conn As SqlServerCe.SqlCeConnection Dim cmd As SqlServerCe.SqlCeCommand Dim rdr As SqlServerCe.SqlCeDataReader conn = New SqlServerCe.SqlCeConnection( "Data source=\My Documents\test.sdf" ) conn.Open() cmd = New SqlServerCe.SqlCeCommand("Staff_Table", conn) cmd.CommandType = ...Show All

• toront Should I use Notifications for this?

  I'm new to learning the notifications architecture and would like to know how heavy into learning it I should go for my project. I have a service the will allow websites to send info to a client application. The app gets downloaded by members of their service. There is the client and the website module for the client. The user can have mutliple website modules. The websites send a soap update of the info that they want to se ...Show All

• Duane Douglas Is it possible to remove fact data from a partition without doing a ProcessFull?

  Is it possible to remove fact data from a partition without doing a ProcessFull I note from T K Anand's paper that it is possible to do a ProcessUpdate on a dimension and this works for "member updates, additions, deletions." I guess I want something similar for partitions. I know that ProcessAdd won't do the job because it only removes partitions. I'm pretty sure the answer is "No" but thought I would check anyway! ...Show All

• Archan Nair ContainerStartTime & EventHandlerStartTime are the same

  Hello, In my packages, System::ContainerStartTime & System::EventHandlerStartTime always contain the same value. The value in System::EventHandlerStartTime appears to be correct, so what's going on with System::ContainerStartTime I've built a very simple package that demos this using message boxes. Save the text below to a .dtsx file and run it - you'll see what I mean. [Its very very easy to run.] N.B. I would expect ContainerStartTime to ...Show All

• tom ferguson How to view package stored in 2 instance of the same server

  Hi, I have 2 instance of SQL Server in my system. I want to view Stored Packages in both instance using SQL Server Integration Services. How to accomplish this task. Regards, Balaji Thiruvenkataraju You can edit the SSIS Service configuration file to change the locations of storage it connects with. Ensure you restart the service after making any changes. (C:\Program Files\Microsoft SQL Server\90\DTS\ ...Show All

• Hey Hey Script files failed to load error

  Hi all, I have a package with a number of script components. All are set "PreCompile=True". Within a Sequence Container I have a set of five script tasks each followed by an Execute Process Task. Each pair is linked but the five pairs are independent (hope this makes sense). The first pair executed successfully but the other four all failed with the "Script files failed to load" error. Anyone have a clue why this ...Show All

• thechristopher Display Data Source name in Report Header/Footer

  Good day, I apologize if this question has been asked before, but is there any way to display the name of the Data Source in the body of a report.  One solution to fetch the server my data is coming from is to create a new dataset with the query SELECT @@SERVERNAME as [Server Name] but it would be nice to know the Data Source being used as well.  Transparency is a big deal and this would be nic ...Show All

• Sree2000 Reporting services report render to Excel have no grouping and indentation

  Hi, When I render a report to excel format the grouping go away. Suppose I make a group of Customers of a city ( say Seattle) and display the information about them. When I render the report into excel format the grouping of customers that i made in report designer goes off. I will appreciate a solution for this problem. Thanks. ...Show All

• David Owen creating a HTTP Cube

  Hi, Please guide me in creating a HTTP cube and how to access it from OI designer. Thanks hi, sorry for not being clear. i wanted to access the Analysis Services from BusinessObjects by using the Http. Please could you guide in doing that. thanks, Here is some information on how to provide HTTP access to your Analysis Server. For AS2000 http://support.microsoft.com/default.aspx scid=kb;en-us;279 ...Show All

• Katee Conditional Data Inserting

  Hello, My project import data from a text file to a database. I'm able to import the whole file but i want to import only if data are younger than the one i have in database. How can i do  Where can i see a tutorial about it thanks a lot Do both the source rows and the database rows have a date that can be compared.  If so then you could use either a lookup or a mergejoin to get the two dates into the same data flow (by lookup o ...Show All