Answer Questions

• Modeller Owner for jobs(Sql2k)

  I’m looking for the owner of our scheduled jobs but I can’t work out; Sysjobsteps, sysjobs, sysjobschedules Sysjobservers, etc.. and neither of them I’ve been able to find this value. I saw owner_sid in hexadecimal notation, nothing else. Does this search make any sense otherwise sql encrypt this data Where this data stored is Thanks for any comment or though, Thanks for that. this should do: select [name],suser_sname(owner_sid) [owner] from msdb..sysjobs ...Show All

• Ecrofirt Supported Remote Execution Techniques

  Some time ago, I came across some posts that suggested that remote execution of SSIS packages was only supported if the package was wrapped by a SQL Server Job Agent job. Is this correct Would the web service technique described below then not be supported http://msdn2.microsoft.com/en-us/library/ms403355.aspx As I understand, there are approaches for running programatically: 1. sp_start_job 2. xp_cmdshell 3. Microsoft.SqlServer.Dts.Runtime API calls Understanding that SQL Server Job Agent is the preferred approach, please advise as to if any of the above are NOT supported by Microsoft. Thanks, Rick Hi Rick, Does Doug Laudenshlager's response to your question here: https://forums.microsoft.com/MS ...Show All

• Duncan Woods CASE Returning NULL

  Hello, I have a query that contains six derived columns; FirstPerYr; The current year FirstPerMo; The current month FirstPeriodRevenue; CASE the current year, use the CurrentYearSalesTable (CY). CASE the current month, match the correct column (JanRev, FebRev, etc) of the CurrentYearSalesTable to get the correct data. FirstPeriodYrAnnum; Last year FirstPeriodMoAnnum; The current month, last year FirstPeriodAnnumRev; Same as FirstPeriodRevenue, but from the year and month before. In the following query, I get the correct FirstPeriodRev value, but FirstPeriodAnnumRev comes up NULL. I know I have data for January 2006. The query is as follows; --************************** DECLARE @FirstPerYr Int DECLARE @FirstPerMo Int DECLARE ...Show All

• Bern McCarty Accesing package Variable in Conditional Component

  Hello Experts, I am trying to load data to a sql table from flat file..I have a script component which will validate the data. I am also firing the errros when data validation fails. Once I encounter an error I want the whole package to be aborted. What I have done is declared a variable called errorcount (Scope :Package) and I am incrmenting this variable everytime an error is raised and next I have a Conditional Split which will check if this variable count is greater than 0 if yes I will not update the table.This is the only way I think this will work. error I am getting is :The collection of variables locked for read and write access is not available outside of PostExecute. I understand they r in the same data flow thats the r ...Show All

• mekab How to relate InstanceID of RunningPackage object to logging?

  Iterating through Running packages as in this code from MSDN: RunningPackages pkgs = app.GetRunningPackages("yourserver"); // Enumerate through each package in the collection and display some data. foreach (RunningPackage package in pkgs)     {         Console.WriteLine("InstanceID: "+package.InstanceID);         Console.WriteLine("PackageDescription: "+package.PackageDescription);         Console.WriteLine("PackageID: "+package.PackageID);         Console.WriteLine("PackageName: "+package.PackageName);         Console.WriteLine("UserName: "+package ...Show All

• cablehead Data Flow Task - Multiple Columns from different sources to a single table

  Hi: I have a data flow task in which there is a OLEDB source, derived column item, and a oledb destination. My source is a SQL command, that returns some values. I have some values, that I define in the derived columns, and set default values under the expression column. My question is, I also have some destination columns which in my OLEDB destination need another SQL command. How would I do that Can I attach two or more OLEDB sources to one destination How would I accomplish that Thanks MA2005 In my case, I also have a derived column item, should that come before the union or after the union. I am thinking before, but please confirm Thanks. In general a data flow can have as many source components as you want; and if ...Show All

• invantix Scheduled SSIS

  Hello all, I was very familiar in creating quite complex DTS packages in SQL2000. Now with 2007 that is all gone. I looked at the command line utility and it's UI counter part but these are just for executing. I keep getting references to the SSIS designer but I can't find where it is. Can someone point me in the right direction Thanks, Jesse BIDS is a standard Visual Studio, but in the New Project dialog it should contain Business Intelligence Projects folder, with Integration Services Project in it. So, dtsrun.exe has now become dtexec.exe and it's counterpart on the UI is dtexecui.exe. The UI you see in the UI there is the same type of ui you'll see in the SQL Server Agent job. You' ...Show All

