Re: DTS - Excel file path from a table
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 12/16/04
- Previous message: FRED: "Re: parsing txt file"
- In reply to: MS User: "DTS - Excel file path from a table"
- Next in thread: MS User: "Re: DTS - Excel file path from a table"
- Reply: MS User: "Re: DTS - Excel file path from a table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 21:28:53 -0000
You would probably want to have a look at these two articles then.
Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)
How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - You thought DTS was good. here we show you the new stuff. www.konesans.com - Consultancy from the people who know "MS User" <sqlman@sql.com> wrote in message news:u$ZIoQ74EHA.924@TK2MSFTNGP14.phx.gbl... > SQL 2000 > > I got a table with file names and path for the Excel files to be loaded > into a sql table. > My plan is to use DTS and global variable to assign the path and file name > and use that as the source for the data-pump. > > Any thoughts or sample code to achieve this ?? > > Thanks In Advance > Jeff > >
- Previous message: FRED: "Re: parsing txt file"
- In reply to: MS User: "DTS - Excel file path from a table"
- Next in thread: MS User: "Re: DTS - Excel file path from a table"
- Reply: MS User: "Re: DTS - Excel file path from a table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
