August 11, 2008 at 1:44 am
I'm looking for someone with a lot of SSIS knowledge to give me their opinion on the best way to handle a scheduled data transfer from an AS400 file to a SQL Server table. In a nutshell we have "Master" data that is maintained on our AS400, and we would like to be able to use this data in a SQL Server database as well, so we'd like to have nightly updates from the AS400 to our SQL table to synch up the data. I'm trying to accomplish this with an SSIS package.
I'm new to SSIS packages, and sure I could figure something out on my own, but I'm interested in hearing opinions on best practices so that I might be able to avoid some rookie pitfalls.
I have been able successfully create an Ole DB Source for the AS400 that I want to pull data from.
Thanks!
for the schedule it run daily....
may i know how to make it as a schedule job,
i m using ssms to create this job, but i face a lot problem while doing.
i m using SSMS 2005 standard edition
may anyone help me for this problem??
August 16, 2008 at 11:30 am
Here is a thread that covers all you need the most important thing to know Microsoft have made changes that require Admin permissions in DB2 AS400 before the Job can work. That was not required in previous versions of SQL Server.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1963603&SiteID=1
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply