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
We are using XML Publisher 5.6.2. We have a requirement, where we need to display a multiple database rows for a single column in a single row. Basically say a database column has 5 rows A1 A2 A3 A4 A5 We want to display in the output in a single cel [More]
Hello, I am experimenting with JDeveloper 10.1.3.2. When I make any web application it runs fine in the embedded OC4J. When I try to deploy to standalone server however or to war or ear file it fails. I've noticed that the archive in fact contains on [More]
Hi , I am currently facing a problem with a report .The problem is in a select query.The report runs successfully when it is run for only more than 1 state but when it is run for single state then it times out.The select query is as given below. SELE [More]
I looked around and saw that some are having trouble with their right speakers but my problem is that my volume goes down randomly to where it sounds sort of like it is underwater and very quiet and then all at once it will shoot back up to clear sou [More]
Hi there. I'm trying to connect my iPhone 5c to my PC (win 8.1, USB 3.0) with the cable and as soon as I plug it in, it connects and disconnects like crazy, non stop. I tryied with another cable and it was the same. I tried with all the USB ports and [More]
Hi All, I want to create Logical standby database on 11gr2 on RHEL 5 without using oracle Grid Control. I already have a primary database as well as physical standby database. What i want to create a logical standby database as well on the same machi [More]
I was wondering if anyone knows how the Fiori Launch Pad works with Object Based Navigation (OBN)... The scenario I am imagining is that I have a tile defined on the Fiori Launch Pad that opens a Web Dynpro ABAP Application - within that application [More]
In order to activate 30x iPods, I had to try to tether them one by one to my iPhone 4. I would tether one, activate it, switch it off totally (my data provider only allows 1 or 2 tethers at the same time), then move on to the next one. Unfortunately, [More]
Hi Gurus, I have recently created a billing block which I have entitled Z2 - Goods Movement and assigned it to all customized Z sales documents. This is a requirement from our client wich has the following effect: - It still allows delivery to happen [More]
Hi, I am getting the following error message when I try to create a new Web Provider in portal: Oracle SSO Warning - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is [More]