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

    ITKE828,875 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...

    ITKE828,875 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