• SSIS 2008 R2 Change Configuration File Location

    Starting with SSIS 2008, the /conf option no longer overrides the location of a configuration file. The dtexec documentation states to use the /SET option to override its location. My problem is I can not figure out the syntax to change c:\foo.dtsconfig to d:\foo.dtsconfig.

    Notjust5 pointsBadges:
  • from 1 to 1440 in SPSS

    First: How do i create a time serie in spss from 1 to 1440 (1440 rows)? Second: if this is to be done in a time format (00:01, 00:02, 00:03........23:59) how can I do that? THX

    JakobH5 pointsBadges:
  • filtering data in spss

    I have a large, publicly available data set that I must analyze with PASW 18. I wish to only use a subset of this data (respondents who answered "yes" to "have you ever been told by a doctor that you have diabetes" for data analysis. Any advice? I have tried everything I know.

    Cfarrpalmer5 pointsBadges:
  • Database Analytics

    How prevalent are in-database analytics today? Is everyone doing it?

    Adamdavis0 pointsBadges:
  • Reg:Problem with SSAS

    Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I need to first migrate the...

    48102145 pointsBadges:
  • Setup SSIS for a group of developers.

    I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12...

    Cnboon5 pointsBadges:
  • The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?

    I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL...

    RobertDBA5 pointsBadges:
  • Statistical significance and CIs for Population Survey

    Hi, I have a data set that is generated from a population survey of a licensed profession in the state. I have a 63% response rate. I am generating demographics (age, gender, race, degree level distributions) and descriptives for age, hours worked etc. How do I generate CIs and statistical...

    SOSINeedHelp5 pointsBadges:
  • MaximumErrorCount

    HOW DO I CHANGE THE MaximumErrorCount IN SSIS

    Vercom5 pointsBadges:
  • SSIS cache

    We are developing packages in a SSIS environment using Version 9.00.3042.00. I’m presently having problems or a misunderstanding on when to use Partial or Full cache on lookups. Seems like the lookup results differ when using these two modes. For example, full lookups often “succeed” (turn...

    Kurt5 pointsBadges:
  • Generate binary dataset after weighing cases in SPSS

    Hi, I have some variables that are of binary format (0,1) and of which I produce cross-tabs. In the case that there is a weighted variable, SPSS "imputes" some of the values "weighting" them either as (0) or (1). However, there is no way to know which values have been replaced (I cannot find any of...

    Polyc5 pointsBadges:
  • Weighting variable in SPSS?

    How do I use the weighting variable in SPSS

    AJOUPA5 pointsBadges:
  • Refresh Excel file on a different server with SSIS package

    I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

    Tocken10 pointsBadges:
  • Write Record to table as XML from RecordSet destination

    Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

    Kayj5 pointsBadges:
  • Without Using Script in SSIS

    HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script... please help me T_T.... Thx so much... :D

    SSISCaseStudy5 pointsBadges:
  • Tool for ETL/SSIS packages testing

    Which is the Best Tools for ETL/SSIS packages testing

    Contactvishal5 pointsBadges:
  • I want to select some rows and show the average of columns of that rows in another row how can i do that in SPSS?

    i want to select some rows and show the ave of colums of that rows in anaother row how can i do that ?

    Za905 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:
  • 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:

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