Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2007-08-15 : 06:32:42
|
| Hi, I've been strugling to set a parameter in Microsoft DB2 OLE DB Provider & tried setting SQLvariable but can't pass another SQL source variable as a parameter within the SQLvariable. So i'm trying something different. SQL Task, Expression (sqlstatement source) Expr: "SELECT sicust from b610clivF.SIH WHERE SIINVD = " + [User::DateFrom]It executes but can't set the ResultSet to:?(Full Result Set)in order to create a Data Flow Task and write the Result to a OLEDB Destination. Is this in anyway possible or any other way, can anyone please help? Regards, Ismail |
|
|
|
|
|
SQLTask ResultSet ? TO DataFlow Task OLEDB Destina