Hi

I need to dts an excel. Depending on where the excelfile is stored, this excel is must be dts'ed within the same database. So eg Folder :Track, file : verdeling.xls, it should dts'ed into database : track.

I am using software that is called automate. This is a service, triggering the file. When the file is saved in a specified drive it can start an executable or even better a stored procedure. I think i can start the dts using a stored procedure (how ?) and i can create a variable using that software. But how will i get my dts that far that he uses that variable to know which excel file and which database to use, so that I not need to create a package per database ?

Many thx

J