DTS Package

Hi Everybody,

I am trying to execute this DTS package where I have to read the flat file and put it it in sql server database. I have to read the flat file path from the sql server database. How can I do this in dts package.

Any help will be greatly appreciated.

Take a look at the Dynamic Properties Task, that should do the trick

|||do you know any article which I can read and do this DTS package|||Try the link below for sample code. Hope this helps.
http://www.sqldts.com/|||The easiest way to get started is to right klick one table in Enterprisemanager and using the Importwizard to import the data once. At the end choose "Savs as DTS". This will generate a package that You can start with.
Mathias|||well I could not find anything. I tried to use Dynamic proeprty task, but somehow it is not working. I looked at the sqldts.com. I could not find that is transferring data from flat file to database and where we can read the flat file name from the database.
Pleasee let me know if someone has any other link. I really need help on this.
Thanks|||use "Text File" as Your datasource in DTS. You can choose the details (column delimiter, row delimiter) later.
Mathias