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
How do I use the built in microphone on a MacBook air?Go to System Preferences -> Sound  -> Input, then select Built in microphoneRead other 2 answers [More]
Hi - Ongoing problem since loading ITunes 7. When I update the iPod after music transfers, iTunes says "Update complete", but the iPod continues to say "Updating - Do not remove" (I once let it go for two hours and it continued to say [More]
Well, I receive my new Mac Pro (Apple Mac Pro Desktop 2.66GHz Intel Core 2 Quad) When I tried to hook up my Samsung SyncMaster 910T the connectors don't match. Mine has 15 pins (3 row of 5, with the middle one out of sync with the two others. I found [More]
how many number of tables to be created in the oracle database? and how many rows to be created in one table?Hi, Logically, there is no limit on the amount of table or amount of rows. http://download-west.oracle.com/docs/cd/B13789_01/server.101/b1075 [More]
How can I view the results of my worklofw diagrams in SQL DeveloperRight click on the build model node and then select View Models from the menu. You will get a list of the models that were build. Select one of these and you can then see the details [More]
I am working through Monica Pawlan's book "Essentials of Java PL". My PC runs Windows2000 prof. I have downloaded and installed j2sdk-1_3_1_01-win.exe in c:\jdk1.3.1_01 I have downloaded and installed tomcat4.0 (jakarta-tomcat-4.0.zip) into c:\j [More]
Hi All, I am confirming the vendors through FK08 but it is allowed to confirm only single vendor at a time. Please advice any trascation which is allowed to confirm the more than one vendors. Thanks & Regards, PankajDear Pankaj, You can use FK09 for [More]
Dear All,   We have successfully migrated all the reports which were created in CR 8.5 to CR 11. But those same reports developed in CR 8.5 are called through .exe which has been built with Microsoft Visual Studio .NET 2003. The old reports of CR 8.5 [More]
I have some hs_err_pid<pid>.log files. I want to trace out the root cause of application crash. How can I use the log file to do this? Contents of a log file are given below: # An unexpected error has been detected by Java Runtime Environment: # SIG [More]
Hi Expert I want to import oracle 10g dump to oracle 9i is it possible ?????????? but how Thanks MadhveshWelcome to the forums ! Pl post details of your OS and database versions. Pl see MOS Doc 1065604.1 (How to Import to lower version database or ru [More]