Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
-1 votes
1 answer
172 views

I'm attempting to use a temporary SQL Server table ##temptable to preprocess imported data from flat .csv files. I created the temporary table in the first step of the control flow, calling a stored ...
0 votes
3 answers
126 views

I have a requirement where I have to offload data from SQL server to a pipe separated flat file. Issue is we have a column whose values are typically all special characters that are present on a ...
0 votes
0 answers
56 views

using (XmlWriter writer = XmlWriter.Create(manifestFilePath, new XmlWriterSettings { Indent = true })) { writer.WriteStartDocument(); writer.WriteStartElement("manifest"...
0 votes
0 answers
56 views

I am given a flat file and need to convert that flat file into EDI formatted file through SSIS. Can someone help me with this how to proceed.
0 votes
2 answers
84 views

I have a multiline flat file which I wish to convert to an rdd/dataframe as a 4 column dataframe, or rdd array via PySpark. The Spark Scala code is, #from pyspark.sql import SparkSession # Scala ...
0 votes
1 answer
151 views

I'm trying to load files from SAP ECC using Azure Data Factory, so I have a Data Flow and a pipeline that executes said Data Flow. Everything goes smoothly until I try to load the file into a SQL ...
0 votes
0 answers
59 views

Working with legacy software which generates files. This one is a ragged right file that is also fixed width, except since the last line doesn't have the delimiter it's 2 characters short and the last ...
babno's user avatar
  • 309
0 votes
1 answer
57 views

This code (truncated) works: SET GLOBAL local_infile = 'ON'; SHOW GLOBAL VARIABLES LIKE 'local_infile'; LOAD DATA LOCAL INFILE 'E:\\MM012224.txt' INTO TABLE `denton24`.`mm012224` ...
markj's user avatar
  • 1
0 votes
1 answer
116 views

I have a "fun" flat file I need to import. It's mostly fixed width with every record consisting of 516 characters, except the last record is only 514 and when importing as fixed width it ...
babno's user avatar
  • 309
1 vote
1 answer
160 views

I have some flat files where each line is about 300 characters. The data has no delimiters of any kind and I want to parse the file to introduce some sort of delimiter between fields. There are ...
1 vote
1 answer
97 views

So I am pretty new with JS and using loops to get data formatted in a JSON tree from a flat file. I am trying to build an SAP UI5 app and load the data into a tree table. I have this data roles: [ ...
0 votes
0 answers
41 views

Mysqlimport (and 'load data ...') are incorrectly importing data from my flat-file input. The commands I've used to load are: load data local infile '/srv/django/tmp/icdo_prev/orders_icdodiagnosis.csv'...
0 votes
0 answers
58 views

We have some proprietary software that processes print files (AFP) and within the scripting for a process it makes a call to a SQL server via ODBC once per page in the file. This might mean something ...
Colster's user avatar
  • 81
-1 votes
1 answer
293 views

I have a flat file as "barn","40","10,120","bill" which I have to separate, I tried using quotes as delimiter but there is another quote and comma which ...
-1 votes
2 answers
61 views

I am using the following code to import a xlsx flat file: master = pd.read_excel("H:/Python_data/profit_US_07 2023.xlsx",skiprows=[0]) I would like to create an alias called infile_nyc ...
Ramoss's user avatar
  • 1

15 30 50 per page
1
2 3 4 5
...
56

AltStyle によって変換されたページ (->オリジナル) /