Answer Questions

• exceldude2001 dts2000 migration, activex script and odbc connections help needed

  Apologies if this has been covered before or if i am in the wrong place. I am migrating some DTS2000 packages to SSIS via the migration wizard. However there is an activex script in each DTS package that connects to an AS400 to retrieve teh record count of a table for integrity checking. Under SQL server 2000 this worked fine but in SSIS it errors with "The OLE DB provider "MSADSQL" has not been registered" how do i get th ...Show All

• Kryor How to 'group by' properly?

  Hi, I'm working on a report where a customerid is passed from the application. The result are data for that specific customer. The result is something like this: Customer: <name customer> Number of hours: <hours:minutes> Average time to deliver: <days> This works perfectly. But now I have also make it possible to pass value 0 as customerid , which means all customers has to in that report. The problem now is that th ...Show All

• ANW Insert Script from one table to another

  I have a table in the SQL Server 2005 database that I want to copy 5 columns from one table into another table. I wanted to create a script to do this operation so I can use this on another database that would have different values for these columns. If I were to use something like this: DECLARE @pdtno smallint , @publyear smallint , @issord int , @pdtrnno smallint , @layout varchar ( 60 ) --- code to select the v ...Show All

• KristinBarker Save Report .rdl including Data

  Where is the option in SSRS 2005 to save a report .rdl with data so I can send it to others for troubleshooting I have a problem with his technique. I have several datasets in my report and so when I go through his steps, my datasets are still trying to reference stored procs and my preview errors out. What do I do in this situation ok, so then you're saying that cache file can be used somehow or is the cach lost after preview The ...Show All

• mvang Link Report Problems

  I have established a set of base reports which are then linked to a variety of department specific folders. Moreover, many of the reports have the capability to "Drill Through". The problem occurs when clicking on a Drill Through field in one of the department specfic folder -- it directs the drill through to a report in the Base folder instead of the department specific folder. Pleaseeeeee help! The ...Show All

• starkweatherr VS Express free for good and other fun stuff

  A whole bunch of exciting new stuff announced around the Visual Studio Express Editions today. VS Express is now free for good, not just 1 year (just like SQL Server!). Also lots of great new content and fun projects to do. See Dan Fernandez's blog posting at http://blogs.msdn.com/danielfe/archive/2006/04/19/579109.aspx for lots of details. Best, MJ can i used it for network applications/solutions ...Show All

• KathTam_MS sQL server 2005 beta 2 installation

  Hi, I am trying to install sqlserver 2005 beta version but the installation failed due to the following error. Could someone let me know how to get rid of the error. TITLE: Microsoft SQL Server 2005 CTP Setup ----------------------------------------   SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection ...Show All

• bdub042 SQLExpress Problems

  I just installed Visual Studio 2005 Professional a couple a weeks ago, I have been playing around with the Personal Web Site Starter Kit it has to learn how the .NET interacts with the SQL Server. Everything was working fine even was able post the site on the WEB and have my friend and I log in and use it. My Issue is I messed up the SQLExpress , I am about at the point I want to completely start from the beginning and re-install the OS but I ne ...Show All

• Andy_Paul FoxPro Image to SQL Char

  I currently am trying to synchronize a remote FoxPro database with a local SQL Server 2000 database. I am running across a memo (binary) data type in the FoxPro database. Up until today I have been using the SQL command "Convert(varchar(8000),CONVERT(varbinary(8000),frm_data))" and this is fine if the memo field isn't longer than 8000 characters. Well, today I ran across one that was 2,000 characters. My little work around so far has b ...Show All

• mkpark Calling external webservice using certificate

  I'm trying to call an external webservice which use https and certificate. I load certificate into MSIE and then made *.cer file. The problem is that if I compile simple console program which use this certificate - than all is OK. But when I compile simple rutine for SQL server and trying to run it - an exception is issued after this line: service.ClientCertificates.Add(X509Certificate.CreateFromCertFile(certFile)); Exception is: Request for the ...Show All

• Hadi Rezaee SQL DB Connection or Query Problem?

  The best way to state my question/problem is to describe the sequence of events that I am seeing. Here goes: 1. I have a SQL Server 2000 database hosted on a remote server. 2. My web server is also hosted remotely and has a connection to the sQL database. 3. I go to my website (like any other user) and view an ASP page with a recordset. The page returns fine for 8 to 10 requests and then errors and returns a timeout. 4. I call my h ...Show All

• liu1323 Controls missing in toolbox

  All in sudden all the Controls (Table, Crosstab, textbox...) disappeared from my Toolbox. I clicked View -> Toolbox and still it is empty. Anyone has any idea what is going on.. Thanks. Got it. I reset and got all back. thanks. ...Show All

• Brandt-Lassen How to Pass parameters in SSIS dataflow

  I am using a parameterized select query as displayed below to fetch values from source. SELECT A.Account_GUID, M.Merchant_GUID, H.Household_GUID, B.BankAU_GUID, SR.SalesRep_GUID, E.Entitlement_GUID, I.Income_GUID, Exp.Expense_GUID, SP.Sales_Product_GUID, P.Product_cd, SUM(S.Sales) AS Monthly_gross_MC_VI_amt, SUM(S.Sales) - SUM(S.[Returns]) AS Monthly_net_MC_VI_amt, SUM(S.SaleTxns) AS Monthly_gross_MC_VI_tran_cnt, ...Show All

• Lei Jiang does the XML Task update XML files?

  I'm using package configurations to store my server/database name in an XML File.  I need to be able to dynamically change the database at runtime when I execute the package.  Can I use the XML Task in another package to make a change to that xml file   I'm not familiar at all with XML, so I don't really know the syntax for XPath or XSLT or anything.  Basically I'm just looking for an example of how to this with XML, but I ha ...Show All

• ivernot Sql Reporting Services

  This is my problem. I am doing a inner join on 2 tables, order header and order detail. When I look at query, the order amount I am including from the order header table gets put into every record, the way I think it should work. My problem is want to only add it once to subtotals. ex (order number) (item seq) (item amt) (ord amt) (ord tax) (ord ship) Subtotal: tot ord ord amt ord tax ord ship division total t ...Show All