• Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices

    I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message: "Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Data Scrub in Oracle 10g

    I am looking for algorithm for Data Scrub in Oracle 10g - I work with sensitive data and I need to get some help as to how to go about this and if any body can come up with some codes, I really appreciate that. There are some ready made softwares available, but I am interested in getting to know...

    Jug5 pointsBadges:
  • Longitude field

    I created a table and form for data, which includes a latitude and longitude field. Lat and Long date will be entered as degrees decimal. The lat/long data will be used for mapping purposes (exported to a GIS). For proper mapping, the longitude data must be negative. I don't want to rely on the...

    Starfish5 pointsBadges:
  • Community Update: New Member Contest Win a XBox 360 this month for your participation.

    After a long, stressful day in IT, video games can be a great way to unwind and relax. That’s right, you know where this is leading. It’s time for a cool new contest on IT Knowledge Exchange. The month of September ( Sept 1-Sept 30) is your chance to get your hot little hands on your very own...

    ITKE997,645 pointsBadges:
  • Sum Values Of A Particular Column In A Tilde Delimited File on Solaris

    Hello All: I need to sum the values in the 3rd column in my tilde delimited file on Soalris. Is there any command that will let me do this? Thanks

    Gchahl25 pointsBadges:
  • Move data in SSIS via store procedure

    How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?

    Dreadoux5 pointsBadges:
  • Oracle Data types

    I am just learning an ORACLE 9i Book and i was seen that in number Data type the Range is Lies between 1 to 38 in Decimal And -84 to 127 of Scale Range How it is possible because these Fraction degits are subtratect from whole degits ex:- var1 number (5,25);--------------(1)--it is possible? var2...

    Tejas5 pointsBadges:
  • DML

    What is DML.How to use DML in AS400. What is the advantage of using it?

    rajeshece1,215 pointsBadges:
  • DTS of TEXT to BLOB or CLOB

    Is there a maximum size to DTS from text to a Blob or clob ?

    Donranny5 pointsBadges:
  • Move media to one location

    Currently I have (2) locations for the Data Center defined in BRMS and they are *HOME and DATACENTER. Currently, Operations has to verify expired media when it moves from DATACENTER to *HOME. I think this is a waste of time so I want to get rid of the DATACENTER location. Design a plan to move all...

    as400lady5 pointsBadges:
  • SPSS Data in Data Editor BUT Unable to Analyze

    I have successfully downloaded the 1998 RAND HRS fat file data and the data is present in Data Editor of SPSS. However, I am unable to analyze the data - the prompt I receive is that the system is not responding and it seems like the computer is locked. I also observe an asterick preceeding the...

    Irishman0015 pointsBadges:
  • data input

    what method of data input would be best for printed questionnaires?

    Fishbowl15 pointsBadges:
  • jasper ad-hoc report takes more time

    problem is that jasper ad-hoc reports take more time how to resduse it ,some time it take less time but some time it takes more than expected what is the solution of that . If may be any problem please tell me as soon as possible.

    Suneelhbti10 pointsBadges:
  • How to generate MDX query from cube?

    hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.

    Harsai5 pointsBadges:
  • Database Question.

    Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information about...

    Vandy875 pointsBadges:
  • datamart & datawarehouse

    What do you mean by DATAMART & DATAWAREHOUSE & what is the difference betwen two??

    Pratap12315 pointsBadges:
  • Community Update: New Contest Announcement.

    Now is your chance to win an Amazon gift card based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. This is how the contest works: The top 10 most active members from now until the end of July...

    ITKE997,645 pointsBadges:
  • Migrating data from Oracle 9i Database to SQL Server 2005

    I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

    SQL Server Ask the Experts2,585 pointsBadges:
  • how to update DATA AREA

    hi, I have a data area(ABC) i am able to retrieve DATA AREA(ABC) in my RPGLE program and i am doing some caluculation on content of dataarea once again i want to update the data area with new value and if i come out of rpgle program i am doing DSPDTAARA ABC command on command level but i am getting...

    Mohan K695 pointsBadges:
  • Explaining features in SQL Server 2005

    I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

    SQL Server Ask the Experts2,585 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.

Thanks! We'll email you when relevant content is added and updated.

Following