• 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:
  • 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:
  • SPSS Binary Regression

    Please could you help me out. 1) Question I have a binary question. It involves the sex op people being surveyed. I have to enter (into SPSS) if there are "Male" or "Female". After I have entered "Male" or "Female" can SPSS convert "0" for Male and "1" for "Female"? Thanks.

    Harry191929295 pointsBadges:
  • Loading a new database from an Old one

    I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I'm not sure how to cope with PK's that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner table eg. A list of...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • where clause condtion as a variable (SSIS 2005)

      Let's say we have this query   select * from customer where customerid = '1'   My question is can we create this "customerid = '1'" condition as a variable in SSIS and once it becomes a varible then I will extract the conditions for a column in table,

    SSISquestio5 pointsBadges:
  • opening spss saved data

    I cannot open my saved data on spss.I had saved this earlier so i can work on it but it cannot open the file.i can open the saved frequency tables though

    Tevita5 pointsBadges:
  • spss casestovars problem with one variable

    I have a dataset in spss containing an ID, Period (when a test was given i.e. 1, 6, 12) and 8 numeric variables representing whether a test was done (0 or 1).  I sorted the data by ID, ran the CASESTOVARS code and 7 of the variables always 'reshape' just fine. The 8th variable will not reshape....

    Jkernan5 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