• The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • Crystal Reports

    I am working on a report in Crystal Report, I have a stored Procedure like this ALTER PROCEDURE [dbo].[usp_cust_by_activity] @carrier as VARCHAR(10) AS --drop table #custA --drop table #custPA --drop table #cdrall --drop table #cdrPrevMonth --SET @carrier = 'PR' --'PR', 'RG' SELECT...

    Urpalshu0 pointsBadges:
  • How to speed up AS/400 SQL?

    We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow - 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, we created...

    Sloopy2,195 pointsBadges:
  • Round robin for data syncing with Windows Server 2003 SP2

    What is the best way to set up round robin on several file servers and have the files data be synced between the boxes? This is using 4 Windows 2003 SP2 Servers. They share all files for the sales force and customer service.

    TeachMeIT975 pointsBadges:
  • 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:
  • Branded URL redirects are mirroring the website. Is this managed in the DNS or by the website host?

    Bvechik5 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.

    ITKE342,785 pointsBadges:
  • data transfer to excel via client access

    with client access Version 5.00, I would like to upload a file to excel 2007 by using data transfer command

    Annieguibert5 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???

    Mohit04125 pointsBadges:
  • IPv6 training/education

    What sources would you recommend for training on IPv6. I'm not really interested in a router/firewall configuration course. I want training/education on the IPv6 protocol and addressing schema. I know I can go read lots of RFC's on it but that is rather dry and can be difficult to absorb. Do you...

    Labnuke9932,960 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:
  • I want to know if it is possible to transfer data from Iseries to a web site and upload some back. This is for our bank and we do not want to use FTP

    We need to send files to our bank and receive files back via a web site. What would be the best way. This is the only data we send out of the company now so we would like to do it with what we have and not spend money. We do have a new Iseries with V5R4 so I thought we could use Websphere. What do...

    Foolsewing25 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:

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