Ive got an excel workbook, with multiple sheets, that i need to import into a table in SQL Server 2000.
Is it possible to use global variables in the package select list?
eg....at the moment it looks like this..
Would anyone know how to go about this, please explain :D
Thx for the help.