Sitemap

Amicuk Programming Answers

Dynamic Column Names in Flat File Destination

2015-10-11   Views:1

Advertisement

Hello, Inside a Data Flow Task, I have an ADO.Net data source which executes a stored procedure that provides results in 5 columns. The requirement is to have it connect to a flat file destination, such that the column names is dependent on what data

Hello,
Inside a Data Flow Task, I have an ADO.Net data source which executes a stored procedure that provides results in 5 columns.
The requirement is to have it connect to a flat file destination, such that the column names is dependent on what data was pulled by the data source. There is a variable indicator which identifies the data that was pulled. For example:
If the indicator is 0, then the columns names will be A,B,C,D,E. Otherwise, if the indicator is 1, then column names will be V,W,X,Y,Z.
Any suggestions will be of great help.
AJ

The replay answer
Advertisement
If you only have two variations then use a branched execution (based on precedence constraints) and direct it to one DFT or another based on the result returned by the stored procedure.
Otherwise use .net
code to create one package or another dynamically.
PS: I suggest not to bother using SSIS for such a simplistic scenario.
Arthur My Blog

Go to See the other 4 answers

Dynamic Column Names in Flat File Destination

Category:DefaultRelease time:2015-10-11Views:130

Hello, Inside a Data Flow Task, I have an ADO.Net data source which executes a stored procedure that provides results in 5 columns. The requirement is to have it connect to a flat file destination, such that the column names is dependent on what data[More]

Dynamic Header Values in Flat File Destination

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have to put 'T' or 'P' as part of a header in a flat file destination. The header is sourced via a work table which defines what the header looks like. One of the columns should contain 'T' for test or 'P' for production. When the package is ex[More]

Flat file destination error

Category:DefaultRelease time:2015-10-11Views:130

hi i am adding new field to my existing package which is char(10). getting this error: [Flat File Destination [139]] Error: Data conversion failed. The data conversion for column "MEMBER_ID" returned status value 4 and status text "Text was[More]

Reorder columns in Flat File Destination

Category:DefaultRelease time:2015-10-11Views:130

Hi Friend's Although, I did some google in order to find the solution for reording the columns before exporting to a text file using FLAT FILE DESTINATION, one of the work around which i found is editing the final package xml file and moving the DTS:[More]

[Flat File Destination [220]] Error: Failed to write out column name for column "Column 2"

Category:DefaultRelease time:2015-10-11Views:130

I am using SSIS to extract fixed width data into a flat file destination and I keep getting below error. I have tried almost everything in this forum but still no solution. can anyone help me out to solve this problem. [Flat File Destination [220]] E[More]

Flat File Destination Multiple Delimiters

Category:DefaultRelease time:2015-10-11Views:130

Hi Guys, This might been an easy one for you. I need to find out if the data from a table can be loaded into a text file with multiple delimiters or not using SSIS? For example, if I have 2 columns of data from a table, ID Name 100 Mark I need to loa[More]

Flat file Destination VS Raw file Destination ??

Category:DefaultRelease time:2015-10-11Views:130

Team , Can some help me understand few differences and similarities  between Flat File Destination and Raw File Destination ? Thanks in advance . Rajkumar YeluguHi, Please check these differences :- Flat File Destination: The Flat File Destination co[More]

Header in flat file destination (ssis)

Category:DefaultRelease time:2015-10-11Views:130

Hi I am creating a header in the flat file destination which has some hard coded values and record count which will get its value from a variable assisgned to a row count transformation in the package. There is no problem in hard coded value but when[More]

Merge/Concat Multiple Columns in a Flat-File wthin ODI

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I was wondering if there is a quick way to merge/concat multiple columns in a Flat-File from within ODI, a functionality kinda similar to Essbase load rule files for join/split columns etc. Please let me know. ThanksLooks like the CONCAT function[More]

How to create a dynamic SSIS package for multiple flat file destinations

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have to create a ssis package which has single data flow task and inside that I have 23 source (sql- select * from - statements)- destination (flat files, 23 distinct) connection. Now for each product I have to create separate SSIS package (i.e[More]

SSIS : How to create Column Header dynamically using expression in Flat File Source

Category:DefaultRelease time:2015-10-11Views:130

Hi Team, I need to keep configured Header Names for columns, Is there is any way to set each column name from expression? or is there is any other way?Nope But you could add a dummy row to your source to include column headers and then use options co[More]

Hot
I am going to upgrade to Lion.  First have to back up computer.  What external hard drives should I buy in order to use time machine.  I have a 320 GB hard drive.  Don't have too much on computer.patmc102 wrote: I am going to upgrade to Lion.  First [More]
Hi, Macbook Pro 10.6.8 yahoo ect tells me to upgrade Safari. I guess I can't unless I buy m.Lion. Now safari will not quit. Quit is no longer highighted on my safari drop down menu. Help thanks, MaryHi Mary, Force Quit Safari by clicking Option+Comma [More]
Hello, I recently started using Oracle ADF with MySQL at design time. I am following instruction from http://www.oracle.com/technetwork/developer-tools/jdev/mysql-and-bc-howto-082060.html With Jdeveloper, I created following tables with Mysql Databas [More]
< MODERATOR:  Per the forum [rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement], please use an appropriate subject in your message.  "urgent" or "please" are not allowed.  Message locked. > Dear frnd [More]
when installing third party software, how do I temporarily turn off the factory installed virus sw and firewall?  Is it necessary on a Mac to do so?  I come from the Windows world and am still in the learning curve on the Mac.Correct.  I have not ins [More]
Hi,      I have a requirement wherein im uploading multiple files using an Applet to ADF. With the file sizes relatively lower this works fine but now we have a request to upload bigger files, so the only option i could find is to send the uploaded f [More]
Hi Experts, How to make  Business place and Scetion code madatory field in MIRO and FB60. bcoz while posting a entry to vendor it is not asking B place and S Code. Thanks in advance JAvedwrite the validation like this Prerequisite SYST-TCODE = 'FB60' [More]
Just received a new Imac running OS10.8 Mountain Lion. I have MS Office 2004 that ran ok on OS 10.6 Snow Leopard. I'm told that this software will not work on the new OS. Are there any work arounds?Nancy L F wrote: Just received a new Imac running OS [More]
For some reason, i can't drag my music into my iPod or anything in the panel on the right hand side for that matter (playlists, ect..) I updated my iTunes and it still does not work. Has anyone had this problem before? 1   Windows XP  Check to see ho [More]
Hi, today I was consolidating various projects into a on project consisting of Albums. In order to do so I selected the project which I wanted to consolidate and dragged all the pictures into the new project. After doing so with various projects I no [More]