Stack Overflow
Stack Overflow

Questions tagged [flatfilesource]

28 questions
0
votes
3 answers

Split Flat File String into multiple columns in Informatica

I have a flat file (csv) with 1 column (ColumnA) having data in the format ==> 100-000500-10-40000-000-200-600-000 I need it split into 8 columns (values adjacent to the hyphens) and concatenate the 2,4 and 5 splitted sub values. How do I do this in…
Orion997
  • 3
  • 1
  • 2
0
votes
1 answer

How to transfer data from one csv file to another using SSIS?

I have two CSV files. Content of first file "c.csv" is : Id,Name 1,Abhishek 2,Abhi and 2nd file "d.csv" is empty. In SSIS, after creating a package. I am creating a control flow, then data flow. In the data flow, I am importing "flat-file source"…
abhishek
  • 49
  • 9
0
votes
0 answers

Meta Data Column doesn't match with source column names in Informatica Powercenter

I am loading data from a CSV Flat File into a target Oracle DB using Informatica. The Flat file contains Arabic Column Names and I happen to create the table with similar column names using double-quotes. But when running the map it gives me the…
Zeeshan Mohammed
  • 43
  • 1
  • 10
0
votes
1 answer

Same filename with different columns on each loop

I have a foreach loop that looks up the same filename but for each pass, the file gets populated differently with different columns. My flatfile source throws an error when it tries to read the new rebuilt file - Im kinda expecting that my recordset…
CodeMonkey217
  • 1
0
votes
1 answer

How to load Flat files to SQL Server Tables according to the Name of Flat File?

There are hundreds of flat files for each file i need to create a table in SQL-server and enter the file contents into the table example : Flat_Files: SQL-SERVER Table: FileA.txt fileA FileB.txt …
jpn
  • 43
  • 9
0
votes
2 answers

SSIS - How to Insert from Flat File to OLE DB with date range?

I have a flat file source with columns that have start and end dates per row, and the table I am attempting to insert into only has one date column, which means I have to insert 1 row per week from the start date until the end date. Sample FF…
John M.
  • 51
  • 1
  • 3
0
votes
0 answers

SSIS :Flat File Source Transforming it into Two OLE DB SQL Table (Throwing Errors when I Convert and Sort before Loading into OLEDB Source)

I'm trying to take a flat file and turn it into two tables in SSIS and Load to a OLEDB Source (SSMS). I have the tables created in SSMS already that match up with the flat file that the rows are separated by ,'s. I had to do a data conversion…
DanSmith123
  • 1
  • 2
0
votes
1 answer

How to load string from flat file into date in target table(Teradata) using informatica?

I am trying to load string from flat file into date in target teradata table using informatica. But while doing that, my workflow is succeeding but data is not loading into table. When I run the debugger, data is passing through, SQ, expression. …
S.P
  • 1,775
  • 5
  • 14
  • 21
0
votes
1 answer

Parse unstructured flat file on SSIS

I have a problem parsing the unstructured text file. I tried to upload everything into one column with data type DT_STR but it throws error since there are special characters like '=' in my file. I tried with DT_TEXT data type, it worked well. But I…
krpa
  • 84
  • 1
  • 13
0
votes
1 answer

Removing duplicates based on composite key in MS access

I have imported a flat file .csv file in MS access 2010. It contains following rows: Site_number, Site_name,Tsite_number, Contact_type,First_name, House_name The composite Primary key being Tsite_number+Contact_type. I need to remove the rows in…
newuser
  • 69
  • 3
  • 14
0
votes
1 answer

load file with csv extension in ssis

I have to load file with csv extension from one particular folder to data base in ssis. file name is not known but folder and extension is fixed.
John
  • 1
0
votes
1 answer

ssis retain null values from source replaces blank string with null which results into integrity violation

i am using flat files to transfer data from one db to another db using SSIS. to keep the null values as null in destination db. i selected "Retain null" of flatfilesource. but it also replaces my blank strings with nulls. which results into failure…
Radhi
  • 6,289
  • 15
  • 47
  • 68
-1
votes
1 answer

SSIS - How to insert into OLE DB destination using SQL command while the source is flat file?

I want to know how to insert value in SQL Server database with the flat file source in SSIS using SQL command. I've done inserting it using table view, now i have to insert it using SQL command
Yuni Widyaningtyas
  • 31
  • 7
1
2