• SPSS Data in Data Editor BUT Unable to Analyze

    I have successfully downloaded the 1998 RAND HRS fat file data and the data is present in Data Editor of SPSS. However, I am unable to analyze the data - the prompt I receive is that the system is not responding and it seems like the computer is locked. I also observe an asterick preceeding the...

    Irishman0015 pointsBadges:
  • How to generate MDX query from cube?

    hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.

    Harsai5 pointsBadges:
  • Community Update: New Contest Announcement.

    Now is your chance to win an Amazon gift card based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. This is how the contest works: The top 10 most active members from now until the end of July...

    ITKE54,665 pointsBadges:
  • Migrating data from Oracle 9i Database to SQL Server 2005

    I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Spss data analysis

    Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don't know which of THESE...

    Noms15 pointsBadges:
  • Data analysis, SPSS

    Hi, I am trying to find out the demographics (age, gender, ethnicity etc) of my final subject pool on SPSS. I used a survey type questionnaire, and want to know which subjects completed all the measures of interest. I f I do a cross tabs with ageXgender, for example, I don't know which of THESE...

    Noms15 pointsBadges:
  • How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    Deepanshu35 pointsBadges:
  • Assigning access to SQL Server Integration Services (SSIS) packages

    How do we assign access for users to SQL Server Integration Services (SSIS) packages?

    SQL Server Ask the Experts2,585 pointsBadges:
  • About data management

    Hi i have same date like this; 1 ..... ..... 2 ..... ..... 3 -26 -28 4 36 -53 5 -40 -46 6 ... ..... 7 56 -64 8 -31 -29 ı want to change this date like this 1 ..... -28 2 -26 -53 3 36 -46 4 -40 ... 5 ... -64 6 56 -29 7 -31 ... 8 ... ... one column go up a line other column go up two line but...

    Bronzemoon5 pointsBadges:
  • Working with totals

    I am trying to run cross-tabs (year x gender) on a data set made up of total scores (rather than frequencies) in each cell, but the output only gives me counts. Is there a command to let SPSS know that the cell figure is a total?

    Spcase5 pointsBadges:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

    Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over...

    Sahaj5 pointsBadges:
  • How do I integrate SQL Server Integration Services and Blaze Advisor?

    I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE54,665 pointsBadges:
  • having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 pointsBadges:
  • SPSS, Tuckey problem

    Hi, In my SPSS data I have found a (significant) main effect. Now I want to explore this effect, to see what is the cause of it. I would like to find a contrast in an interaction. At this point I have split the file "manualy" by using split file, and then conducted: general linear model ->...

    Stijn5 pointsBadges:
  • Download files from a sharepoint site using SSIS.

    Hi, i want to download multiple files from a sharepoint site using SSIS Script task with VB script. I am unable to write script.

    ToWin5 pointsBadges:
  • Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I import a file to a SQL Server table with dates before 1970?

    I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...

    SQL Server Ask the Experts2,585 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