July 19, 2012 at 11:17 am
Good afternoon,
I use openquery to insert data into a table in SQL then I convert the AS400 date format to SQL datetime format. I do these separately. I want to combine them into one job after verification of inserted data. Is this possible?
July 19, 2012 at 11:20 am
Are you using Select From OpenQuery? If so, you can do the date conversion in your Select clause.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 19, 2012 at 11:54 am
Yes, I am using SELECT From OPENQUERY. I'll try that. Thanks!
July 19, 2012 at 1:20 pm
it worked. :w00t: Thanks!!!
July 19, 2012 at 1:54 pm
I resolved this issue by using EXCEPT in 2005 and creating Maintenance Plan in SSIS to run on a schedule. Thanks!
July 20, 2012 at 8:45 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply