-
Datapumptask or DataQueryDrivenTask?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|