• Monitor SQL Server 2000 Analysis Services Cubes

    I am working in a BI role and have some ancient AS2000 cubes that are used across the organisation. Only trouble is no-one is exactly sure who uses them daily. How can i monitor which cubes are being accessed by whom? Doesnt seem that profiler picks up AS transactions so im kinda stuck how to do...

    Bright1235 pointsBadges:
  • How to set up a disaster recovery (DR) VLAN to replicate data

    I am new to disaster recovery (DR) and IT management. I have a production site with Cisco switches, and I'm backing up data to a storage area network (SAN). I have a GB link to a remote office and would like to replicate data to another SAN at the remote location. How do I set up a DR virtual LAN...

    NetworkingATE1,545 pointsBadges:
  • Describing files using Data Description Specifications (DDS)

    Describing Files Using Data Description Specifications (DDS)'can u tell me what is the probleme IN PF

    Rmonga23065 pointsBadges:
  • Data flow for 1 PC w/ 2 NICs

    From a testing perspective, if a PC has 2 NIC's, each configured for a different subnet, does traffic actually cross the LAN since each unique MAC is represented by a unique IP according to its ARP cache? Would not the destination network need to be resolved by a router? I guess a better question...

    OP220 pointsBadges:
  • Attributes of DTAQ

    How to get the attrbutes/description of a DATA QUEUE.

    RJES45 pointsBadges:
  • New Contest: Win 1 of 3 Xbox 360’s

    New Contest: A trio of Xboxes for our top three users Now through the end of April, you can not only show off your IT skills by asking and answering questions on ITKnowledgeExchange.com, but you can earn the chance to spend some quality time honing your bad-guy-vaporizing skills on your very own...

    ITKE356,195 pointsBadges:
  • split column into column

    I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.

    Shamilh10 pointsBadges:
  • Power surge on Hub port

    How to update your DT9837 module

    Persistence5 pointsBadges:
  • Using SSIS to populate SQL Server Data Warehouse

    I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?

    RodVerity20 pointsBadges:
  • Transform Data task properties not opening.

    In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

    Sinto5 pointsBadges:
  • iSeries to SQL Server via SSIS 2005

    We have multiple DB2 Schema's that are indentical. iSeries tables built using DDS. Looking for a way to use a varible to declare schema vs. having hard coded SQL Statements in SSIS.

    Oldmickey65 pointsBadges:
  • Finding the average of a data type on a SQL Server

    I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Dynamic/Data-driven page creation and content

    Hello! Sort of a "newbie", so please forgive the ignorance. I want to be able to build a page (and edit screen) dynamically, based on some mechanism of persistable per-control screen location/formatting/field masking information - storeable/retrievable as a "unit", representing a particular "view"...

    Galaxis5 pointsBadges:
  • Record Count

    how could i find the record count of a file using fileaid ?

    Ahi5 pointsBadges:
  • SSIS and Microsoft Excel

    I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

    Cathryn35 pointsBadges:
  • Manufacturing quality control application traffic – any Aegis users?

    Are there any Aegis users out there on ITKE? If so, how does the XLink server perform in your environment? What kind of network traffic do you see to/from a host running this application? I have an XLink system that has a consistent 50Mbps inflow of data from 2-3 AOI systems. Is this expected...

    Labnuke9932,960 pointsBadges:
  • Ensuring the same data is served when using multiple load balanced servers

    I have a Web server and I need to add another Web server. We will use a load balancer to take care of distributing the load between the 2 Web servers. Users are capable of uploading files and data via FTP and HTTP. I need a technique that will help me make replication for these files and data...

    SearchStorageATE215 pointsBadges:
  • Does Oracle Stream data replication requires identical tables structure between source and Target Databases?

    We are considering the use of Oracle Data Stream to replicate data from operations database to a separate Helpdesk database. Our users require near real-time data loaded in the helpdesk database. What are the constraints imposed by Oracle streams for table design? Does it require for tables...

    Ss20095 pointsBadges:
  • Crystal Reports 8.5 filed data convertion

    How can you do data conversion on the fly for selected records but in indivitual fields? e.g. string data ="5" new string data = "3" (5-2=3) string data = "10" new string data = "8" (10-2=8)

    Iirdtype10 pointsBadges:
  • Microsoft SSAS with Cognos Front End

    Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?

    Sjors & Sjimmie5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following