I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database.
What the package does.
1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly.
2. Truncate the tablse. Verified to see the record count is 0.
3.Copies the data from the FTP'ed file to the tables. Verified to see the table is loaded.
4.Calls a stored procedure. Verified the log table to see the message of the last step in stored procedure is executed.
5.Added one more last step in the package to log an entry in the table to see the lat step in package is executed. This also works fine.
6. The job still shows "In Progress..." I have to manually close this job.
June 11, 2011 5:10 PM
June 13, 2011 5:47 PM