dynamically decide which SSIS package to use.

Question

Post reply

dynamically decide which SSIS package to use.

vikasdotnetresource

SSC Rookie

Points: 29
More actions
August 1, 2008 at 1:09 pm

#382113

Hello Everyone,
This is my first post on this forum. I have different SSIS projects which I want to call from a single SSIS project dynamically. Lets say I have 4 different SSIS packages which are used to import data from flat files with different meta data.
I wanted to develop a SSIS package which reads the flat file first, then read the columns from it, depending upon the number of columns present in the file, I want to call the SSIS package which can handle that file.
Upon some research, I have known that script task can be used to achieve this. But am not sure, how to use the script task to read the first column, then read the number of columns in it, and then call the appropriate package which can handle that flat file.
Any help truly appreciated. Thanks in advance for your time.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Fozzie SSCrazy Points: 2222 More actions · Answer 1

Have the file source as a single columns, then count the number of column deliminators?

This is quite a good source for info:

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/08/handling-flat-files-with-varying-numbers-of-columns.aspx

slakhanp Valued Member Points: 51 More actions · Answer 2

Hi,

The Simple logic for this Package is that While reading data from flat file use row count transform.After Reading data from flat file using data flow task.Use expression in place of constarint.based on expression use execute ssis package task.If u have any questions .Please mail me at s.lakhanpal6776@gmail.com.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

slakhanp (9/9/2010)
Hi,
The Simple logic for this Package is that While reading data from flat file use row count transform.After Reading data from flat file using data flow task.Use expression in place of constarint.based on expression use execute ssis package task.If u have any questions .Please mail me at s.lakhanpal6776@gmail.com.

Row Count? Didn't the OP say based on the nimber of columns, not rows?

I can't see how this would help in any way.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

I would use a script task in the control flow.

The .NET code should read the first line; count the number of delimiters; set variable equal to the count. (How? Hint, lookup FileStream & StreamReader)

Use the value of that variable in the expression of you precedence constraint to determine which path to follow.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

slakhanp Valued Member Points: 51 More actions · Answer 5

yes i am raelly sorry.For my earlie post.We need to use script transformation for reading the numbner of column.On that basis we can do the logic.