Answer Questions

• mt2 Checkpoint restart

  I have a package that uses checkpoint restart. It is resposible for truncatings many sets of tables and then loading them. There are several ExecuteSQL tasks to truncate the tables and several corresponding data flows to accomplish the loads. If a load fails I want the corresponding truncate task to be part of the restart otherwise duplicate data may be loaded. Normally, SSIS will start at the failed task. I read something about containers that led me to think that if I put the truncate & matching load pair in a sequence container that the container would be the restart point, but either I read it wrong or it's not working that way. Anybody know how to accomplish what I want to do Gordon, ...Show All

• Satyavani Report Viewer webpart did not work in wss 3.0

  Hi, I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts. In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed. When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again. If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine. Any ideas what could be the problem Any hints on how to investigate this is also much appreciated. Thanks, Dan Thanks Teo, I hope ...Show All

• tomdart Displaying Report in Web Application

  I am trying to develop a web application that shows several reports on the same page. I am using VS.NET 2005 for my dev environment, and am using the Report Viewer control. Because I want to display several reports on the same page at the same time, the space allocated to each report is very small. In the report I only want to display charts. The problem I'm having is the in the 200px by 200px space for the report, the quality of the chart in the report is very poor (I know 200 by 200px is not very big and OF COURSE the quality is going to be poor). I've tried readjusting the size of the report, the change, etc; but with no luck. Do any of you know a way in which to change the quality, maybe the dpi, of the image being rendered by th ...Show All

• Rocinante8 Query to another server

  Hi, I'm trying to do a query from ine server to another, something like this: " SELECT * FROM FILESERVER . SharePointConnectingDB . dbo . vDepartmentsNames" where FILESERVER is the other SQL server name, SharePointConnectingDB is the the DB in the other server, etc. as a return i get the following error (in spanish becuse the server is in spanish): in El proveedor OLE DB "SQLNCLI" para el servidor vinculado "FILESERVER" devolvio el mensaje "Especificacion de autorizacion no valida". Msg 7399, Level 16, State 1, Line 1 El proveedor OLE DB "SQLNCLI" para el servidor vinculado "FILESERVER" informo de un error. Error de autenticacion. ...Show All

• Suman Ghosh App.config?

  Hello All, I am trying to use a custom C# dll from within a script task. The C# dll relies on the Enterprise Library 2.0. Where do I put the enterprise library configuration when I am debugging a package and then when I have the package in production. I cannot find any documentation anywhere on this. Thanks for any help, Justin Hi Jamie, Thanks for the quick reply. Will that apply the config to all packages If so, is there a way to supply a config file for a specific custom dll Also, do I need to put the same config in all 3 of those files Thanks, Justin Jamie, Thanks again. You have helped immensely. I found this blog article about configu ...Show All

• Fluxtah Assembly name for SSIS built-in UITypeEditors?

  I have a custom PipelineComponent that accepts a string of SQL. I don't have a custom UI, all I need is the Advanced Editor. Currently the SQL property is just the standard line of text that can be entered on the Advanced Editor. I would like to use the popup multi-line editor that the built-in components use for editing SQL. I was hoping it was the System.ComponentModel.Design.MultilineStringEditor but that is definitely not it (and that one is insufficient for entering more than a few lines of SQL). I'm assuming it must be a UITypeEditor that was shipped as part of SQL 2005, but I haven't been able to track down the qualified assembly name for it anywhere. I tried debugging in VS to get down to a IDTSCustomProperty90 that I could look at ...Show All

• Robin E Davies Large SQL update - effect on SQL 2005 transactional replication

  I'm a newbie to Replication and recently setup the following. Publisher and Distributor on the same SQL2005 server, then I've got 7 subscribers(SQL2000 servers) and I'm using push subscriptions. I'm replicating 5 SQl tables which don't have too many changes and these are scheduled to run every 3 hours. In a few days a large one off SQL update with add an additional 10,000 rows to one of the replicated tables. I was wondering what impact this would have on the above setup i.e are there any sort of limitations here. I'm assuming not but thought I would check. I'm thinking it will just cause additional overhead on the server, but the update is being applied when no users will be using the database. Any feedback greatly appreciated. ...Show All

