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 |
|
sportrx
Starting Member
4 Posts |
 Posted - 2008-04-11 : 15:31:09
|
| Hi,I have two variables1. strStatement datatype (string)2. objTable object (user tables)the string strStatment returns a dataset and is assigned to objTable.I want write the data from objTable to a sql table and it seems not to work.Here is what I did.I used data flow task to either select from a a string or objectTable.but it give me an error. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-12 : 01:23:40
|
| What all steps are inside your data flow? i guess you need a OLEDB source where you map your source object property to objTable variable, a command which will come from strStatement variable and then you will have a OLEDB destination which is your sql table. |
 |
|
|
|
|
|
ssis select from ssis user table