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 |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2012-01-18 : 06:00:55
|
| hii created a project in ssis..now by using variable i will pass dbconn, whether it is oracle or sql server..now i want to pass current_date as variable..how to pass current_date as variable, that variable will work in both environment (ie,oracle,sql server)in ssis for current_date i choosed datetime in datatype..in that value i cant write this getdate() and all how to do this in ssisanand |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-18 : 07:18:59
|
| You can use CURRENT_TIMESTAMP - It works in T-SQL; It is ANSI standard, so I am GUESSING that it will work in Oracle as well - but I am only guessing, I have no experience with Oracle. |
 |
|
|
|
|
|
ssis varaibles