Answer Questions

• Tammy Miller Question about Redistributing SSIS

  From what I understand we won't be able to redistribute SSIS to a client machine.  If I want to add file importing cababilities to my application (ussing a SSIS package) , the client machine will have to install the SSIS dll's on their machine. I am just checking to see if my assumption is right. Any inormation is much appreciated. Shawn Absolutely. SSIS is a not a application programming technology. Best ...Show All

• Kressilac ambiguity performance problem

  The first query execution time less than 1 second But the second query takes around one minute SELECT ACC_KEY1,ACC_STATUS_LAST FROM PSSIG.CLNT_ACCOUNTS INNER JOIN PSSIG.CLNT_CUSTOMERS ON PSSIG.CLNT_ACCOUNTS.CSTMR_OID = PSSIG.CLNT_CUSTOMERS.CSTMR_OID WHERE (PSSIG.CLNT_CUSTOMERS.CSTMR_START_DT >= '1900-1-1 12:00:00') AND (PSSIG.CLNT_CUSTOMERS.CSTMR_END_DT <= '2106-12-31 12:00:00') AND (PSSIG.CLNT_ACCOUNTS. ...Show All

• akhin SSIS Problem with Excel

  We had this ActiveX Task in DTS SQL 2000 that updates an Excel File and saves it. ================================================ Function Main() Dim xlApp Dim Desc Set xlApp=CreateObject("Excel.Application") xlApp.WorkBooks.Open DTSGlobalVariables("ExistingBOM_Path").Value xlApp.ActiveWorkbook.RefreshAll xlApp.ActiveWorkBook.Close True 'xlApp.Quit True Set xlApp=Nothing Main = DTSTaskExecResult_Success End Function ======= ...Show All

• Bob Bedell Profiler ....duration

  In SQL Server 2000, "Duration" in profiler (which is in milliseconds) taken by the event; does it include time for the network transfer of the results to the client as well ; or its just the duration taken by SQL Server to complete the SQL Statement. All the measurements are serverside only, so no network time. If you want to see the network time then run the query in query analyser but before you start right click and select client s ...Show All

• Christopher DC Execution Plan Mystery

  I was hoping someone could shed some light on wierd situation i'm experiencing. I have the following query: select count(*) LeadCount from auto_leads al where received > dbo.GetDay(GetDate()) dbo.GetDay simply returns a smalldatetime value of today's date. Now I recently got thrown into a data mess and for some reason this query takes 8 seconds to run. Now the first thing I did was update the stats on the Received column of this auto ...Show All

• StephanGerhards Top 5 sales EACH month

  I have a table tblSales ( DollarAmount,DateSold, Barcode --- ) in SQL MSDE 2000. What I want is the Top 5 sales for EACH month: Month TotalSales Barcode 2006-05 Top01 Barcode01 2006-05 Top02 Barcode02 2006-05 Top03 Barcode03 2006-05 Top04 Barcode04 2006-05 Top05 Barcode05 2006-04 Top11 Barcode11 2006-04 Top12 Barcode12 2006-04 Top13 Barcode13 2006-04 Top14 Barcode14 2006-04 Top15 B ...Show All

• Dietmar Kupke Script Component - Overidable Methods/Functions.

  I am looking for a list of either generally used or a full list of overridable methods/functions for a script transformation I tried looking in the Visual Studio behind the script component but it only gives one method namely, Input0_ProcessInputRow, or if you make it asynchronous then it gives you another method CreateNewOutputRows. I am basically looking for all the available overridable methods behind a script component in various situa ...Show All

• Daniel TIZON How do i Sort the scripts in my project?

  I know this is a very stupid question, but how do i get my files sorted in a sql project in the Solution Explorer The problem is the following, i am working with a SQL Server scripts project on SQL 2005 management studio... and i have about 100 scripts in the queries folder (and going bigger) and right now is pretty hard to find a script cuz non of them were created in name order... So, how do i order by name this file scripts This is s ...Show All

• BoeroBoy Compatibility of MSDE with .NEt

  Hai frnds, Can i use MSDE for my .net applications instead of SQl server Yes. There's nothing much to say. MSDE is basically the same thing as SQL Server execept some performance limitations and missing components (no graphical interface tools, no analysis services etc). Other than that it supports exactly the same SQL syntax and data types, views, triggers et ...Show All

• Moi Tinh How to retrieve the actions using MDSCHEMA_ACTIONS?

  Hello, When I run the following code, I get an empty schema. Dim drAction As DataRow Dim dsActions As DataSet dsActions = MyConnection.GetSchemaDataSet(AdomdSchemaGuid.Actions, _ New Object () {szDatabase, Nothing , szCubeName, Nothing , Nothing , szCubeName, 1}) The result: dsActions.Tables.Count = 1 but dsActions.Tables(0).Rows.Count = 0 Even though my cube contains two actions as i ...Show All

• colinfahey Can SSIS package be run from WebService?

  Dear, Can SSIS package be run from WebService P.S. SSIS package and Webservice are located in the same computer. Thanks much! Thanks for ur help. But I find that I don't have any db_dtsoperator role in the server roles in DB and I cannot select different authentication mode once I login into Integration Services. Can you give me some ideas Thanks much! Sea ...Show All

• tweston Running Sum on DataReport

    Hye Guys,        I am a beginer programmer.. I have started 2 build a simple database application. I am now in the stage of showing the data in reports 2 print. I am suggested to use datareport available in VB. I also did my some of the report in it. It worked fine. But now I am stucked in one step..of displaying the calculateable field in the detail section.. Eg. in database: Item   & ...Show All

• Np4120 how large is 4 GB

  Hi, All. New to SQL. Just downloaded SQL server Express 2005, Web doc says its max limit is 4GB, Need to know how large a 4GB can hold. The data shall be like holding company info, say: company names, locations, line of business, phone, etc. It needs full-text search on it. Is this Express is the choice to go Really BTW 4GB is 4 gigabyte, which equal to 4 billion characters, if character set is ...Show All

• ___Apollo___ datepart

  I'm pretty new to this VB Scripting, I'm building a webpage where I'd like to be able to pick out month, day or year from a date variable, I understand this can be done by the datepart function, but it seems like I need to include a certain file or something to make it work It generates error  '800a0005' when I try to run the code as below d=datepart(mm,date) You are asking in the wrong forum!! ...Show All

• Mark Robotnik How would you archive a subset of your db if you had to?

  I have a database with 6 tables that are all joined together in one way or another. At certain points in time I want to take a subset of the records in one table(based on a criteria in that table) and 'catalog' them somehow along with the related records in the other tables. It's somewhat hard to explain. I want to preserve a point in time in the db so that at a later point in time I can reinstate the records as they were in the past. Is this ev ...Show All