Dynamic File Definition for Source Files - 12-04-2006 , 09:30 AM
I am hoping that someone out there might be able to help me with a
requirement we have from our client.
We want to use SSIS to import our client's data into their database. The
issue is that the source file's column definitions may change. (For example,
new columns may be added or removed.) We have a set of column definition that
we support and the client can choose which columns to include. We store their
selections in the database, so we will have the file definitions available.
Is there a way to build a SSIS package that can read this file format data
from the table and use it to import the data from the source file?
Since the client can change their file formats at any time, we need the SSIS
package to react to the changes automatically, without the DBA going in and
redefining the source file format.
Any help or guidance would be appreciated...Thanks in advance.
RE: Dynamic File Definition for Source Files - 12-04-2006 , 01:21 PM
Hi Jen, i had worked with SSIS, and i think than that is not posible,
however you can use SSIS's .NET API to make a dinamic SSIS package. You can
find an example about that in this way: C:\Program Files\Microsoft SQL
Server\90\Samples\Integration Services\Programming Samples\Control
"Jen Espana" wrote:
Re: Dynamic File Definition for Source Files - 12-04-2006 , 03:38 PM
This will be ugly. The only cool, sure fire way to do this would be to dynamagically
build the imnport through the object model every time.
T +44 7966 476 572
F +44 2071 008 479
Re: Dynamic File Definition for Source Files - 12-04-2006 , 05:26 PM
This is what I thought I would need to do. We had to do something similar in
SQL Server 2000, but I thought maybe 2005 offered something new...
Thanks again for your help.
"Allan Mitchell" wrote: