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 |
|
vbobba
Starting Member
3 Posts |
 Posted - 2011-12-14 : 00:54:16
|
| Hello, I am able to connect to INformix database from Source task using Datareader source. I am calling Informix stored procedure. I need to pass date parameters with time. How can I pass time stamp? I am new to Informix. Here is my call.call db_XXX:sp_call_XXXX(today-1, today, 0, 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'OR|Test Name, 'NULL', -1, -1 )I want to pass (today-1 00:00:000) and (today 00:00:000)Thakn You |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-14 : 09:24:03
|
| I don't know the answer to your question, but I would try using ISO formats:'20111214 00:00:00.000'or'2011-12-14T00:00:00.000'(Note no hyphens in first format, and hyphens but no spaces in the second one) |
 |
|
|
vbobba
Starting Member
3 Posts |
Posted - 2011-12-14 : 09:42:38
|
| Thank you.I want Yesterday date. Can't hard code date for scheduling puposes. How can I send time with yesterday's date? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-14 : 10:26:47
|
| You can calculate it, convert it to a string of correct format, and then include it in your "call".Try it first though, manually, because if neither of those formats is acceptable to Informix you'll need a different solution. |
|
|
|
vbobba
Starting Member
3 Posts |
Posted - 2011-12-14 : 13:24:31
|
| All I have is Informix Stored Procedure name and the parameters names. I don't have privilages to modify Informix information . It belongs to 3rd party. I never worked with Informix before. I am MS SQl person. In SSIS package, in dataSource Reader can we calculate datetimetime before calling Informix SP? if so Can I use SQL code to generate datetime? or Do I need to use Informix code.Thank You |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-14 : 14:19:30
|
| "Try it first though, manually, because if neither of those formats is acceptable to Informix you'll need a different solution"Let me know if there is part of this that you don't understand and I will clarify. |
|
|
|
|
|
|
|
|
Calling Informix stored procedure from Source task