• Data Extraction into SQL Server Database from Cache ODBC Database

    Hi.I am trying to extract data from an intersystems cache database into a sql server database for storage and reporting purposes, on behalf of my company. I have not succeeded so far for the last couple of months as it keeps bringing back far more than the expected number of rows, and is...

    SPIDDY0 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:
  • Excel Spreadsheets

    We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...

    Joshua55 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:
  • SSL VPN risks?

    What are the real-life security risks of implementing SSL VPN? Data loss, exploit from unprotected system, SSL botnets, etc.

    ITKE366,125 pointsBadges:
  • Replicator and cluster replicator task

    If two servers are in cluster then does the cluster replicator task run on both the servers or on an single server? Similarly if we have established replication between servers, does the replicator task run on single or both the servers???

    Mohit04130 pointsBadges:
  • IPv6

    Has anyone here migrated to IPv6? It it as simple as it sounds? http://www.searchnetworking.com/searchNetworking/downloads/IPV6.mp3

    CalendarGirl0 pointsBadges:
  • Fill out your profile and add a picture to win an iPad

    If you haven't filled out your profile and added your picture, do it now and you could win an iPad. Once you've added your picture and filled out your profile, add a comment to this post to let me know and I'll give you 100 Knowledge Points.  To increase your chances of winning, here's how to...

    EmNichs3,250 pointsBadges:
  • V6R1 storage limit exceeded for data queue

    Just upgraded to V6R1. Getting the following message in one of my applications: Storage limit exceeded for data queue. Why and how do I correct?

    Kfbarl5 pointsBadges:
  • Defining AS/400 Data Areas

    I need to access a numeric data area. I do not know at program exection time the library of the data area. This is defined within the program.

    Kreed1015 pointsBadges:
  • Master Data Management

    Does anyone have any best pracrice information regarding implementation steps and business requirements needed to define and implement MDM?   thank you

    PJGieg5 pointsBadges:
  • Hide field which is present in DDS

    I want to hide data of specific field which is present in DDS.The requirement is even in the runqry that field should be hidden....

    Onelonely10 pointsBadges:
  • Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows

    How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?

    MLM10 pointsBadges:
  • Earn 250 Knowledge Points now by tweeting out our contest

    We've recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: JaideepkhandujaOwenAmbroseCarlosdlRyan8613MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don't have to be...

    JennyMack4,280 pointsBadges:
  • How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page?

    How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page? Copying as Table from Notes creates the links and it works when pasted to Excel or Word...but not Access. Importing to Access from the working Excel file then breaks the hyperlink in...

    Rakmup55 pointsBadges:
  • Access DataArea which is not in my *LIBL

    How can I access a data area from a different library without change my library list in RPG III

    22917560 pointsBadges:
  • *LDA error message -“DtaAra already defined”

    Hi, I am trying to fetch data from *LDA. So that I coded like [strong]*DtaAra Define *LDA LDA [/strong]and then compile the program. But the compiler throw me an error says that [strong]“DtaAra already defined”. [/strong]When I search the string DtaAra and LDA in the source, I am not found any...

    22917560 pointsBadges:
  • When using IfNull in my SQL, records are ignored

    I know my data table has nulls in it. If my select statement doesn't include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here's my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,' ')...

    Frydaze120 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