• Import data file into SQL database

    I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

    Anamika8315 pointsBadges:
  • Storage VMotion

    I am reorganizing the datastores for DR replication. Problem is I have a couple of servers that have a data drive on different data store than the vmx file. When I tryo to move the vm to another datastore it wants to drag the data drive with it. How can I storage vmotion the vm server from one data...

    ITKE1,021,210 pointsBadges:
  • Data Warehouse Query Performance

    We have a data warehouse with summary and detail level data with Cognos as the reporting tool.  If we have data for 100 large customers loaded in the fact tables and are trying to use Cognos Query Studio.  Here is the scenario:  one user has access to data for 5 customers through the security...

    Florida7775 pointsBadges:
  • Dataguard Oracle 10g

    When replication methode logical is used. And there is a change in tables or in fields will this be replicated or will only the data be replicated?

    196506065 pointsBadges:
  • Expert Configuration of MS Exchange delivery Notifications

    Hi! [strong]Detailed question below:[/strong] [strong]Introduction[/strong] A custom DLP (http://en.wikipedia.org/wiki/Data_Loss_Prevention) solution installed to: 1. monitor all emails sent by emplyees 2. save these emails in a database for audit, to enforce corporate security policy...

    Philip75t5 pointsBadges:
  • Help with Data Quality

    Data Quality is a big issue in our firm as we have a lot of applications and inputs into our production databases.  Is Microsoft doing anything to help us with data quality, especially on existing data?

    ITKE1,021,210 pointsBadges:
  • Visual Studio 2010 to edit DAC Packs in SQL Server 2008 R2

    Will I need Visual Studio 2010 to edit DAC Packs?

    ITKE1,021,210 pointsBadges:
  • Data Mining in SQL Server 2008 R2

    Are there any investments in Data Mining in SQL Server 2008 R2?

    ITKE1,021,210 pointsBadges:
  • What is DAC?

    Why is the concept of “data tier applications” abbreviated as DAC?  Inquiring minds want to know.

    ITKE1,021,210 pointsBadges:
  • Fetch to datastructure in RPG/400

    I have one rpg pgm in which I am creating a cursor on select to slect some records.After then I am opening cursor and fetching its data to an external data structure.Now my question is whether the external data structure takes only one record(first record) or it will have all records selected...

    Alicsc370 pointsBadges:
  • Win a Dell Precision T7500 Workstation

    All you have to do is correctly answer 5 multiple choice questions, each with a hint provided, and you could be the owner of a new Dell Precision T7500 Tower Workstation Desktop Computer with the Quad Core Intel Xeon Processor. Even if you don't win, you still get 200 Knowledge Points for your...

    EmNichs3,250 pointsBadges:
  • Data entry and calculations in the same cell

    I have an excel template and would like to allow the user to input their date in one of two ranges and have the other range calculated automatically based on a formula to use in each cell This means that the formula needs to be outside the cells in the two ranges as they are both used for date...

    Askm5 pointsBadges:
  • Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

    When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

    Thuybui35 pointsBadges:
  • Filter & sort data tables in excel 2007

    When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn't allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two ranges separately and...

    Helenacvdm5 pointsBadges:
  • Business Continuity Plan for SAP 4.6C upgrate to ECC6

    Has anyone experieced a long downtime (1 week ?) for the upgrade resulting in business being required to carry out transactions on 4.6C while upgrade is in progress ? How do you handle the incremental data migration afterwards ?

    YukPengYap5 pointsBadges:
  • Windows XP compatability issues

    My office is just now buying Micosoft Office 7.0 and installing IE 8.  They have aske d me if there are any campatability issues with my verion of SPSS = version 15.9 for windows.

    Lockj5 pointsBadges:
  • Conversion Project

    We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....

    ITnavan0 pointsBadges:
  • Hi I am new for Data Analysis, I want to know how to start for this profile

    Hi I am new for Data Analysis, I want to know how to start for this profile. What are all basic requirements and start from? I know computer basics I am good in Excel. What else required?

    Minisharma5 pointsBadges:
  • Migrating DTS packages that use mainframes source to SSIS

    I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

    Jwalini5 pointsBadges:
  • preventing or capturing spool data when the DFU command is issued

    DFU log reports are not being picked up in a timely manner. Users can delete spool files before Robot has a chance to pick them up. These are the logs that get created anytime anyone issues the Data File Utlity command (STRDFU). This command allows the user to change files, thus the desire to have...

    Ramjet505 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.

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

Following