Hi experts,
i make migrate more tables from excel into sqlserver, so i think to use DTS.
This tables (more than 200) are all equals and i try tu use wizard and it
work.
How i make an automation to do this?

Thnaks for suggestion!

alberto

SQL Server 2000 DTS does not have any features that facilitate looping. Here
is an article that describes looping through the files in a directory:

http://www.sqldts.com/default.aspx?246

If you can write Visual Basic (or other) programming code, you could (1) use
global variables in a DTS package for your source workbook and worksheet
names and (2) loop in VB through your source worksheets, programmatically
executing the package repeatedly with the new variable values.

Q315661 HOW TO: Run a SQL Server DTS Package from Visual Basic
http://support.microsoft.com/default...;EN-US;Q315661

-Doug

--
Douglas Laudenschlager
Microsoft SQL Server documentation team
Redmond, Washington, USA

This posting is provided "AS IS" with no warranties, and confers no rights.

"3gA" <albertoi (AT) despammed (DOT) com> wrote