Hello friends i am migrating from oracle to sql there are 200 tables on oracle side. i was trying to use SSMA but as i am working on window xp that tool will not work. So now i am using SSIS. I am very new with SSIS so i started using Small packages for tables one by putting data conversion task oledb source and destination. Now i am thinking it will take more time. So is there any way that i can make a excellent package which can automate to some extent? if yes can anybody guide me in just starting? Thanks in advance..dimrd_SQL

If you have SQL Server Management Studio AND the Oracle driver installed on your workstation, then open SSMS, right click on a database, and select Import and Export wizard. Follow the prompts to import data from Oracle to SQL, but DO NOT RUN the resulting output. Instead, SAVE it to your hard disc, then open BIDS, open your SSIS Project, and add the .DTSX file from the wixard to your project. Then open the SSIS package and see what it did for you. It may have 200 data flow tasks all in one package that whould probably be broken out.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Create a UDL first to test Oracle connectivity from windows--Oracle Client---Oracle DB [oledb] ; Everything after this line is an OLE DB initstring Provider=MSDAORA.1;Password=xxxx;User ID=xxxx;Data Source=xxx;Persist Security Info=True

Thanks Mr Pro tools I checked every thing the connectivity is fine. Please tell me what shall i do now? Thanksdimrd_SQL