DTS Packages

Hi all,

I'm trying to create a DTS package which imports data from an Access database into sql server 2000. I'm using the import wizard, but I want to run my own stored procedure within the package, because I need to do some very specific data transformations. So basically, I know that I can use the wizard, browse my server to select my .sql file which will do my transformations, but what I don't know is how to reference an Access database from a stored procedure which will be running in SQLServer. Any ideas? How do I write a select statement in my stored procedure to get data from the access database, so that I can store it in a variable to transform it before it gets imported into the sql server table?

I think you must create a package contain :
1. Transformation from access to sql
2. If success, you can use task "Execute SQL Task". You can use your transact sql here.