No announcements
Found 1533017 threads
-
0 VotesDynamic 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 | 3620 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 | 21644 Views | Created by Vick72 - Wednesday, December 26, 2012 8:50 PM | Last reply by Vick72 - Thursday, December 27, 2012 6:57 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 | 3800 Views | Created by sharepointduke - Friday, January 20, 2012 7:24 PM | Last reply by Shahfaisal Muhammed - Saturday, January 21, 2012 1:37 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 | 1031 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 | 1401 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
Excel source with Dynamic Column Name
HAve you checked that First row has column names property in excel connection manager ..Answered | 18 Replies | 6889 Views | Created by MS308 - Tuesday, January 3, 2012 7:31 AM | Last reply by MS308 - Thursday, January 5, 2012 4:08 PM -
0 Votes
How to generate column name dynamically in ssrs report
You don't want to name the columns dynamically, this will result in your report breaking.Answered | 3 Replies | 3555 Views | Created by SQL MSBI - Monday, October 5, 2015 3:28 PM | Last reply by Guoxiong Yuan - Monday, October 5, 2015 8: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 | 1001 Views | Created by Bob_Tang - Monday, August 6, 2018 9:29 PM | Last reply by Bob_Tang - Tuesday, August 7, 2018 10:02 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 | 5010 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
exporting data to excel with dynamic column names
Please check below ...Answered | 2 Replies | 4083 Views | Created by madhur_ms - Wednesday, September 28, 2011 3:02 PM | Last reply by ArthurZ - Wednesday, September 28, 2011 6:51 PM -
0 Votes
Dynamic Column Names in Flat File Destination
It is an extension of the standard Data Flow Task and supports dynamic metadata (columns) at runtime.Answered | 3 Replies | 975 Views | Created by AJ0520 - Wednesday, March 19, 2014 7:45 PM | Last reply by AJ0520 - Thursday, March 20, 2014 5:40 PM -
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 | 18279 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
Dynamic Column
Not sure if I fully understand your question but I think you're describing dynamic datasets?Answered | 3 Replies | 1174 Views | Created by vamsi1980 - Wednesday, June 12, 2013 8:22 AM | Last reply by SathyanarrayananS - Wednesday, June 12, 2013 11:15 AM -
1 Votes
Column name variable without dynamic query
END Beware this assumes that all columns have the same data type.Answered | 6 Replies | 3375 Views | Created by Pratap09 - Thursday, July 7, 2016 9:07 AM | Last reply by Erland Sommarskog - Thursday, July 7, 2016 10:09 PM -
0 Votes
How to have dynamic column names in an Excel Destination?
First you cant do this in a DFT so you cant do it with OLE SOURCE Excel destination object, you can use Scripts and OPENROWSET outside of DFT in a package using TSQL ...Answered | 2 Replies | 4147 Views | Created by Wayne Sheffield - Thursday, September 9, 2010 5:58 PM | Last reply by ArthurZ - Friday, September 10, 2010 3:32 AM -
0 Votes
how to fill data with dynamic column names to tablix?
Because the column name is dynamic, so we cannot specify the column name which use to calculate the percentage in the two new column.Answered | 6 Replies | 2249 Views | Created by Di Yang - Wednesday, February 27, 2013 10:52 AM | Last reply by Charlie Liao - Wednesday, March 6, 2013 1:50 AM -
0 Votes
Column values to be converted as Column names
If you don't want to hard code, the you would need to create dynamic PIVOT script.Answered | 7 Replies | 757 Views | Created by mirandaroopa - Wednesday, March 11, 2015 7:27 AM | Last reply by mirandaroopa - Friday, March 13, 2015 6:11 AM -
0 Votes
Renaming dynamic column names according to rules
Hi, Try below links : (for examples on how column names are formed dynamically while ...Answered | 6 Replies | 1768 Views | Created by smetah - Friday, November 1, 2013 2:04 PM | Last reply by SathyanarrayananS - Tuesday, November 5, 2013 5:02 PM -
2 Votes
Invalid Column name @..
Hi Dheeraj pk , This use of dynamic SQL go create table mytable(ID int,Name nvarchar(20)) go create ...Answered | 4 Replies | 5006 Views | Created by Dheeraj pk - Friday, July 10, 2009 7:36 AM | Last reply by 中國風 - Sunday, July 12, 2009 3:43 PM -
0 Votes
Union All with multiple exec(@query) with dynamic column name
Hi Anuj, In your scenario, as your query will return dynamic column names.Answered | 3 Replies | 3152 Views | Created by Pratap09 - Wednesday, November 22, 2017 3:15 PM | Last reply by Xi Jin - Thursday, November 23, 2017 3:09 AM - Items 1 to 20 of 1533017 Next ›
No announcements
