No announcements
Found 1846991 threads
-
4 VotesImporting a File with Dynamic Columns
In essence each flat file that I import has different number of columns.Answered | 6 Replies | 10616 Views | Created by czarvk - Thursday, July 16, 2015 11:14 PM | Last reply by Aamir Shahzad Warraich - Saturday, July 18, 2015 3:59 PM
-
1 Votes
Importing From Flat File with Dynamic Columns
Hi Sasidhar, You need a Script Task to read the names and number of columns in the first row of the flat file each time and store it in a variable, then create a ...Answered | 5 Replies | 2481 Views | Created by sasidhar raju - Thursday, March 27, 2014 6:34 AM | Last reply by Mike Yin - Thursday, April 3, 2014 9:55 AM -
0 Votes
SSIS Import Excel File with Dynamic Columns
UNPIVOT DYNAMIC DATA DECLARE @sql nvarchar(max) SET @sql = ' select [Item Code],Customer,Value from ( select * from TEST ) src UNPIVOT ( Value FOR ...Answered | 4 Replies | 968 Views | Created by Ismailc1 - Sunday, March 22, 2020 9:01 AM | Last reply by Ismailc1 - Thursday, March 26, 2020 10:43 PM -
0 Votes
possible to import a spreetsheet with dynamic column name?
when you have dynamic metadata, you can not use data flow task. because data flow task doesn't support dynamic metadata.Answered | 1 Replies | 5102 Views | Created by Daniel Wu - Friday, April 29, 2011 8:09 AM | Last reply by Reza Raad - Friday, April 29, 2011 9:29 AM -
0 Votes
Flat File Import, Ignore Missing Columns?
Try below ...Answered | 2 Replies | 4257 Views | Created by SeaCloud - Saturday, July 19, 2014 1:50 AM | Last reply by Visakh16 - Saturday, July 19, 2014 5:11 AM -
0 Votes
Flat file with Dynamic Columns
It is an extension of the standard Data Flow Task with support for dynamic columns at runtime.Answered | 3 Replies | 870 Views | Created by marcusq71 - Monday, August 31, 2015 7:46 PM | Last reply by COZYROC - Sunday, September 6, 2015 4:55 PM -
0 Votes
Dynamic SSIS Flat File Import
How to you iterate through that list to import multiple files.Answered | 4 Replies | 10621 Views | Created by tonyzoc - Thursday, June 6, 2013 1:20 AM | Last reply by tonyzoc - Tuesday, June 11, 2013 11:45 PM -
0 Votes
Import CSV files with dynamic columns each row - Urgent
You can use SSIS from SQL Server 2012 - it supports changing number of columns in flat files.Answered | 4 Replies | 10438 Views | Created by JohnnyKahWang - Saturday, April 14, 2012 4:49 PM | Last reply by JohnnyKahWang - Sunday, April 15, 2012 7:37 AM -
0 Votes
Import text file to specific column
I want to use the same worksheet to hold my text file or data imports (4) files.Answered | 2 Replies | 827 Views | Created by texastwostep - Tuesday, August 18, 2015 4:32 PM | Last reply by texastwostep - Tuesday, August 18, 2015 5:23 PM -
2 Votes
Bulk Import from files with different column order
So how do YOU (as a person) know which column in your csv files goes with which column in your table?Answered | 11 Replies | 6102 Views | Created by SQLUser1979 - Friday, January 8, 2016 4:18 AM | Last reply by Erland Sommarskog - Friday, January 8, 2016 11:17 PM -
0 Votes
SSIS Import dynamic files
Only if you are sure as to which data needs to to which column can you proceed.Answered | 5 Replies | 3254 Views | Created by Ninja mynci - Tuesday, April 7, 2009 10:14 PM | Last reply by Ninja mynci - Tuesday, April 14, 2009 2:38 PM -
0 Votes
Dynamically determine name, number and datatype of columns for data import feed
Hi there, I have a requirement which will involve recieving a csv file from a client annually.Answered | 1 Replies | 2513 Views | Created by wattyjnr - Friday, May 25, 2012 3:42 PM | Last reply by Chuck Pedretti - Friday, May 25, 2012 3:46 PM -
0 Votes
how to import a file when the file added new column, unexpectedly?
It is an extension of the standard Data Flow Task, which allows dynamic columns at runtime.Answered | 6 Replies | 2804 Views | Created by light_wt - Monday, October 24, 2011 9:24 AM | Last reply by no_prakash - Thursday, October 27, 2011 7:34 AM -
0 Votes
SSIS Handle dynamic File columns
This package should handle dynamic columns from flat file.Answered | 1 Replies | 1356 Views | Created by Paddy Paddy - Friday, August 23, 2013 2:56 PM | Last reply by ArthurZ - Tuesday, August 27, 2013 3:14 PM -
0 Votes
How to import a dynamic excel sheet to a dynamic database table.
You can simply do this in Transact SQL itself using OPENROWSET ie code will be like SELECT * INTO YourTableName FROM ...Answered | 3 Replies | 5178 Views | Created by MarlonCo - Sunday, January 12, 2014 1:57 AM | Last reply by Harry Bal - Monday, January 13, 2014 9:50 PM -
0 Votes
Handling variable number of columns on imports
You can import all your 3rd party data feeds using only one data flow.Answered | 5 Replies | 4654 Views | Created by AngelStar - Friday, December 31, 2010 11:40 AM | Last reply by Suresh M. Menon - Monday, January 3, 2011 2:42 AM -
0 Votes
dynamic column creation for flat fi
Hi Ramaraju, SSIS doesn’t support dynamic columns natively.Answered | 2 Replies | 753 Views | Created by ramaraju vegesana - Wednesday, November 13, 2013 9:57 AM | Last reply by Mike Yin - Friday, November 15, 2013 4:36 PM -
0 Votes
CSV importing unwanted columns
If you can guarantee that your first 3 column will be always there then there is a simple solution for this 1. create your flat file connection ...Answered | 14 Replies | 8115 Views | Created by wattyjnr - Wednesday, April 13, 2011 10:43 AM | Last reply by wattyjnr - Thursday, April 14, 2011 11:47 AM -
0 Votes
Dynamic Column
Not sure if I fully understand your question but I think you're describing dynamic datasets?Answered | 3 Replies | 1306 Views | Created by vamsi1980 - Wednesday, June 12, 2013 8:22 AM | Last reply by SathyanarrayananS - Wednesday, June 12, 2013 11:15 AM -
2 Votes
Import text file to Foxpro each Char is column
Hey everyone I have a problem importing a text file.Answered | 2 Replies | 2750 Views | Created by Dante80 - Friday, August 10, 2012 4:18 PM | Last reply by Tamar E. Granor - Monday, August 13, 2012 8:11 PM - Items 1 to 20 of 1846991 Next ›
No announcements
