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
Hi All, I am having problem with embeding map to a indesign CC page. - In Object menu I select "Insert HTML.." - Edit HTML box appears, I paste the code into the box. * text box appears says "This is an HTML Snippet" - I select map cod [More]
I'm new to Elements an am learning a new camera. I took a series of photos, all the same image, each using the different settings of my camera. I want to print a contact sheet, preferably, that has the image properties below each image so I can compa [More]
My Macbook Pro bluetooth has been erratic for a while, needing frequent reconnection with wireless mouse and keyboard (both peripherals are Mac), and now mouse has lost most functionality (no gesture response). Have tried several Apple mice, none wor [More]
Hai, I want to do good Issue with Serial Number using DI API but I got an error message <b>"\[IGE1.DocEntry]\[line:0],item serial is not found in Whse SR-5155 - 1 - R5155KGS ' (-5002)" </b> here is the code Set oGoodIssue = oCompanyD [More]
We connect fine to another Oracle database via DSN. However, when attempting to connect to a different database using a Driver={} and a dbq="" reference to specify the service name (which matches in tnsnames.ora), the ODBC Dialog Box appears and [More]
Hi all, I'm getting this fatal error when creating an RFC model in Web Dynpro for Java (connecting to a BW system): com.sap.mw.JCO$Exception: Missing R3NAME=... or ASHOST=... in connect_param in RfcOpenEx I have absolutely no clue what's going wrong. [More]
I have a dual boot laptop with XP and Win 2003 server. I have a 1 TB external HD connected to the laptop, on which i want to install ECC 6 and BI 7.0. I have installed Oracle and JDK as per requirement.But when SAP ECC 6.0 installation starts it does [More]
I'm trying to display the contents of :system.last_query. But the variable is only holding 255 characters. It should hold more. Ideas? Here is my code: (the output of message() should be a long where clause. what I get is just a few characters. add t [More]
Hey everyone - I have a quote form on my website that I'd like to tweak a bit. There are some fields that have a drop-down box of "Yes" or "No" and directly after that it says, "If Yes, ..." So, no matter which option is chos [More]
I've made a fighting game applet and I've made it in a way I believe it should be able to play with another player. Now I'm looking to network the game but I'm not sure how to do this exactly with an applet. I know how to connect between applications [More]