No announcements
Found 2038672 threads
-
0 Votespossible 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 | 5192 Views | Created by Daniel Wu - Friday, April 29, 2011 8:09 AM | Last reply by Reza Raad - Friday, April 29, 2011 9:29 AM
-
4 Votes
Importing a File with Dynamic Columns
It is an extension of the standard Data Flow Task and supports dynamic columns metadata at runtime.Answered | 6 Replies | 10973 Views | Created by czarvk - Thursday, July 16, 2015 11:14 PM | Last reply by Aamir Shahzad Warraich - Saturday, July 18, 2015 3:59 PM -
0 Votes
Dynamic column names
You can't have "dynamic" column names in the data flow - but you can request dynamic columns from your source, as long as when they get ...Answered | 7 Replies | 3924 Views | Created by Jamal112 - Thursday, January 14, 2010 4:08 PM | Last reply by Nik - Shahriar Nikkhah - Thursday, January 14, 2010 5:53 PM -
2 Votes
Dynamically define column name
Instead of using COALESCE([Column],[Column_Name]) just use the Column.Answered | 8 Replies | 22529 Views | Created by Vick72 - Wednesday, December 26, 2012 8:50 PM | Last reply by Vick72 - Thursday, December 27, 2012 6:57 PM -
0 Votes
Dynamically determine name, number and datatype of columns for data import feed
Any additional type massaging would be done in derrived column or data conversion blocks.Answered | 1 Replies | 2559 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
dynamic Pivot column names
Type the values in those parameters and it will populate all the columns, then go through the link I sent you to create a matrix report.Answered | 3 Replies | 4091 Views | Created by sharepointduke - Friday, January 20, 2012 7:24 PM | Last reply by Shahfaisal Muhammed - Saturday, January 21, 2012 1:37 AM -
0 Votes
exporting data to excel with dynamic column names
Please see if this example is exactly what you wan: http://www.rafael-salas.com/2006/12/import-header-line-tables-_116683388696570741.html It may be ...Answered | 2 Replies | 4392 Views | Created by madhur_ms - Wednesday, September 28, 2011 3:02 PM | Last reply by ArthurZ - Wednesday, September 28, 2011 6:51 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 | 2619 Views | Created by sasidhar raju - Thursday, March 27, 2014 6:34 AM | Last reply by Mike Yin - Thursday, April 3, 2014 9:55 AM -
1 Votes
Dynamic column names - username
> In addition to what is above I really also need dynamic username columns to be created as part of a column name - so that the results are like - for each ...Answered | 5 Replies | 1364 Views | Created by rqwew - Wednesday, April 13, 2016 3:07 PM | Last reply by --CELKO-- - Monday, April 18, 2016 11:42 PM -
0 Votes
Dynamic Column Names
I know its a bit confusing with the name) @Deadline = Time.Answered | 10 Replies | 1647 Views | Created by m4ni - Tuesday, September 24, 2013 8:03 AM | Last reply by Dinesh Kumar Rajendran - Tuesday, September 24, 2013 10:29 AM -
0 Votes
Is it possible to create dynamic columns in reports
But dynamic columns in reports depends on complexity of template design and dataset this is upto my requirement that i got.Answered | 6 Replies | 5464 Views | Created by Computer Surgeon - Monday, April 20, 2009 4:19 PM | Last reply by Prawin Kumar Sreeram - Saturday, January 28, 2012 6:16 PM -
1 Votes
dynamic table using column name as a slicer selection
>>I am wondering if it is possible to do so, is it possible to create dynamic table using column name as a slicer ?Answered | 3 Replies | 1259 Views | Created by Bob_Tang - Monday, August 6, 2018 9:29 PM | Last reply by Bob_Tang - Tuesday, August 7, 2018 10:02 PM -
1 Votes
Importing Excel Sheet which have dynamic column name and dynamic number of columns
I need to import the csv file and load it into sql server destination.The file name, no of columns and column names would be varying all the times.Answered | 11 Replies | 18098 Views | Created by Anthony Desa - Saturday, August 25, 2007 12:14 AM | Last reply by Daggubati Ram - Monday, January 16, 2012 12:43 AM -
0 Votes
SSIS Import Excel File with Dynamic Columns
Next I get a list of the column names DECLARE @list varchar(8000) DECLARE @temptable table (width varchar(100)) INSERT INTO @temptable (width) SELECT ...Answered | 4 Replies | 1087 Views | Created by Ismailc1 - Sunday, March 22, 2020 9:01 AM | Last reply by Ismailc1 - Thursday, March 26, 2020 10:43 PM -
0 Votes
Excel source with Dynamic Column Name
HAve you checked that First row has column names property in excel connection manager ..Answered | 18 Replies | 7266 Views | Created by MS308 - Tuesday, January 3, 2012 7:31 AM | Last reply by MS308 - Thursday, January 5, 2012 4:08 PM -
0 Votes
Is it possible to send a table/column name as a param?
Also i dont see how you send the tabl name and col name as params.Answered | 4 Replies | 945 Views | Created by Octopus01 - Tuesday, November 19, 2019 7:22 PM | Last reply by Octopus01 - Wednesday, November 20, 2019 3:29 PM -
1 Votes
column name of custom columns is possible of translating automatic
Hi, When you create a column, the name you enter is just a constant string.Answered | 2 Replies | 965 Views | Created by mcsuareza - Tuesday, March 17, 2015 2:13 PM | Last reply by Lisa Chen1226 - Wednesday, March 18, 2015 7:01 AM -
0 Votes
SQL Query Column Dynamic Alias Name Issue
If you want dynamic column names, the only way is to use Dynamic SQL.Answered | 3 Replies | 19270 Views | Created by sreeni2219 - Monday, February 8, 2010 11:58 PM | Last reply by Ed Price - MSFT - Saturday, April 27, 2013 4:36 AM -
0 Votes
Dynamically change source columns
It is an extension of standard Data Flow Task with support of dynamic data flow columns at runtime.Answered | 3 Replies | 2374 Views | Created by Debaser19 - Monday, February 13, 2012 10:32 PM | Last reply by COZYROC - Wednesday, February 15, 2012 3:40 AM -
0 Votes
How to import a dynamic excel sheet to a dynamic database table.
Hi, Try with below links ...Answered | 3 Replies | 5310 Views | Created by MarlonCo - Sunday, January 12, 2014 1:57 AM | Last reply by Harry Bal - Monday, January 13, 2014 9:50 PM - Items 1 to 20 of 2038672 Next ›
No announcements
