ravi

Hi
I want to create a Text file in runtime , load data from
excel sheet into this file and then pick up data from it
and load data into a Table?
Thanks in Advance
Cheers
Ravi

allan mitchell

Is the format of the file constant ?
Is the format of the database table constant ?

If yes then you can have SQL Server DTS do this relatively easily.

You would build the package once in designer and if you need to change the
connection names you could pass those into the package at runtime.

If you need everything to be dynamic then it could be more problematic as
you would basically need to redefine the package each time. To see a lot of
the work involved with that but also to give you ahead start try saving a
package as a VB .bas file from designer and have a look

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
http://www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

ravi

Hi,
Thats great , I know a bit on how to do this using .INI
Files my problem is how do I create A Text File Dynamically
Ravi