• Exporting data from SSIS to Excel

    I am trying to export data into Excel from SSIS. For the purpose of this question, the table is called “products” and has two columns. I would like to extract each row of data into a separate Excel file and save it with the product name so I can email it accordingly. How do I go about this?

    WindowsServerATE335 pointsBadges:
  • Reading flat file defined as DBCS

    Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF      ...

    Dodiaz10 pointsBadges:
  • Data Compression with Remote Journal

    Is there a way to apply some sort of data compression (remove repetitive blanks) with a remote journal. These journal entries are for records added to a databse file containing a single 32K long field.

    Rhoover40 pointsBadges:
  • Data Transfer from AS400 to excel

    i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP if...

    Saranyahere5 pointsBadges:
  • iSeries Access ODBC Driver Error

    I'm trying to run a stored procedure on MS SQL Query Analyzer but continue to get the following error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2...

    Sixpach0 pointsBadges:
  • SQL Server Query

    How to find the second highest value in a table using a Query. For example, in a table of employees how to find the second highest salaried employee.

    Radhika0 pointsBadges:
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • 3 bit parity

    I was just reading about parity on searchstorage.techtarget.com and have a question about 3 bit parity vs. 1 bit parity. I understand the setting to 0 for an even # of bits and setting to 1 for an odd #. Doesn't seem very reliable because you could lose 2 bits in data transmission. Just wondering...

    Bdpowell25 pointsBadges:
  • Are you using Excel for cost estimating?

    Over at ConstructionSoftwareReview.com, we have noticed that a fair number of cost estimators, cost engineers and contractors in the construction industry use Excel to determine how much a particular project will cost and to prepare the cost estimate that they present to potential clients. Is...

    Beastwood1,105 pointsBadges:
  • What tools are required for Hadoop?

    I'm just starting to study the HADOOP from a job point of view. Will it require Java programming? What type of other tools are required?

    Tejaswinee5 pointsBadges:
  • Corrupt File on Windows Server 2003

    Hello All, I just got this error on my Windows 2003 Server "the file or directory C:WINDOWSDebugUserModeChkAcc.log is corrupt and unnreadable. Please run the Chkdsk utility". What do I do? Thanks All... Rgds, Jennifer.

    Jjjjjjjj95 pointsBadges:
  • DBCS “open data type” problem – time-critical situation

    BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software's database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type "A" to data type "O". Our case tool is recognizing...

    Choyle100 pointsBadges:
  • AS/400 Data Queue – WebSphere ESB Integration?

    Hi - I have an application on the iSeries that uses AS/400 Data Queues for messaging. I'd like those messages to make their way to our Websphere ESB without having a custom application on the 400 that will copy the objects from the data queue to WMQ, and then onto the bus. Does anyone have any exp....

    Yall5 pointsBadges:
  • Data integrity

    I have a server that uses NHibernate, and I’d like to load balance multiple instances of this server. Database is huge. If I use a distributed second level cache like memcached, NCache or sharedcache, are there still potential data integrity issues? Suggestions are appreciated :)

    CemreonLee5 pointsBadges:
  • Retrieving a data area between two AS/400 systems

    How do you retrieve a data area between 2 AS/400's?

    Dweygandt5 pointsBadges:
  • Data Migration Test Plan

    Can anyone give me a sample and simple Data Migration Test Plan? Or simply Data Migration Plan.

    SKADA5 pointsBadges:
  • Descriptive output in SPSS

    How can the descriptive output be graphed in SPSS?

    misslien5 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:
  • Which database is better: MySQL or NoSQL?

    We are e-learning company and have a product based on client server model. We are currently using MySQL but facing problems with the installation as it takes longer time to install all the prerequisites. Is there a better way or better database option available? Switching to NoSQL-Mongo DB will be...

    RyanHaris5 pointsBadges:
  • How can I structure this in SSIS?

    Within SSIS, I need to do the following: Select the max(to_date) + 1 from a table in SQL Server. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I do...

    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.

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.