"Subbaiahd" <subbaiahd@hotmail.com> wrote in message
news:ua8Xp17DFHA.3728@TK2MSFTNGP14.phx.gbl...
> Allan,
>
> I wanted to get definition of a table dynamically from source whenevr it
> runs, source is a file system , it has odbc driver to support the file
> system. when i run manually thru wizards it is creating table and loading
> data. when i save the package, create table script is saving as sql script
> and i am not able to make it dynamic, is there a way for it
>
> i know how to set up dynamic properties for all other properties, this
> requirement needs to grab definition of the table from source (and source
> is
> not a sql server) for that i dont have a clue at all how to approach to
> the
> issue. I am ready to code whatever it takes if there is an option
> available.
> Thanks for your time
>
>
>
> Regards,
>
> Subbu.
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OUQenA8DFHA.3924@TK2MSFTNGP09.phx.gbl...
> This would have to be done through the driver I believe. .Net allows
> you to do this through the GetSchemaTable method on the IDataReader
> object although I am not suggesting you do this.
>
> Unfortunately I do not know how to query ANY datasource in this way
> although I wuld be interested in knowing.
>
>
> "Subbaiahd" <subbaiahd@hotmail.com> wrote in message
> news:subbaiahd@hotmail.com:
> > Allan,
> >
> > I wanted to get definition of a table dynamically from source whenevr it
> > runs, source is a file system , it has odbc driver to support the file
> > system. when i run manually thru wizards it is creating table and
> > loading
> > data. when i save the package, create table script is saving as sql
> > script
> > and i am not able to make it dynamic, is there a way for it
> >
> > i know how to set up dynamic properties for all other properties, this
> > requirement needs to grab definition of the table from source (and
source
> > is
> > not a sql server) for that i dont have a clue at all how to approach to
> > the
> > issue. I am ready to code whatever it takes if there is an option
> > available.
> > Thanks for your time
> >
> >
> >
> > Regards,
> >
> > Subbu.
>