• Bill_W Limiting the Records in SELECT Statement

  Hi.. As everyone knows that there's a keyword in MySQL that is used to limit the records in SELECT statement as SELECT * FROM Table LIMIT 40,10 means that select from record 40 to onward 10 records. In SQL Server it is a long way with nested select ... can someone provide an alternate or we have to use the Nested SELECT Thanks Nested select (technically called a derived table) is the best way to go in SQL. Here are a few articles that cover the subject. http://www.sqlmag.com/Article/ArticleID/43922/sql_server_43922.html http://sqljunkies.com/WebLog/amachanic/archive/2004/11/03/4945.aspx http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx Yes U can specify select top n * from ta ...Show All

• adorer How to send a dynamic files attachment by send mail task?

  Hello All, Hopefully someone out there will have an idea as this is driving me nuts. I want to send a dynamic files in attachment files ny send mail task that file name has change follow datetime. I try to use the expression but I can't use it. please tell me for this problem. Any suggestions appreciated, Thanks. Hi. For example, if you want to attach files, "d:\Data_20070119.xls", use this expression in SendMail Task FileAttachMent "D: \\ " + "Data_" + REPLACE(SUBSTRING((DT_WSTR, 50) GETDATE(), 1, 10), "-","") + ".xls" you should use "\\" instead of "\".. HTH Actually I ...Show All

• Kimball partition switch and non unique index

  I have a table partitioned by month. There are no primary key. There is another table with the same structure that I use to load data for the current month. I can perform partition switch with no problem. I created non unique index on integer field in both tables. After this change partition switch does not work anymore. Here is an error that I am getting: 'ALTER TABLE SWITCH' statement failed. The table 'dbo.test' is partitioned while index 'IX_test' is not partitioned." Any help I have more questions.I use the following statement to create partion function and tables: CREATE PARTITION FUNCTION Party_PFN ( int ) AS RANGE LEFT FOR VALUE ...Show All

• Dmitry Pavlov SSIS SMTP Connection Manager

  I plan to send a email from SSIS package after performing a task. In order to do that, I need to incoporate my account Name and Password in SMTP connection Manager in order to connect to SMTP server in Yahoo. How can I do that Thanks for your information. I did not have SMTP server in my home office. If you can, please show me code sample on what you suggest me to do so I can send login and pw to SMTP server in yahoo. Your help is greatly appreciated Do a spot of Google, http://www.experts-exchange.com/Programming/Programming_Languages/C_Sharp/Q_21418431.html There is a System.Net.Mail namespace which you may also want to look at, and sure yo ...Show All

• Corinna Vinschen Performance is degraded drastically after migrating to SQL Express 2005 from MSDE 2000

  Hi, Recently we have migrated our application from MSDE 2000 to SQL Server Express 2005(SP 1). This has significantly reduced the performance of our Windows.NET application which is developed using C#. For example : While logging in to the application two databases are being attached. Time taken in MSDE: 16 secs Time taken in SQL Server Express 2005 : 58 secs Also note performance is degraded for normal screens where data is retrived from database using inline queries. Questions: 1) Is there any special(optimum) configuration(installation parameters) while installing the SQL Server Express 2005 setup 2) Is there any query optimization to be done w.r.t SQL Server ...Show All

• epsilon_ro Making managed code calls inside SQL Server in context of the client

  Dear all, I am very new to the subject of writing CLR code inside SQL Server, so I apologise if my questions seem naive. I have a requirement to populate an asp.net 2.0 GridView control with data columns, some of which are directly from a SQL Server 2005 database, but some of which are calculated by calling CLR methods passing the values from the database columns to those methods. However, the methods I need to call only make sense in the process context of the client web site which is calling the stored procedure which I want to write to return the data columns. In effect, I want to be able to make a remote procedure call from within the SQL Server CLR code to the methods available in the client process. Is this possible If ...Show All

• BAZOOKAMEGATRON How can I access dbase?

  Hi, I want to access dbase database, can anyone help I try : SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Data Source=D:\Account\;Extended Properties=DBASE III;', TRANS.DBF) and I got the following message : OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". Thanks and I really appreciate any help joe make sure you have the proper MDAC installed: http://msdn.microsoft.com/data/ref/mdac/downloads/ Hi Dman1 How ca ...Show All

• gbrot Problems Creating Report

  Hi, I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report. What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters. I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column. Can anyone offer any suggestions Dave Ok, I manag ...Show All