• 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:
  • Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 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:
  • 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:
  • Showcase Query 8.0 CDs or DVDs

    I did an upgrade to V6R1 before I did an update to our Showcase Query Suite.  I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any media...

    MNBV15 pointsBadges:
  • Do your users have the right analytical tools to make informed decisions?

    Does your organization have the right analytical tools and technology to give your business users accurate data to make informed decisions?

    SPSS15 pointsBadges:
  • How do you currently collect behavioral, attitudinal, transactional and demographic data?

    How do you currently collect behavioral, attitudal, transactional and demographic data? This question is sponsored by SPSS.

    SPSS15 pointsBadges:
  • Are your analytical assets and processes visible, automated and secure?

    Are your analytical assets and processes visible, automated and secure? This question is sponsored by SPSS.

    SPSS15 pointsBadges:
  • how to manually unload ExaByte Magnum 1X7 LTO tape drive

    how to manually unload ExaByte Magnum 1X7 LTO tape drive

    ITKE346,470 pointsBadges:
  • SQL Express used for SSIS?

    Can sqlexpress be used for SSIS

    Lianv10 pointsBadges:
  • who will buy TIBCO in the end.

    Thinking on which vendor is most likelty to benefit form such a deal I conclude it is Microsoft. Because ibm and oracle+sun are selling hardware by licencing unix servers and microsoft had to play catch up.

    Phdking5 pointsBadges:
  • HBA not showing WWN

    A SearchStorage.com reader asks: WE have a data center server, 2003 servers and two HBAs in each node. Both the cards are Emulex Fibre Channel Cards. One card is already in working condition. We have recently added the second HBA card. The driver was updated, and I am able to detect two HBAs from...

    JenH0 pointsBadges:
  • Transform variables in SPSS

    I am working with a very big data set in SPSS. I am trying to transform 7 variables into 1. I figured out that the mode would be more represenative than the mean for this particular case but it is not offer in the functions of the "compute variables" option. I don't want to do it by hand. The...

    Andreann5 pointsBadges:
  • Changing date fields in SQL Server Analysis Services

    In SQL Server Analysis Services, can I change the date fields from (yyyy-mm-dd) to (dd-mm-yyyy) without turning the date field into varchar?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why is SSIS xml variable in escaped format?

    In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote...

    PaulDav5 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