I am new to creating DTS packages, and I have a question.

I have been using a DataPumpTask to perform a data transformation from SQL to Access. My sourceSQLstatement comes from a pretty complex view. The view creates temporary columns in its result. It is not a stored procedure. Does that matter? If it does, should I use a DataDriven QueryTask instead?

Also, do I have to define the columns? I have used DAO to create the columns and datatypes in Access already. If I do, do you have a little example of how to define the columns?

Your help would be very much appreciated. I have been pulling my hair out on this for about two weeks.