• Nishith Shah shell manager corrupt or missing

  can any body help me with this i know nothing about a pc except how to use them. the error message appears while trying to install a program what program is this sql server what's the error message would not know sql server is the program is nero. eroor message reads- shell manager corrupt or missing.. ...Show All

• KarlShare Compact Edition DVD Standalone

  Is it possible to run SQL Server Compact Edition as a standalone application from a DVD i.e. it would not leave anything installed on the users computer after the DVD was ejected. If both .Net CF2 and SQL Server 2005 are installed on the target system, you should be able to deploy the DLLs for SQL CE on the DVD. Hi: For what it's worth, I am attempting the same thing: developing a product catalog that will enable users to browse products and configure order for printing. As my product is using Framework 2, I will simply have an autorun install the program since I have to check for the existence of the framework anyway. Please post back your findings. ...Show All

• CL0CKW0RK Report Snapshot

  Hi All, Is it possible to create different report snapshot for different roles Thanks, S Suresh Can you elaborate on how roles affect report snapshots I'm not understanding your semantics. We use Roles to mean permissions collections that can be applied to a catalog item for a user, but these have no impact on report snapshots. ...Show All

• Jeremy Jarrell Can I convert/reference a string to a var?

  hey, guys I got a strange question. :) In SQL Server, declare @Item8 as varchar(100) declare @str as varchar(100) set @str = '@Item8' Is there any way I can reference @str to @Item8 Thanks No. This is not possible. Variables are scoped to batch or module or dynamic SQL batch. ...Show All

• altamash Package Runs in 1 minutes in Visual Studio but takes 5+ (sometimes hanges) as Job

  I have an SSIS package that when run from Visual Studio takes 1 minute or less to complete. When I schedule this package to run as a SQL Server job it takes 5+ and sometimes hangs complaining about buffers. The server is a 4 way 3ghz Xeon (dual core) with 8GB ram and this was the only package running. When I look in the log I see that the package is running and processing data, although very very very very very slowly. Has anyone else experienced this Thanks for your help Marcus 90% cpu utilization seems like too much. I'm getting the impression that you haven't examined the query execution in SQL Server Profiler. Correct Hi I actually ran the query through SQL Profiler and it d ...Show All

• Vikas H Migrating from Oracle 9i to SQL Server using SQL Server Data Transformation Services

  Hi, I am new to DB migration and we are migrating our DB from Oracle 9i to SQL Server(sitting in a shared environment 1) Is it possible to migrate it using SQL Server Data Transfornation services. Our DB has only indexes and tables as the queries are handled in the front end itself. 2) If yes can we connect to an oracle server using SQL Server  DTS. Do we need an oracle client also to be installed in the system from which we perform the migration task. Has MSN provides an OLE to connect to an Oracle Server though an SQL Server client Can some one list me the steps and the concerns that should be addressed    I am only a front end programmer. Please give me your suggestions       ...Show All

• Jon Braganza Very poor performance with lastnonempty aggregation function

  I have a big problem with a measure that has lastnonempty aggregate function. I set up an analysis services 2005 test cube with 4 dimensions and 2 measures. The dimensions are: Time - Year,HalfYear,Quarter,Month,Day - is a time dimension and has 365 members. Product - ProductCategory level - 1500 members - Product level - 60000 members Branch - Region level - 2 members - Branch level - 200 members Customer - Customer level - 1500 The cube has 8 partitions based an month, each partition has between 30000000 rows and 40000000 rows. All partitions use the same custom aggregations. The January partition has 31000000 rows. The measures are: AmountLastnonempty - lastnonempty aggregate function Amoun ...Show All

• Cordell Swannack Commonlity?

  Okay, here is my scenario: The information used in this description will be considered sample data, as the actual dataset is much larger. We have 3 products: F, M, and Z. Each product has several derivatives based on customization. We have one central list of parts that these products are built from, depending on the specs given. We have a number that represents the percentage of that part's occurrence in a given product ordered last year. It would look like this: PART PRODUCT FREQUENCY P1 F 1 P1 M 0.2 P2 F 0.15 P3 Z 1 P4 M 0.7 P4 F 0.34 P5 Z 0.17 P6 F 0.24 P6 M 1 P6 Z ...Show All