Answer Questions

• Shyamal Patel RUN SQL 2005 SSIS Package on SQL 2000 BOXES?

  I have a package designed and working correctly for months now. My challenge now is to run this package on a box that does not have SQL 2005 SSIS install. It has SQL 2000 installed. My question is - Can I compile the SSIS into EXE or any other kind of DTS package to run on a none-SQL 2005 box Thanks! --Jon You don't need ANY version of SQL Server (i.e. the database engine) installed in order to run a SSIS package. You just need SSIS installed. And no, its not possible to run it without having SSIS installed. That's what you pay the money for. -Jamie ...Show All

• Bill Martin Parameters ignored, Render report from VB .Net application

  I seem to be unable to pass parameters from a VB .Net application to Reporting Services. Before I added the parameters to the query, I got all the rows back. So I know the application is basically working. Now that I have added the parameters, I get nothing. I thought the SetExecutionParameters function would help, but my syntax is wrong and it fails. I would appreciate any hint as to what step I am missing. Report setup: Parameters Name Value @Report =Parameters!Report.Value @Corp =Parameters!Corp.Value @Dept =Parameters!Dept.Value Query conditions WHERE Report = 'BudgetVarianceSummary' AND PeriodEnd = CONVERT(DateTime,CONVERT(char,GETDATE()- DATEPART(day,GETDATE()),112)) AND Report = @Report AND Corp = ...Show All

• dreameR.78 SSIS Performance Issue

  Hello, I have been running massive ssis packages and testing the performance. This is my execution design: I have a main package that gets a list of packages to execute from a table. Then using a foreach loop in send the package to execute ( somewhere in the middle i delete the corresponding old log file for that package ), each of the packages configures themselves from the parent package variables. What i have been analysing tells me that for example a package runs in 2 minutes and then the time wasted from the end of the package to the start of the other task is in average 3 to 6 minutes... thats alot... since i run about 20x12 packages witch gives me of wasted time about 20 hours. My question is... what can be causing ...Show All

• Jademobile Dynamic table name in destination

  How to create a new table dynamically in OLE DB destination. This is what i am doing I am reading multiple flat files in loop and saving file name to a variable. Then i have a source script component which read and transforms data .Now how can I push the data to SQL table. I want to create a new table with name saved in a variable. I tried using OLE DB destination and assigning table name from variable. Does'nt work. Thanks in advance for any insight on how to make this work. -Amar And this next comment is important, so I'm going to make it its own post: The metadata (number of columns, data types, etc...) must be the same across all of your tables that you are dynamically feeding into th ...Show All

