February 27, 2008 at 10:13 pm
Hi Techies
I have the requirement to convert DTS packages(32 bit server) to SSIS packages(64 bit Server) , I would like to know can i do it smoothly as i never did this before and it is production server so can't take any risk.
If someone have done this before please share your experiances.
I will appriciate your comments , suggestions to make this happen.
Thanks in Advance
February 28, 2008 at 7:29 am
Make sure you compile all SSIS packages converted from DTS packages on a 64-bit machine. Do you have Oracle sources?.
February 28, 2008 at 10:26 am
Thanks jay
Yes We have Oracle Environment and have DTS packages dump information into Oracle 9i . Can you tell what might be hurdles to do it.
Regards
February 28, 2008 at 4:24 pm
We deployed SSIS packages on a 32-bit. Our initial plan was to deploy on 64-bit from which we backed out because all the developers were developing and compiling code on personal laptops which were 32-bit and our SSIS file based deployment on 64-bit machine didn't work with oracle sources (connectivity issues). We used "microsoft OLEDB provider for ORACLE". you can also use - "oracle provider for OLE DB" but you will have to be very careful with decimal fields.
Check these links for more:
http://stevemchugh.blogspot.com/2007/02/adventures-of-ssis-and-oracle-in-64bit.html
http://www.artisconsulting.com/Blogs/tabid/94/EntryID/5/Default.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply