No announcements
Found 1736033 threads
-
0 VotesSSIS Flat File Source – New Additional Columns to Already Existing Structure
To deal with this you can extend the length of the flat file output columns to a larger value to accommodate any length range you may anticipate.Answered | 3 Replies | 1354 Views | Created by Mpumelelo S - Tuesday, November 19, 2013 2:59 PM | Last reply by Jim Young (Level6 Productions) - Tuesday, November 19, 2013 4:56 PM
-
0 Votes
Flat Files – Column Lengths
For Flat File connection managers, you can use the "Suggest Types" button in de Advanced Pane.Answered | 4 Replies | 1239 Views | Created by Mpumelelo S - Monday, November 4, 2013 1:07 PM | Last reply by Mpumelelo S - Monday, November 4, 2013 5:03 PM -
1 Votes
Flat Files - Column Concantenation
I am using the default settings on the Flat File component.Answered | 10 Replies | 1208 Views | Created by Mpumelelo S - Tuesday, March 4, 2014 11:06 PM | Last reply by M Vega - Wednesday, March 5, 2014 3:36 PM -
1 Votes
Reorder columns in Flat File Destination
I used the MERGE JOIN in Data Flow Transformations before creating the FLAT FILE DESTINATION.Answered | 5 Replies | 7859 Views | Created by S Prashant - Monday, August 1, 2011 1:34 PM | Last reply by Intern825 - Tuesday, May 27, 2014 6:10 PM -
0 Votes
Adaptive Flat File Destination Columns
Then use this and sent it to a Flat file destination as one column.Answered | 5 Replies | 3895 Views | Created by marcgfx - Friday, September 10, 2010 10:33 AM | Last reply by COZYROC - Friday, September 10, 2010 1:15 PM -
0 Votes
Flat file with Dynamic Columns
Hi Marc, The standard Data Flow Task supports only static columns defined at design time.Answered | 3 Replies | 762 Views | Created by marcusq71 - Monday, August 31, 2015 7:46 PM | Last reply by COZYROC - Sunday, September 6, 2015 4:55 PM -
0 Votes
Load header columns into Flat File
Hi Amaya14, Based on my research, every time we check/uncheck the "Column names in the first data row" in the flat file connection manager, the ...Answered | 4 Replies | 1045 Views | Created by Amaya14 - Friday, December 19, 2014 3:52 PM | Last reply by Katherine Xiong - Monday, December 22, 2014 10:36 AM -
0 Votes
Export to flat file with column headings
Easy: there is a setting in the Flat File Manager - General Page - Column Names in the First Data Row.Answered | 1 Replies | 6227 Views | Created by David L. Carr - Wednesday, April 27, 2011 3:23 PM | Last reply by ArthurZ - Wednesday, April 27, 2011 3:26 PM -
2 Votes
Flat File column issue in SSIS
Hi SyedF, as Harry Suggested, go to the Flat File Connection manager Editor and go to Column delimiter and enter space as shown ...Answered | 3 Replies | 895 Views | Created by SyedF - Friday, May 6, 2016 5:16 PM | Last reply by Prasad msbitips - Sunday, May 8, 2016 7:47 AM -
0 Votes
column seperate with = in flat file destination
OK, so from the Derived Column transform, send it to a Flat File Destination Adapter (in the Toolbox alongside other Destination adapters) and configure it accordingly.Answered | 3 Replies | 4854 Views | Created by Praven C - Monday, April 25, 2011 11:32 AM | Last reply by Todd C - Monday, April 25, 2011 12:17 PM -
3 Votes
Flat File Connection Manager with Variable Number of Columns
If your flat file is smaller size in records, you can try this.Answered | 14 Replies | 4327 Views | Created by Adam Quark - Thursday, September 21, 2017 7:35 PM | Last reply by RyanAB - Thursday, September 28, 2017 6:20 PM -
0 Votes
Column name Changed in flat file
Hi, I guess that since you have the source file column names, SSIS didnt have any problem because you had changed the column names in the file, ...Answered | 1 Replies | 1290 Views | Created by sqlmania - Wednesday, April 3, 2013 2:01 PM | Last reply by Harry Bal - Wednesday, April 3, 2013 2:58 PM -
0 Votes
Dynamically gather flat file source columns?
Is there a way for it to populate the list of source columns based on the actual flat file?Answered | 4 Replies | 3341 Views | Created by Steve Schlichter - Tuesday, April 14, 2009 6:43 PM | Last reply by Sudeep Raj - Monday, April 20, 2009 11:38 AM -
0 Votes
Flat File Import, Ignore Missing Columns?
If the columns coming are dynamic, then you might have to first get it into staging table with a single column reading entire row contents onto that single column and parse ...Answered | 2 Replies | 3927 Views | Created by SeaCloud - Saturday, July 19, 2014 1:50 AM | Last reply by Visakh16 - Saturday, July 19, 2014 5:11 AM -
0 Votes
Finding Number of columns count in flat file
By using row count transformation we can find number of number of rows in the table,but I want to know number of column in the bot the flat file.Answered | 6 Replies | 8794 Views | Created by Praven C - Wednesday, April 27, 2011 5:50 AM | Last reply by SSISJoost - Wednesday, April 27, 2011 9:37 AM -
1 Votes
Destination flat file, repeated header columns
Hi Dilip, You have to include one more DataFlow Task before ForEach Loop Task as shown Step 1 : IN first DataFlowTask, just add only ...Answered | 5 Replies | 9597 Views | Created by Dkuud - Monday, August 29, 2011 1:36 PM | Last reply by Dkuud - Monday, August 29, 2011 4:46 PM -
0 Votes
How to make Flat File's "Column Delimiter" Dynamic
"Thats simple, in the flat file connection used in destination use the expression to set the property: HeaderRowDelimiter.Answered | 12 Replies | 7283 Views | Created by Royal Thomas - Monday, July 9, 2012 8:52 PM | Last reply by Aswathy Anil - Wednesday, February 26, 2014 6:01 AM -
2 Votes
Flat File Mapping - First Column as Header
Hi Sudeep For the Multi task i mentioned i am not sure that it has that ability of 1000 Columns but i have an SSIS with 12 records and i had to use Multitask because of some ...Answered | 6 Replies | 2789 Views | Created by Suresh SSIS - Tuesday, July 21, 2009 2:20 PM | Last reply by Sudeep Raj - Tuesday, July 21, 2009 4:46 PM -
0 Votes
SSIS Flat File Source not populating varchar column
I would suggest Make your setting "retain null" to true and load the flat file, then check what happens to the values ...Answered | 2 Replies | 1200 Views | Created by DanteMKD - Thursday, November 20, 2014 4:45 PM | Last reply by AgrawalAmit - Thursday, November 20, 2014 7:04 PM -
3 Votes
Flat file Connection Manager with variable columns
The destination file would have a single column as weel.Answered | 5 Replies | 9175 Views | Created by hemalmehta0223 - Thursday, May 28, 2009 8:45 PM | Last reply by Next - Thursday, October 8, 2015 3:17 AM - Items 1 to 20 of 1736033 Next ›
No announcements
