• 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

    ITKE354,840 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:
  • How well does SSAS run under virtualization? Any special considerations?

    How well does SSAS run under virtualization? Any special considerations?

    ITKE354,840 pointsBadges:
  • remove password from SSIS package

    How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don't know the password. This package was created by an employee who left the company a couple of years ago.

    Rmk3255 pointsBadges:
  • Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    NET20085 pointsBadges:
  • SQL 2005 SSIS Package to load table from positional flat file

    I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The first...

    Dacker5 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