• Database refresh

    i want to refresh the database for every week from a cluster environment. could you please suggest a feasible option not back and recovery. I tried the following ways: 1. through SSIS database transfer task-but it failed 2. through copy database wizard-not working please tell us how to work through...

    BOKAMD815 pointsBadges:
  • SSIS – Bulk Inserts dynamically into various tables depending on the input file name.

    I have a scenario where a folder consists of various files with the format 'ABC_DbName_Date_TableName.txt' and there are many Databases with DBNames For e.g. - DB1, DB2 DB3 etc consisting of tables created every day with a 'Date_TableName' format. I need to provide a prompt to accept a folder name...

    NewLearnerSSIS5 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • SSIS package failure message

    I am running SQL Server 2005 and my package fails with the following error: OnError MyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column "Some_Column" (5017) to column "Copy of Some_Column" (6373)....

    MarkFyffe5 pointsBadges:
  • Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices

    I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message: "Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Community Update: New Member Contest Win a XBox 360 this month for your participation.

    After a long, stressful day in IT, video games can be a great way to unwind and relax. That’s right, you know where this is leading. It’s time for a cool new contest on IT Knowledge Exchange. The month of September ( Sept 1-Sept 30) is your chance to get your hot little hands on your very own...

    ITKE344,825 pointsBadges:
  • Sum Values Of A Particular Column In A Tilde Delimited File on Solaris

    Hello All: I need to sum the values in the 3rd column in my tilde delimited file on Soalris. Is there any command that will let me do this? Thanks

    Gchahl25 pointsBadges:
  • Move data in SSIS via store procedure

    How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?

    Dreadoux5 pointsBadges:
  • 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...

    ITKE344,825 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:

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