• Errors: Violation of UNIQUE KEY constraint ‘UN_FILENAME’. Cannot insert duplicate key in object

    when i am migrating data from oracle9i to SQL2005 i am getting the error Errors: Violation of UNIQUE KEY constraint 'UN_FILENAME'. Cannot insert duplicate key in object how should i solve the problem

    Lava5 pointsBadges:
  • Run regression based on covariance matrix

    Hi, I have tried to run a regression based on a covariance matrix (saved as Libro1.csv) but I've got the follwing message: "The READ subcommand is no longer used. Use MATRIX IN(reference) instead. Matrix input now expects an SPSS data file. Text found: READ. This command is not executed." I used...

    Stud10 pointsBadges:
  • Text handling in Visual Basic

    how can i pick a data from a file

    Amit87kumar875 pointsBadges:
  • coordinate file import

    can I import cartesian coords into acad from wordpad or exel

    Moseseh5 pointsBadges:
  • how to smoke test the data warehouse?

    I would like to know what kind of test should be performed to checkout the build and the test environment prior to testing?

    Ktkn5 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • Why do IT projects fail?-3

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    Dbrazeau10240 pointsBadges:
  • SSIS package failure message

    I am running SQL Server 2005 and my package fails with the following error: OnError MyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A} {31AB7571-ECB2-4591-BFE1-CC8D59739230} Data conversion failed while converting column "Some_Column" (5017) to column "Copy of Some_Column" (6373)....

    MarkFyffe5 pointsBadges:
  • 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...

    ITKE1,015,970 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,230 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:

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