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 |
|
shahab03
Starting Member
28 Posts |
 Posted - 2007-06-12 : 10:45:27
|
| wondering if someone can share their wisdom about getting record count from Source Oracle DB using SSIS? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-12 : 11:02:39
|
| select count(*) reccount from tblGuess I'm not sure what your problem really is.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
shahab03
Starting Member
28 Posts |
Posted - 2007-06-12 : 11:06:03
|
| I would like to pass that value to a variable within SSIS. I think I need to use script task to accomplish it. But not sure how to pass the value and what import statement to use for Oracle source in the script. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-12 : 11:44:23
|
| Why not just use an sql task and set the variable from the output.Do you have to use ssis - I usually do something like thishttp://www.nigelrivett.net/SQLTsql/sp_ExecLinkedServer.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
shahab03
Starting Member
28 Posts |
Posted - 2007-06-12 : 11:45:02
|
| how do you do that? |
|
|
|
shahab03
Starting Member
28 Posts |
Posted - 2007-06-12 : 12:34:20
|
| yes I have to use SSIS. I just want to grab the record count from the source to later compare with the destination record count.so how do I use a sql task and set variable from the output. can you please list the steps.thanks |
|
|
|
|
|
|
get record count from source Oracle db