Answer Questions

• sgrathikala Execute Command Process - remote batch file?

  Good afternoon- Can a batch file that resides on another server be executed from a different machine I have a batch file that resides on a server that I would like to run using SQL 2005 Integration Services. Is there anything I can do that would allow me to remotely execute this batch file and have it run in that environment. BATCH FILE: cd C:\Trandev\ otrun -at OTRecogn.att -DINPUT_FILE=%1 -tl 1 -cs dv -lg mylog -I C:\Trandev represents t ...Show All

• faex DateTime and Date problem

  I have created a cube with two dimensions in as2005.  A time dimension and a "data" dimension.  The "data" dimension is a table from a db that has a field called "ItemDate" that is of type DateTime.  In the Dimension usage panel of the cube designer I create a reference in the time row to the "ItemDate" in the data dimension.  The problem arises when I want to count how many "data" rows have a date of "March 27 2002".  ...Show All

• borix69 ConnectionString

  Thanks for the reply, this is what I have tried: E134017 is the name of my computer on the LAN \\E134017.nw.nos.boeing.com is the full path I think also \\E134017 can also be used to identify my computer to others on the lan/  The following connection string will work on my workstation only, others computers cannot find it or sql won't honor their request for data. con As New SqlConnection("Data Source= E134017 ;trusted_connection=true;In ...Show All

• Dustin - FSA SCD (Slowly Changing Dim) DTS vs SSIS Best Practice

  Hi there,   Is the best practice of managing change with Type II SCD used in DTS still valid on SSIS, or should we use the SCD transformer provided out of the box   Thanks. -w The SCD component provided in SSIS2005 has been designed to solve the majority of cases that customers should meet. As with any technology there are always boundary cases where the boxed solution is not efficien ...Show All

• venil Restricting Access to a database

  Hi I wish to setup a database that can be viewed only by a few users. How do I stop other users and the general public from seeing the database and its structures. Cheers Al Users won't be able to see objects in new databases because they won't be able to switch to them, as Jens already mentioned. If you don't want them to know about the databases either, you should revoke the VIEW ANY DATABASE permis ...Show All

• erichan Need suggestion on loading a 50 million records table from Oracle

  All, I need to load a 50 million records table monthly. Any suggestion about the best/fast way to do it Thanks a lot All I tried today; it used 8 hours to load the data just from the Oracle table to the staging table on sql server 2005. It is unacceptable!!! There are must be a better way to do it. In the data flow, there is only an OLE DB source (from Oracle) ----> data conve ...Show All

• Steve Galic - MSFT Transfer Access database into SQL Server 2005 Express

  Hi, A question regarding SQL Server 2005 Express edition. Is it possible to export Access databases into SQL databases without using programming (e.g. using SQL and programming languages) I understand you can do this with DTS, but the Express edition seems not have DTS. Many thanks Yuelin I tried to use the Upsize Wizard but, I recieve connection errors when trying to connect to the SQL Ser ...Show All

• Lucc Standby Restore

  I'm setting up log shipping and am running into an issue with applying the transactions logs. This is my 5th server that I'm setting up and I take a backup of the source database, restore it with replace on the standby server. Then I take a log backup, copy it over and try and restore on the standby server, but the LSN#'s are off. It tells me it's too late for the log and try an earlier.. The timestamp on my backup is 11:43 and my tran ...Show All

• Etienne2005 Notification Services Architecture

  I have starting using Notification Services and I was wondering if somebody can tell me if the NS use triggers behind the scenes in order to start events. I'm no NS guru, but I took a look at one of my running instances and there are no DB triggers at all in either of the two associated databases. ...Show All

• HerbD Problem getting SQL Server Express Service to Start

  I have had SQL Server 2005 (Full Version) installed along with SQL Server Express and suddenly SQL Express quit starting and will not start manually. I have reinstalled VS 2005 (Team Edition for Software Dev) and tried to reinstall SQL Express but the installation fails when it tries to start the service. Any suggestions Keith Thanks Keith, Just to be clear, are you getting this error while installing or just when trying to start t ...Show All

• PattiBiggs Problem with Slowly Changing Dimension-transformation

  Hi, I have a problem with the SCD-transformation in SSIS. I have a variable that holds the batchid for the current batch and I want to add this variable to the datapipline in the Data Flow Task. This is done by using a Derived Column, so far so good. The problem occurs in the Slowly Changing Dimension transformation where I do som evaluations of changed columns BUT I don’t want to do any evaluation of the batchid-variable because then all histor ...Show All

• JimSornig Case Statement

  Hi! I need a case that returns the result of a select if it is not null, and -1 if it is null. I did it this way: select case when ( select column from table where conditions ) is null then - 1 else ( select column from table where conditions ) But it doesn't seem very clever to repeat the select statement. Is there any way I can do it without repeating the " select column from table ...Show All

• SuperMarkyMark UK Datetime parameter problem SQL 2005 RS

  Hi, I am having a problem with the DateTime parameter option in SQL 2005 reporting services. Note that Server, workstation and database are set to British/English (UK) date/time localisation (dd/MM/yyyy) for example 25 th December 2005=25/12/2005. I create a simple query with a parameter on a datetime column and set the report parameter to Data type: DateTime in the report parameters dialog. On preview or after deploy ...Show All

• MTennants Management Studio doesn't run!

  Hi, I recently installed SQL Express Edition on a completely clean installation of Windows XP SP2 with all updates until yesterday. I use default instance name (SQLExpress) and tested the instance in many ways; all seems to be cool.   But, when I installed Management Studio CTP Nov, installation process finiched without any proble, bu when traying to tun the application either from Start Menu or installation program files folder, it doesn't ...Show All

• Jarrod M. Dynamic Page Breaks

  Hi everyone, This is my first thread.  I have been working with Reporting Services and love the way I can change the Groupings and Sortings on the fly.  I need to be able to dynamically change which Groupings have a Page Break either before or after as well.  There is no expression to enter for the Page break attributes however! Does anyone know of a way to dynamically change the Page break attributes at run time Thanks, ...Show All