• Help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

    GIG240 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to convert a csv file into a xlsx one?

    Hi, I'm generating a csv file from an open hub in BW so I need to convert it into a xlsx one due to I need to upload it into the Microsoft SharePoint. Is there an abap function that does it? I know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • How can I split CSV strings in Oracle 9i?

    I'm trying to to split several CSV strings in Oracle 9i but I'm running into a few issues so I have a couple of questions: Is this possible in Oracle 9i? Do I need to create a new data type? Would I be able to declare the type within the function? Thank so much!

    ITKE413,725 pointsBadges:
  • Can you explain what cluster shared volumes are? Is this a new file system?

    Can you explain what cluster shared volumes are? Is this a new file system? This question is from the 7/30 Microsoft Virtualization Chat on ITKnowledgeExchange.com

    ITKE413,725 pointsBadges:
  • Sequence information of mutltiple subforms in one form?

    I have one form embedded 3 subforms. I need to identify which subform is the top of the form because I need to write out the fields value to CSV in subsequently left top to right bottom as user can see on their PC.

    koseiarai5 pointsBadges:
  • CPYFRMIMPF – CSV to flat file. Getting all blank records.

    All records in the flat file are blank when performing a cpyfrmimpf. Copy file command is listed below. DTAFMT is *DLM, FLDDLM is ',' A sample from the file in IFS is listed below. What am I missing. CCSID of file in IFS is 1252. CPYFRMIMPF FROMSTMF('/ITG/OGAZIP/districtzip.csv')...

    dpitts4619495 pointsBadges:
  • How to match CSV field values in SQL Server 2005

    i have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...

    Sanjeevgoyal5 pointsBadges:
  • How to convert SQL Server 2008 R2 BPA output into CSV?

    I have been using SQL server 2018 R2 BPA for getting data from Microsoft. When using SQL Server 2005 to export results I could do so in a CSV format. When we upgraded two servers to Server 2008 I found that I could no longer run BPA 2005 on these. We then upgraded to 2008 R2, which again does not...

    ITKE413,725 pointsBadges:
  • Script to extract files information from FTP server

    Hi, I wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will: Log on to a ftp server using a generic account and password It then find the files (no downloading) in a specific folder that begins with...

    Aiko2720 pointsBadges:
  • Import AD data from CSV file to 2003 ad

    We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.

    Karl Gechlik9,860 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • How to create a CSV file in PHP code?

    I need to create a physical CSV file from PHP code. I have many solutions to get the results to print to a screen, but I need a file... any ideas?

    Texmansru4725 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • Take .csv files and show that on a subfile

    Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option - upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with a 'U' to upload and the...

    RamvishakRamesh2,505 pointsBadges:
  • QEXECSQL command source

    Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this - could you please let me know. Alternatively is there is another better utility for...

    Pclarkeirl5 pointsBadges:
  • Crystal Reports CSV with quotes inside string

    I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: "Andy", 4685, "requires 5" by 2" silver plate", 1132 According to CSV standard it should be: "Andy", 4685, "requires 5"" by 2"" silver...

    Moltar5 pointsBadges:
  • RPG ILE Scan csv file

    I am scanning a comma delimited file for elements to populate a db2 file. However, it is not picking up the last segment because there is no ending comma. How can you recognize the end of a row?

    Streeter45 pointsBadges:
  • Exporting a (.csv) file from SQL 2005

    Hi, I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a...

    Jeager6640 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