Stack Overflow
Stack Overflow

Questions tagged [flatfilesource]

28 questions
4
votes
3 answers

Problem to import datetimeoffset from csv file to a table via SSIS

I've a csv as a source file that I'm trying to load the data from this file to a stage SQL server table. There are three date columns. The below is an example of values of these columns: 2007-10-02T08:46:13+02:00 On SQL server side, I've defined…
Florentina
  • 85
  • 1
  • 1
  • 10
4
votes
1 answer

How do I convert the string "NULL" in a flat file to DATETIME or DATETIME2?

tl;dr: How to I convert "NULL" in a flat file to a NULL in SSDT/SSIS? In SSMS run this code: /* Run once SET NOCOUNT ON CREATE TABLE #source (DT DATETIME, DT2 DATETIME2) CREATE TABLE #target (DT DATETIME, DT2 DATETIME2) INSERT INTO #source VALUES…
Scott
  • 169
  • 1
  • 3
  • 14
2
votes
1 answer

SSIS Flat file connection

I am getting a flat file as given below. I have been using ssis to load this data. It has 9 dynamic column name and only first three columns has the row data and rest don't have any data. In the flat file connection manager. I have selected: row…
MSM
  • 327
  • 2
  • 6
  • 12
2
votes
2 answers

How to import Flat-file with no column header using SSIS?

I want to import the flat file using SSIS. My flat file has 50 columns but no column header. So it shows like Column 0, Column 1, and so on. I don't want to manually assign column name using the advanced editor. Is there a way to dynamically assign…
Nilesh
  • 21
  • 2
2
votes
1 answer

Import multiple flat files to multiple SQL Tables

Here's my folder setup. Here's the File setup The idea is to traverse through the folders & put FileA contents to Table FileA.dbo on the database ( also FileB,FileC etc). The FileName structure is same throughout all the folders. I have this ssis…
thestralFeather7
  • 529
  • 2
  • 10
  • 28
1
vote
1 answer

Load big one line flat json file in ssis

I am trying to load a big file which basically is a json format flat file from my local drive to SQL Server by using SSIS. It's a one line file and I don't need to specify columns and rows as I am going to parse it as soon as it's in SQL Server by…
feilaidaike
  • 13
  • 2
1
vote
0 answers

Meta Data Column Name doesn't match with source column name in Informatica power center

I am loading data from a CSV Flat File in to 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 above…
Zeeshan Mohammed
  • 43
  • 1
  • 10
1
vote
1 answer

Potential Loss of Data reading from CSV with decimal

I have read a large number of questions and answers on this and I still can't get it to work. I have a csv like the following: Field1;Field2;Field3 CCC;DDD;0.03464 EEE;FFF;0.08432 ... When I attach a Flat File Source, in SSIS, it gives me the…
Diogo Santos
  • 780
  • 4
  • 17
1
vote
0 answers

SSIS:The Flat File Connection Manager is unable to read fixed width txt file properly

I need to read data from a fixed width txt file which will be put on the server and write that data to a SQL table through SSIS package. The problem is that when I open the txt file in notepad, the data seems to be unformatted (first row seems…
Hafsa Khan
  • 25
  • 5
1
vote
1 answer

SSIS Data Flow Task column data type float, ignore string values

I am setting up a simple data flow task to pull in multiple CSVs to a SQL Server DB table. A number of columns in the CSV are float but occasionally will say 'N/A*'. I want to keep these columns as floats and make any string in them convert to…
talbe009
  • 81
  • 7
1
vote
3 answers

Indirect load in Informatica

How does indirect load in informatica work internally. Does it collate all the data and then process the data or it does processing for one file at a time? If I have duplicates spanning multiple files, will the duplicate removal logic in my mapping…
mitesh jain
  • 13
  • 2
0
votes
1 answer

Loading only distinct records into table via IICS

I have a 4 flatfiles which are coming everyday,I'm taking these r flatfiles as list files as indirect file load. My requirement: I have to load these records in 4 flatfiles into the database. But the problem is I have to load only distinct records…
Intiyaz
  • 9
  • 3
0
votes
1 answer

How I can configure flat file name as filename_*.txt in SSIS

I have flat file source and connection manager. I need to configure its connection string as filename_* .txt. I have one variable on package level to read the directory path and then I am using it in expression property to read the file path as…
Nilesh
  • 518
  • 1
  • 9
  • 26
0
votes
0 answers

How do I pass a file from parent to child package in SSIS?

Recently started working on SSIS package, I have two packages _main.dtsx & child.dtsx. the _main package contains foreach loop that parses through all the files in a specific folder on C: drive. Depending on the name of file I have added a…
Walter
  • 79
  • 6
0
votes
1 answer

Schema for Flat File

I have to do to a transformation from flatfile to xml but the problem is that the flatfile has multiple child nodes and the child nodes have sub nodes as well. The records are occuring multiple times in the file. I had created a schema but it…
abhishek bisht
  • 33
  • 4
1
2