I have SSIS package that connects to particular view in SQL Server A (2008 R2 SP2) and migrates data to the table in SQL Server B (2008 R2 SP2). It is scheduled in SQL Server Agent to run every 60 minutes. The problem is that the when check the destination table after scheduled migration takes place, 4 float type columns have missing data (but only partially, some records contain the values). But when I execute the same package manually (through I have SSIS package that connects to particular