February 9, 2009 at 2:40 am
I have an SSIS which pulls data from AS400.
My source is ADO.NET ODBC pointing to a Client Access ODBC datasource that I created. Data access mode is 'SQL COmmand' where I set up a Select statement to query the columns I need from the As400 object
My destination is OLEDB pointing to the target table of the SQL server.
In between the source and destination is a Data Conversion node that converts all Unicode string columns to String
When I run this SSIS in BI, it works fine. But when I schedule it as a Job, (type SSIS Package, I use File system as the source), the job runs endlessly until i cancel it. When I check the table i pulled, it has all the records i need.
It seems that the SSIS has gone thru all the steps and pulls the data but the JOB never exists. I have to stop it manually otherwise, it will not run on the next schedule since the previous run didnt stop.
Any info on this would be a great help.
February 11, 2009 at 2:09 am
I checked the components of the SSIS package. I was wrong about the Job not finishing. The Job actually starts but doesnt go thru the tasks.
Still cannot figure out the problem.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply