• Load table in AS/400 database using Talend

    When i try to load a table in a AS400 database using talend 2.4.0, it given me an error like "There might be an error in SQL statement"

    Varunnt865 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:
  • The most-watched IT questions this week: Feb. 16, 2010

    1. JHite ran into an Outlook 2003 display name issue for contact with multiple email, and XENOPHON22, Mrdenny and Carlosdl helped out. 2. Windows Server 2003 is giving a member some installation trouble, and MrDenny offers some advice. 3. Can you block Exchange 2007 admins from viewing other...

    ITKE829,010 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:
  • The IT Blog Top 10: Feb. 4, 2010

    Here are the most popular blog posts on the ITKnowledgeExchange network this week. Read the rest of the top 10 on the Community Blog, or apply for your own blog by e-mailing me at Michael@ITKnowledgeExchange.com. 1. How to allow the root user to log in to VMware ESX Server with SSH David Davis’...

    Michael Morisy8,598 pointsBadges:
  • Enterprise Cobol obtaining calling program name

    Enterprise Cobol v3.4 on Z/OS 1.9. Batch called program. I want to parse through mvs data areas to obtain the program name that called my program(dynamically). I have viewed examples on Share website to get some system info. I need specifically the program name that called my program. Is this...

    Dfailla5 pointsBadges:
  • AS/400 to SQL Server Data Migration

    What are the steps involved in migrating data from AS/400 to SQL Server. Could you please elaborate as I'm pretty new to such migration work?

    Datamig5 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:
  • The most-watched IT questions this week: Feb. 2, 2010

    Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

    Michael Morisy8,598 pointsBadges:
  • Using DataPager with a Child Grid

    I'm using the RadGridView with a DataPager on a Parent Grid and it works fine.  For each row in the ParentGrid, I'm defining a RowDetailsTemplate to have a child binded grid.  This also works fine, but I can't use the DataPager with the inner child grid.  The reason seem obvious to me, but the...

    Nyker2025 pointsBadges:
  • Textbox input to a a sql dataset table in Vb.net

    How do I input data from textboxes in Vb.net to ...a table in a  data set ....and then display generated data back to some more textboxes ???? I am using sqlexpress ....Thx. mace100

    Mace1005 pointsBadges:
  • passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases.  I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables.  Also we are not allowed to use the...

    LL12325 pointsBadges:
  • What steps are involved when source DB is a Oracle and target db is SQL Db?

    How to test  when source DB is a Oracle and target db is SQL Db? What  to test  in particular when source DB is a Oracle and target db is SQL Db? I have worked on when both the target DB  and Source Db was SQL Server.How is it different when Source Db is ORacle and Target DB is SQL Server....

    Mayurkhe295 pointsBadges:
  • Cataloging Stored Procedures

    Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of say our...

    ATHMAU0 pointsBadges:
  • Pros & cons to have a typical star schema but with only one fact value field and a thousand attribute names in one of the dimension tables?

    Want to build a kind of a scientific fact search and analytical engine for a lot of different types of measurements hosted in a lot of source tables and columns. A star join schema is built and data is copied (ETL) from the sources as usual - but all source column values are stored into a single...

    Rwg30 pointsBadges:
  • Data Junction 7.0

    I'm attempting to use Data Juntion to create a reference table (DB4)from a proprietary database to use as input to a reporting appliation.  I need to create between 1 and 12 output records from each qualifying record from my database.  Is this possible in Data Junction?   Thanks!

    Gegrobe5 pointsBadges:
  • Export Oracle 10g and Import to Oracle 9i

    I have a data warehouse server that's running Redhat AS 2.1 and Oracle 9.2.0.4, and a production database that's running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I know...

    Llewis5 pointsBadges:
  • Data migration strategies

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • The most-watched IT questions this week: Dec. 15, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Ak1bo78 asks for a C# how to on IF Statement’s, which Mshen and CarlosDL help create. 2. Dbsi2006 asks for help on how to map drives without UNC, which Rklanke, MrDenny,...

    Michael Morisy8,598 pointsBadges:
  • The IT Blog Top 10: Dec. 10, 2009

    10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8....

    ITKE829,010 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