• Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit

    The proposed data warehouse platform will be a 64 bit platform - both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I'll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

    Jmc5 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE350,890 pointsBadges:
  • access2k unicode text column even # of bytes error

    a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...

    Santa35 pointsBadges:
  • Classic Applications Display as “Unix Executable Files” in Tiger and Don’t Load

    We just purchased an iMac G5, and I copied all of the applications/documents/etc. from the old computer, a G4 running 9.2.2 over to it. I installed the Classic system folder on the iMac (running Tiger) and have no problems getting it to load. The problem is that all applications that were copied...

    HailiFrank15 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • domain operational data stores vs. enterprise operational data stores

    When do use a domain operational data stores rather than a enterprise operational data store?

    Alisonnelson5 pointsBadges:
  • How to create blocks in SPSS

    I have a data file with 12,00 trial inputs. When I run my descriptives, I want to combine every 100 trials together as 1 block so instead of comparing 12,00 trials, I am looking at 120 blocks and comparing those. Is there anyway to do this without first going through and running the statistics on...

    Audreye5 pointsBadges:
  • having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 pointsBadges:
  • DTS schedule package

    How can I see the scheduled run time of an existing DTS package?

    Hoverman5 pointsBadges:
  • SPSS, Tuckey problem

    Hi, In my SPSS data I have found a (significant) main effect. Now I want to explore this effect, to see what is the cause of it. I would like to find a contrast in an interaction. At this point I have split the file "manualy" by using split file, and then conducted: general linear model ->...

    Stijn5 pointsBadges:
  • Snort Log Retention

    Is there any reason I should keep year-old snort log files? Only techs access the system and I need the space.

    Chunter110 pointsBadges:
  • Download files from a sharepoint site using SSIS.

    Hi, i want to download multiple files from a sharepoint site using SSIS Script task with VB script. I am unable to write script.

    ToWin5 pointsBadges:
  • Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal report

    I just started a job as a data analyst and wanted to see if any want can help me build a report on crystal report. Claims billed by month Claims outstanding by month Monthly report showing write off ‘bad dept’ Thanks

    Mosaidi5 pointsBadges:
  • How do I import a file to a SQL Server table with dates before 1970?

    I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • What formula do I use to calculate file transfers across a T1?

    I have a site that is 70ms away. What formula do I use to calculate throughput for different file sizes? Thanks

    Rvp5 pointsBadges:
  • Unable to execute the saved SSIS package.

    I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

    MNA20 pointsBadges:
  • How SSIS works with cluster SQL and non cluster SSIS service?

    According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED. http://msdn2.microsoft.com/en-us/library/ms345193.aspx Now this is the situation that I have where I need to understand how SSIS works? Enviornment: Active Active cluster enviornment for SQL server with SSIS server...

    Munnu5 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