SQLIS Checksum Install Problems

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - truncation error message Ok, this is starting to drive me nuts, I've been trying to get this to work for 2 days now. I have a .csv file that I'm reading and importing the data into my table. I defined Derived columns for the type and the lengths as well. I have one column that keeps kicking out this error: The column in the db has a length of 50, the column in my derived column is set to 50, now there are some strings in the colum from the csv file that contain more then 50 characters so I have this in my derived column section: to get the first 50 characters. (DT_WSTR,50)NAME [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "NAME" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. so to some it up. My field (name) in my .csv file can contain 2 to 80 characters but I only want the first 50 and if the field contains greater then 50 characters I'm getting the error above. Has anyone else run into something like this If so how did you get it working Tag: SQLIS Checksum Install Problems
  - 2
    - SQL Parameter and wildcards, how to make it work? Hello, I have what should be a very simple problem, but I cant solve it. I want to have a stored procedure return a table query (no problems here) but I also need to supply several parameters to the stored procedure (again, no problem!) Here is the problem, I need to be able to supply a wildcard into the stored procedure as an argument somehow. I can do this already, but the results are incorrect!!! It seems like when local variables are used, the wildcard argument gets ignored. for example, I have included the following example: DECLARE @Dv_id nchar ( 15 ) SET @Drv_id = '%' SELECT Diver .*, ( ROW_NUMBER () OVER ( ORDER BY Dv_id )) as RowNum FROM Diver WHERE Dv_id LIKE @Dv_id SELECT Diver .*, ( ROW_NUMBER () OVER ( ORDER BY Dv_id )) as RowNum FROM Diver WHERE Dv_id LIKE '%' OK, this is an example of my problem, the results I get from this are that the fist SELECT return 0 rows. The second SELECT returns the correct number of rows (everything in the table). Why is there a difference between: WHERE Drv_id LIKE @Drv_id and WHERE Drv_id LIKE '%' The wildcard statement '%' is supposed match everything, correct It seems like the local variable SET command syntax eats up my value of '%' and turns it into a NULL. Is there any way around this Tag: SQLIS Checksum Install Problems
  - 3
    - SSIS Logs Following the blog of jamie, I was trying to aply it to my project... but my requirments are a little different than him... http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx CommentPosted=true#commentmessage I have inside the ControlFlow several sequence containers and inside each container I have several dataflows. I want to get the time of each dataflow execution and the rows inserted in each. So I added a row count transform for each dataflow and added a global variable to save the rows count value. In each dataflow I need to initialize this global variable to 0. And my problem is that using event handlers in OnPostExecute it repeats several times for each dataflow... how can I save info only once for each dataflow using eventhandlers How can make eventhandler execute only once to save the related information for each dataflow Understood regards Code Snippet "INSERT INTO SSISLog(TaskStartTime, EventType, PackageName, TaskName, PackageDuration, ContainerDuration, InsertCount, UpdateCount, DeleteCount, Host) VALUES( '" + (DT_STR, 4, 1252) DATEPART("yyyy", @[System::EventHandlerStartTime]) + "-" +(DT_STR, 4, 1252) DATEPART("mm", @[System::EventHandlerStartTime]) + "-" +(DT_STR, 4, 1252) DATEPART("dd", @[System::EventHandlerStartTime]) + " " +(DT_STR, 4, 1252) DATEPART("hh", @[System::EventHandlerStartTime]) + ":" +(DT_STR, 4, 1252) DATEPART("mi", @[System::EventHandlerStartTime]) + ":" +(DT_STR, 4, 1252) DATEPART("ss", @[System::EventHandlerStartTime]) +"', 'OnPostExecute', '" +@[System::PackageName]+"' , '" +@[System::TaskName]+"' , "+ (DT_STR, 6, 1252)DATEDIFF( "ss", @[System::StartTime] , GETDATE() ) + ", "+ (DT_STR, 6, 1252)DATEDIFF( "ss", @[System::ContainerStartTime] , GETDATE() ) + ", " + (DT_STR, 4, 1252) @[User::SSIS_Rows] + ", 2, 3, '"+ @[System::SourceDescription] +"')" Tag: SQLIS Checksum Install Problems
  - 4
    - Received message constantly processed. Hello, when is seemd that everything works some weird behaviours comes out. I try to summarize the problem without to post the complete code. Service Broker is set to have a dialog between two databases on the same SQL Server instance. The Initiator queue has retention=on and there is an activation SP to handle errors and Target's end dialog message. The Target queue has retention=off, MAX_READER =1 and there is an activation SP to receive the message (WAIT FOR (RECEIVE (1) ...), TIMEOUT 30000 and do something with this message (sample insert into a DB). The conversation has a Timeout Dialog to end the dialog after a while. The problem that the message is constantly processed. The Process doens't stop is I end the dialof after the processing either. n.b.the Receive is within a Transation that I commit at the end. some other informations that in the meanwhile I found out : This was my complete WAIT FOR(RECEIVE : WAITFOR ( RECEIVE top(1) -- just handle one message at a time @message_type=message_type_id, --the type of message received @messagetypename=message_type_name, @message_body=message_body, -- the message contents @dialog = conversation_handle -- the identifier of the dialog this message was received on FROM [TargetQueue] ), timeout 1000; if (@@ROWCOUNT = 0) BEGIN COMMIT; BREAK; END IF I delet TIMEOUT 1000, everything works as expected ... Inside if (@@ROWCOUNT = 0)BEGIN..END I wrote also an Insert into a table to see wheter the end of the queue was reached but this insert never occurs (neither with not without timeout) I'm happy that it works what if this is the solution, it make no sense to me! Any ideas Thank you! M.B. Thank you very much M.B. Tag: SQLIS Checksum Install Problems
  - 5
    - How to Send a SQL Server notification to Messenger Hello, I'm trying to send a SQL Server notification to MSNMessenger and also to Yahoo Messenger, but I didn't find the way. If you have some information about it, please answer this question as soon as possible. Thank you so much Tag: SQLIS Checksum Install Problems
  - 6
    - Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008) OK, I have tried just about everything over the past 9 hours. I think I've read through every forum regarding anything similar to errors with SMO and TransferData(). However, I still can't fix my problem. What I'm trying to accomplish is a workaround for deploying my database application using ClickOnce. Since I can't include the database when upgrading (which would wipe out users' data), I want to have a 'Master Database' that is used as a reference to both initially create, and to selectively update, the main 'User Database'. I'm not sure if that is possible, yet...because SMO is not working for me (I'm sure there are more laborious methods to do what I want, but SMO should work...I can't help but think there is a bug). Here is my current code: Code Snippet 'Master Database Dim dbName_Master As String Dim SqlCon_Master As SqlClient.SqlConnection = New SqlClient.SqlConnection( My .Settings.LM_Master_SQLConStr) SqlCon_Master.Open() dbName_Master = SqlCon_Master.Database.ToString() Dim SC As New ServerConnection(SqlCon_Master) Dim srv As New Smo.Server(SC) 'Verify User Instance connection Console.WriteLine( "User Instance Server: " & srv.InstanceName.ToString) 'Select the Master Database as the source db Dim dbMaster As Smo.Database dbMaster = srv.Databases(dbName_Master) 'Define a Transfer object and set the required options and properties. Dim xfr As Smo.Transfer xfr = New Smo.Transfer(dbMaster) xfr.CopyAllObjects = True xfr.CopyAllUsers = True xfr.CopyData = True xfr.CreateTargetDatabase = True xfr.DropDestinationObjectsFirst = True xfr.DestinationDatabase = "TestDB" xfr.DestinationServer = srv.Name xfr.DestinationLoginSecure = True xfr.CopySchema = True xfr.Options.WithDependencies = True xfr.Options.ContinueScriptingOnError = True xfr.Options.NoIdentities = False xfr.Options.NoCollation = True xfr.Options.Indexes = True xfr.CopyAllDefaults = True xfr.Options.AllowSystemObjects = True xfr.Options.DriAll = True xfr.Options.XmlIndexes = True 'Script the transfer. Alternatively perform immediate data transfer with TransferData method. Dim StrColl As New System.Collections.Specialized.StringCollection StrColl = xfr.ScriptTransfer() For Each str As String In StrColl Console.WriteLine(str) Next xfr.TransferData() The final error is: ***** DtsRuntimeException was unhandled... Exception from HRESULT: 0xC0011008 ***** I also have not seen any examples or documentation on how to store the new database in a specific location on the hard drive, once the transfer is complete. In fact, SMO has surprisingly little documentation that I can find (which is why the code above may seem a little redundant when setting the xfr options...). I would really appreciate some help. Thank you, AL Tag: SQLIS Checksum Install Problems
  - 7
    - Report Builder Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build What are the limitations of using Report Builder with SQL Server Databases Tag: SQLIS Checksum Install Problems
  - 8
    - 64-Bit SQL Server 2005 (Enterprise), SQL Agent Notifications and Database Mail We have database mail configured on our 64-Bit SQL Server Enterprise 2005 (SP1) and are able to send test messages from the context menu that appears when selecting database mail component. However for some reason when a SQL Agent Job fails, no emails are sent to the 'operator' that has been defined for the job. I have confirmed that we have the operators correctly configured. We also have a small SQL Agent Job that just sends a test email via the sp_send_dbmail command and that works properly. However if I deliberately create a malformed parameter in the sp_send_dbmail command to 'break' it...no notification of a job failure message is sent. I have verified that the service_broker component is enabled...and the status of database mail in the MSDB database is 'started.' We have setup several other 32-bit SQL Server 2005 systems using database mail...and they all work flawlessly. After reviewing existing message posts...I am unsure if there is a problem with database mail on a 64-bit SQL Server box. Some say 'yes' other say 'no'. There are several MSDN notes about the problem...however these appeared prior to the release of SP1 of SQL Server 2005. Thank you for your assistance. ...cordell... Tag: SQLIS Checksum Install Problems
  - 9
    - importing from excel into SQL Server 2005 changing values to NULL I can't figure this one out... I have an Excel spreadsheet (Excel 2003 format) with a column of values. The column is formated to General (although I've tried it formated to text). The values are alphanumeric. However, there are a few values that are completely numeric. Example: _ITEMNUMBER_ 1-528 K214-5 184PR 45678 As can be seen, the last value is completely numeric. I am importing into a table with one column that is formated as nvarchar(50). I use dtswizard.exe and do a simple import into the table and the alphanumeric values import just fine but anytime a value is completely numeric it has a NULL value in the table instead of the value that should be there. I've tried changing the format of the column to nchar, char, etc, etc. Always comes in NULL. Any ideas Tag: SQLIS Checksum Install Problems
  - 10
    - Could not load package because of error 0xC001000A I am trying to run an SSIS Package by using DTRun.exe this way C:\Documents and Settings\Fahad>dtexec /SQL DataDownload /Conn "Data Source =TriMurti;User ID=sa;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate =False;Password=gamba" /U sa /P gamba And the outcome of the command was Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:03:52 AM Could not load package "DataDownload" because of error 0xC001000A. Description: The specified package could not be loaded from the SQL Server database. Source: Started: 9:03:52 AM Finished: 9:03:52 AM Elapsed: 0.25 seconds ----------------------------- Any help in this will sincerely be appreciated. Fahad Tag: SQLIS Checksum Install Problems
  - 11
    - Disabling extended stored procedures for security Our security team wants us to disable access to (or drop) all of the built-in extended stored procedures in MSDE 2000 as they feel it is a vulnerability. Where can I find out which extended procs are safe to disable or how we can disable them during install time Or, is the security team being too cautious and we should just tell them to leave these intact Tag: SQLIS Checksum Install Problems
  - 12
    - The SSIS package does not run using SQL Server Agent job Dear All, My SSIS package is "Extract" data from Oracle and Load into SQL Server. The SSIS package does not run when I call the SSIS package from a SQL Server Agent job step I have gone through all the steps in the doc http://support.microsoft.com/kb/918760 , but it still doesn't work. Is it because of connection to "Oracle" database and SQL Server Agent service could not recognise the Authentication information to Oracle Why I am saying this is becuase it works if I change the package to "Extract" data only from SQL Server. Anyone has experience on this problem Many Thanks in Advance John Tag: SQLIS Checksum Install Problems
  - 13
    - smalldatettime declare @ValueDate smalldatetime set @ValueDate = '21/05/2007' select @ValueDate error: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. Please note, if '05/21/2007' is used then there is no error. How is it possible to get 'dd/mm/yyyy' as above to work please Thanks Tag: SQLIS Checksum Install Problems
  - 14
    - missing borders when SSRS report is rendered in Sharepoint Hi , I am trying to host an SSRS report as a web part in Microsoft Sharepoint 2007. All the elements and data come out well except that a few borders are missing in the rendered report. What could be the possible cause and solution for this. Please suggest. Tag: SQLIS Checksum Install Problems
  - 15
    - Reporting services permission denied on microsoft access linked I have a Microsoft access 2003 database with tables linked to a number of "SharePoint lists" I do this by going to File -> Get External Data -> Link Tables. A new window pop-ups in which I select Files of Type to be Windows SharePoint Services.. Then I select the correct site.. Then select the correct Lists.. Then access correctly links the tables to the SharePoint lists. When I Open reporting services and connect to this access database. "Using the Test Connection" (Jet 4.0) its successful" When i when create a new report and select the new datasource i have just created and in reporting services I write a select all query on one of the tables in access I get this error: An Error occurred while executing query. You do not have the necessary permissions to use the ��object. Have your system administrator or the person who created this object establish the appropriate permissions for you. Catastrophic Failure. I have tried this on the super admin machine and still get the same error Any suggestions or help Tag: SQLIS Checksum Install Problems
  - 16
    - IDENTITY_INSERT Issue INSERT INTO dbo.my_table (table_key) VALUES (007) -- Msg 544, Level 16, State 1, Line 1 -- Cannot insert explicit value for identity column in table 'my_table' when IDENTITY_INSERT is set to OFF. SET IDENTITY_INSERT dbo.my_table ON INSERT INTO dbo.my_table(table_key) VALUES (007) SET IDENTITY_INSERT dbo.my_table OFF -- Msg 1088, Level 16, State 11, Line 2 -- Cannot find the object "dbo.my_table" because it does not exist or you do not have permissions. I know for certain that I have read/write permissions on this server. Is this somehow restricted to only the dba or something I appreciate all of this community's help with my basically non-stop flow of questions. You're a huge chunk of help, and it's deeply appreciated!! Jim Work Tag: SQLIS Checksum Install Problems
- Next
  - 1
    - Count 4 tables I am trying to get a count of rows in 4 tables at once. Output: Table1 Table2 Table3 Table4 12345 143 892626 28428 Or maybe even Table Count Table1 12345 Table2 143 Table3 892626 Table4 28428 Thanks, Cory Tag: SQLIS Checksum Install Problems
  - 2
    - Duplicates Hi! Grateful for some help as a newbie... I have a OLE db SQL command: SELECT DISTINCT convert (char(8),date,112) as day,...etc Resulting in error "Violation of PRIMARY KEY constraint 'PK_Dim_Date "... so Column Day in Dim_date contains duplicates. I suppose i need a delete in Lookup or how would I eliminate duplicates in Dim DELETE day from dim_date where day in(Select day from date ... Tag: SQLIS Checksum Install Problems
  - 3
    - Adding Columns and rows in pivot table to Excel 2007 Hi, I am developing Excel pivot table reports pointing to Analysis services Cube (SSAS 2005). I tried to add Columns and rows inside the pivot table but it doesnt allow me to do it. Is there a way to achieve this kind of scenario in Excel 2007 apart from converting pivot table into a normal table and manipulating it. I once read that pivot table is a single object and we cannot manipulate(i.e. add new rows and columns) inside the pivot table. Thanks Kiran Tag: SQLIS Checksum Install Problems
  - 4
    - Error: Incorrect syntax near the keyword 'DECLARE' Can someone tell me why I am getting this error: Msg 156, Level 15, State 1, Procedure fn_FunctionName, Line 11 Incorrect syntax near the keyword 'DECLARE' CREATE FUNCTION fn_FunctionName(@ElementID int) RETURNS TABLE AS RETURN --create a table (o) to hold the outcomes returned by fn_GetDescendantsByClass DECLARE @OUTCOMES TABLE (ID int, PARENT_ID int, CLASS_ID int, TITLE nvarchar(255)) INSERT @OUTCOMES SELECT * FROM fn_GetDescendantsByClass(@ElementID, 302) SELECT DISTINCT sl.JOB_ID, o.ID FROM @OUTCOMES o INNER JOIN (SELECT START_SCENE_ID, DEST_SCENE_ID AS JOB_ID FROM SCENE_LINK WHERE PROPERTY_ID IN (97, 151)) AS sl ON o.ID = sl.START_SCENE_ID GO Thanks very much Tag: SQLIS Checksum Install Problems
  - 5
    - SQL Server Reporting Services and Http Compression We have a wierd situation in our project. We have the following setup - 1. a Production web server cluster with 4 web servers 2. a Production sql reporting server that has reports called from web apps hosted on the production cluster We had an app on Production that was serving Pdf reports (not saved on the server) using he report server. Last week we setup Http Compression on the web servers. From around the same time, the Pdf reports no longer come up. Opening the report just produces a blank IE window. When I hit the same reporting server for the same report using a test web server (thus bypassing the production cluster and the Http Compression), the report comes up fine. Is the Http Compression interfering with the Pdf data served The report is called using an aspx page and .aspx files are included for compression. Appreciate all your help. Tag: SQLIS Checksum Install Problems
  - 6
    - SQL Express compatibility mode I currently use MSDE and now I need to upgrade because we moved to 2005. The problem for me is teh compatibility mode. I need to change it to 80 (2000). I also need to do it via command line because we have a base command line install for users. We use it to attach databases and view information. Is there a way to install SQL Express with a default mode of 80 (SQL 2000). THanks Tag: SQLIS Checksum Install Problems
  - 7
    - SSRS Report Parameters Hi, I have created two parameters as StartDateTime and EndtDateTime and i am displaying in the Page Header section in the Report as " Report Duration from " & Parameters!DimActivityStartDatetime.Value & " to " & Parameters!DimActivityEndDatetime.Value" It is displaying at the runtime in the report like Report Duration from [DimAct].[StartDateTime].&[2007-03-10TO7:30:00] to [DimAct].[EndDateTime].&[2007-03-10TO7:30:00]. But i need to display only the dates. is is displaying with the dimension name also. Is there any solution to solve this, can anybody help me on this Thanks Dinesh Tag: SQLIS Checksum Install Problems
  - 8
    - MSSQL2005 Analysis Service Distinct Count hi, i am currently trying to build a distinct count on my cube (mssql2005 analysis services). But after i added the discount count on the field i want to and start the processing, the following errors appear. - Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect. - Errors in the OLAP storage engine: An error occurred while processing the 'FACT VIEW STATISTIC' partition of the 'FACT VIEW STATISTIC 1' measure group for the 'Accident Statistic' cube from the OLAP_PROJECT database. the count measure works fine. will appreciate any help on this distinct count problem. thanks in advance. - HY Tag: SQLIS Checksum Install Problems
  - 9
    - Maximum Number of Processes Reached I am trying to setup transactional replication between Server A and Server B. There are 265 databases on each server. I am running SQL Server 2005 on Windows Server 2003. The problem comes in at the 201st database. The message in the SQL Server Agent Error Log is : Warning,[398] The job (WSSWPG09-EmpirePaint-WSSWPG06-104) has been queued because the maximum number of working threads (400) are already running. This job will be executed as soon as one of the working thread finishes execution. SQL Server's max worker threads is set to 0. The Distribution, LogReader and T-SQL subsystems have been increased to 200 max_worker_threads. Is there some other setting (maybe a Windows Registry setting) that can be configured to fix this Or have I just hit a physical maximum of the processor Any help is much appreciated. Tag: SQLIS Checksum Install Problems
  - 10
    - Bar Charts - possible to set max widths of columns ? Hi, Is it possible to fix the max width of the columns Sometime the report only generates 1 or 2 columns and it looks a bit odd as they're stretched to the width of the page. Also, when we have a large number of culumns, say 20 odd, the legend text get's real squashed up and un readable, are there any tips/tricks so i can have more flexibility over what's displayed thanks Steve Tag: SQLIS Checksum Install Problems
  - 11
    - Report Builder Query Hi Experts, I have a report model on top of a cube. I have a calculated metrics called Policy Count and different amounts in cube. When i try to create report in report builder with Policy count, amounts and different dimensional attributes it doesnt work. The problem is report builder allows me to select either Policy count in the report or the amount field. Have anyone faced this problem. The same report works in cube browser. Regards' Neeraj Tag: SQLIS Checksum Install Problems
  - 12
    - Trigger / Constraint / ? Hello All I am working on a calendar system where, among other things, we are track resources by event. I.e. here is a conference room and it can only be used by one event at a time. This system also is used by various departments as a calendar for their employees, i.e. sick / vacation / out of office / etc which can be used by more than one person at a time... (it was inherited) My question is if I have a table for the resources (conference room / IT Department Sick Leave / etc) and I have a table for the events (w/ FK to the resources) what will be the best way to make sure that those resources that can't have "double booking" would not allow an insert to the database (while not inhibiting those that can) SQL 2000 table: event eventid int identity pk resourceid int fk comments nvarchar 250 startdate datetime enddate datetime ... table: resource resourceid int identity pk RestrictDoubleBooking bit EmailOnNewEvent bit ... Also, what would be the best practice for emailing an admin on new event insertion for resources that have the flag set Would these best be performed in the application, or on the db side Tag: SQLIS Checksum Install Problems
  - 13
    - tsql for database , size , free space or used space in database hi, i want to know how to find out database size Tag: SQLIS Checksum Install Problems
  - 14
    - SQL DB Cleanup We have SQL SERVER 2000 Runnin on our server. We are trying to do a db cleanup, ie all tbls/views that were created earlier and are not needed any more, need to be deleted. However, is there a way, to do a cleanup in a better method, other than going thru the whole bunch of tbls/views manually,and determining which ones are needed or not and delete the ones that are not needed. Tag: SQLIS Checksum Install Problems
  - 15
    - Retriving Deleted record from database Hi friends I have a bit problem here Just I want to get back all deleted record of database How do I perform this task If It is possible then plz help me out Thanks in Advance Khan Tag: SQLIS Checksum Install Problems
  - 16
    - Date part of DateTime I'm trying this simple query in SQL Server 2005: SELECT * FROM tblRecords WHERE InputDate = '1/30/2007' I have two records which have value for InputDate as 1/30/2007 12:34:12 1/30/2007 11:23:32 But the query returns no records due to the time part of the date. How do I pick only the date part for comparison and discard the time part in the InputDate Tag: SQLIS Checksum Install Problems

zbethem

For detecting delta records, I'm a big fan of SQLIS' checksum transform. I'm having difficulty in it's install on my current machine, however. After the installation and the new transform is added to my DataFlow toolbox... I can't open the UI for the transform to define the checksum. Instead, I get the following error:

===================================

Could not load file or assembly 'Microsoft.ExceptionMessageBox, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft Visual Studio)

------------------------------
Program Location:

at Konesans.Dts.Pipeline.ChecksumTransform.ChecksumTransformUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)
at Microsoft.DataTransformationServices.Design.DtsComponentDesigner.StartComponentUI(Boolean startGenericUI)

Anyone have any suggestions Thanks in advance.

Re: SQLIS Checksum Install Problems

zbethem

In case anyone else has this problem... here's the solution.

I didn't have the file: C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.ExceptionMessageBox.dll

Grabbing from another computer and copying it to the proper location, I did the following:

gacutil.exe /i Microsoft.ExceptionMessageBox.dll
restart BIDS

No problems now.

Re: SQLIS Checksum Install Problems

DarrenSQLIS

For information, the supported install from MS is avalable http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_EMB.msi or http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/SQLServer2005_EMB_x64.msi

Is is usually installed along with the MS tools, but there must be something specific that is required duing the MS install, either way I will look into including it myself in future.