
August 25th, 2004, 04:18 AM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL Server DTS Programming problem
Hello,
I need help in issue regarding the SQL Server DTS Programming if you don’t mind.I'm trying to create DTS package with VB.Net, in this package I want to create a Data Driven Query task.
As I know, DDQ task needs to specify a binding table to transform source data before it's mapped to the destination, my problem is that I don't know how to set this "binding table" programmatically to the task as I didn't found a property represents it.
When my package saved to the SQL server, I found the task binding table is the first table in the destination database which actually is not my binding table.
I appreciate your assistance so much.
Thanks.
|