You cannot change the metadata (i.e. column info) of a data-flow at runtime.

-Jamie

The only real way is to add the field name (which you will have stored in a variable from the ForEach loop) as a new column using the Derived Column transform.

Are you...

Juan,

Send me the file and a CREATE TABLE script and I'll have a go. I love a challenge.

jamie.thomson@nospam.conchango.com

-Jamie

Each of the packages will operate as seperate processes so yes, they all execute in their own area in memory (depending on the ExecuteOutOfProcess property).

As far as the calling package...

Juan,

There is most certainly a learning curve with SSIS. The extra complexity has been added for a reason, mostly for issues of security. I kind of agree with Joseph, messing...

John's original post here always makes me laugh when I come back to re-read it (which i do often).

This article in particular reminded me of it: http://weblogs.sqlteam.com/jeffs/archive/0001/01/01/5248.aspx

And don't miss...

SSIS is not reliant on having SQL Server database engine installed.

If a machine is executing SSIS packages then it will require SSIS installing on it.

Can you put it inside an installation...

Its probably a security issue. You'll quite often find that packages that execute OK in BIDS don't execute under Agent. The package will execute under the security context of the user that executes...

Not quite sure what you mean by "clients". If you mean a remote database server to which you are transferring data then you don't need anything installed on them.

-Jamie

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1

The average size of the record in the source file is irrelvant in this context. What is the width of a row when it is in the SSIS pipeline?

If the average...

What's the width of the column?

How many is 32,00? Is it three thousand two hundred?

-Jamie

See my reply to your post on the SSIS forum

-Jamie

Gita,

Select the variable in the Variables pane and press F4. You will see the EvaluateAsExpression property in the properties pane.

-Jamie

Yeah, rubbish isn't it. And today we have upgraded Visual Studio to Team Foundation Server (TFS) which means our SourceSafe database has been migrated to TFS as well.

Lo and behold,...