• Deco Syntax issues with UPDATE in SQL2005 Table-valued functions

  I am trying to make a simple mod to a table based on a select and keep getting a syntax error - problem is I can;t see it!! I think I may be going Mad...........Code is: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo] . [fncunprinted] ( @Start datetime ) RETURNS TABLE AS return SELECT dbo . frclients . [Name] , dbo . frclients . Title , dbo . frclients . Inits , dbo . frclients . Addr1 , dbo . frclients . County , dbo . frclients . Pcode , dbo . orders . Printed , dbo . orders . Orddate FROM dbo . frclients INNER JOIN dbo . orders ON dbo . frclients . Account = dbo . orders . Account UPDATE dbo . orders SET printed = 'Y' WHERE ( dbo . ord ...Show All

• gg1 Is this possible without using cursors?

  Hi! I have 2 tables: Person and Address Person (   PersonID int PK ) Adress (   AddresID int PK,   PersonID int FK,   Default  -- 1 if address is default for person ) so when I join those table it yelds (for example): p1  a1  1 p1  a2  0 p1  a3  0 p2  a4  1 p3  a5  0 p3  a6  0 Person may: - have one default addres and some non-default; - haven't default address; - have only default adres So proper result is: p1  a1          p1  a1 p2  a4    OR    p2  a4 p3  a5          p3  a6 I ...Show All

• windflower How to enforce SQL Server 2005 to use Worktable?

  I have a problem in SQL Server 2005. In some cases SQL Server produces an execution plan of complex query (8 joins of views, some of views contains couple of joins) which does not contain a woktable creation in tempdb. As a result time of query execution increasion for about 5 seconds to about 4 minutes. All necessary indexes are created. It sims all data located in cache. Is there any way to enforce SQL Server to create worktable Query SELECT [a0].[id],[a0].[Priority],[a0].[Heading],[a0].[DocumentDate],[a0].[LastName],[a0].[FirstName],[a2].[Name],[a1].[Position],[a4].[ContactTime],[a4].[Subject],[a0].[WorkPhone],[a0].[MobilePhone],[a0].[FaxNumber],[a0].[PrimaryEmail],[a5].[ContactTime],[a6].[Value],[a7].[id],[a7].[id_class],[a8].[id ...Show All

• Ala Kushlaf running stored proc with parameter

  hi, im getting an error when i run the stored proc with a string parameter in execute sql task object. this is the only code i have: exec sp_udt_keymaint 'table1' I also set the 'Isstoredprocedure' in the properties as 'True' though, when you edit the execute sql task object, i can see that this parameter is disabled. How do i do this right cherrie Cherrie, Not sure I am understanding the details of your problem (may be if you post the error you are geeting...); but here is my shot: Assuming the parameter inside of your procedure is table1; then the SQLStatement of the SQL task should be something like: EXEC sp_udt_keymaint @table1= The in the parameter mapping page ...Show All

• CaveDrake The media set has 2 media families but only 1 are provided. All members must be provided.

  I tried to restore database using following sql command RESTORE Database RALMYT FROM DISK = 'G:\RALMYT\RALMYT_20060523_3.3.0.0.42_stripped.BAK' but i got this error Msg 3132, Level 16, State 1, Line 1 The media set has 2 media families but only 1 are provided. All members must be provided. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. when i run the RESTORE FILELISTONLY FROM DISK = 'G:\RALMYT\RALMYT_20060523_3.3.0.0.42_stripped.BAK' command i can see these data and log files RALMYT_Data RALMYT_Data_02 RALMYT_Data_03 RALMYT_Data_04 RALMYT_Log RALMYT_Log_1 what would be the error please help me Thanks Something is realy wrong. ...Show All

• yjm Dependant assemblies in CLR

  This is related to one of my previous posts. I am running a CLR stored proc that goes to an EDS (Novell) server with LDAP and returns records into a SQL table. I am using the Novell ldap library. I want to do this with SSL so my code referneces the Mono security library as well. However when I make the call to the stored proc to run in SSL, I get an object not found error. I do not think that the the Novell assembly can "find" the Mono assembly. Two points: 1/ I can do the SSL if I run it as an asp.net page (so I know the SSL works) 2/ The proc runs and pulls all the records in non-SSL (so I know the proc works) Any ideas Thanks, BIG Do you have the Mono.Security.Dll loaded in SQL Server yet I ...Show All

• UnKnown Nick SQLIOStress and Partition Alignment Settings using DiskPart

  Hi all, According to the suggestions from most articles on the Internet talking about SQL/Exchange Data & Log files' performance tunning, I used DiskPart.exe to create a partition with the parameter: create partition primary size=40000 align=32. After I formatted this partition with 64KB allocation units setting, I run SQLIOStress tool on the volume, here's the some information in the report file which I think not match to what I did for this partition. 09/28/06 00:11:36 00003676 ------------------------------------------------------------------ 09/28/06 00:11:36 00003676 Device information pertaining to E:\temp\simulator\stress.mdf and Drive E 09/28/06 00:11:36 00003676 -------------------------------------------------------- ...Show All

• EvilOneSD Top-Variable-Case

  Hi, I have something like the following in a stored procedure. SELECT DISTINCT top @rowCount a,b,c FROM tblA ORDER BY c DESC The @rowcount value is passed in by the user to the SP. It can be 0 or >0. Do I need to write two queries - one using the TOP keyword as above and another with no TOP as follows: IF @rowcount>0 SELECT DISTINCT top @rowCount a,b,c FROM tblA ORDER BY c DESC ELSE SELECT DISTINCT a,b,c FROM tblA ORDER BY c DESC Or...is there some other construct (such as CASE - which I tried but couldn't get to work) that can handle this condition-check from within the query Thanks much. I'd rather not use SET Rowcount because this SELECT is actually part of an ...Show All

• ADG Updating Data for a List_Table

  Here is my scenerio: I have a few older tables with a few thouands of records that I inherited. I am using data access pages as the front-end for now which is very limited. I made List_Tables for common values example below: I am trying to use these List_Tables to Input Data Consistently via Dropdown lists . I am able to input data into the Old Table from the Data Access Page /w the List_Table Dropdown , but I am unable to read any data from the Old Table on the front-end even is the data is the same . Once I enter a value from the New Table it will display . Is there a way for me to update the data value from the old table to that of te new table A case statement or something so my New Table Dropdown will display everything Very Confusi ...Show All

• Chrisull How can I programmatically tell if agents are running?

  Ideally I am looking for a procedure that I can call in T-SQL to verify that the Log Reader, Snapshot, and Sql Agents are all up and running on a given server. I found the undocumented sp_MSrepl_distributionagentstatussummary proc and got it to work for the distribution agent. I also found sp_MSrepl_agentstatusummary, but I've yet to get this to work. Overall, I'd really like to have a better way to do this. This absolutely must be something callable from the sqlcmd interface. It can not be through a UI nor anthing more complicated than standard T-SQL. Any suggestions Books Online explains each column for each table, as well as the various values for column runstatus. For example, MSdistribution_histo ...Show All

• G. Dean Blakely BIT-Wise Aggregation

  Hi, I have the following three tables : Account (Id int, AccountName nvarchar(25)) Role (id int, Rights int) AccountRole (AccountID, RoleID) In Role table - Rights Column is a bit map where in each bit would refer to access to a method. One account can be associated with multiple roles - AccountRole table is used for representing the N:N relation. I want to develop a store procedure - which would return all AccountName and their Consolidated Rights. Basically I want to do a BitWise OR operation for all the Rights in the Aggregation instead of the SUM as shown in the following statement. SELECT Account . Name , SUM ( Role . Rights ) FROM Account WITH ( NOLOCK ) JOIN RoleAccount ON RoleAccount . AccountID = Account ...Show All