SSIS treat a field as NULL when it is not
Hello all, I have a stored procedure that feeds data to an SSIS package. I have code in Script object of the SSIS package to send emails out to users. A SQL job was created and scheduled to run this SSIS package once a day. For some reason one of the field value returned by the stored procedure is being treated as NULL value when the SQL job runs. As a result a value in the email is missing. But when the same stored procedure is executed in SQL management studio, I can see that field's value is not null. When I execute the package manually from the development environment, I can see that particular field value included fine in the email. This is also working fine when I run the SQL job in staging environment. Both SQL servers have same patches and all. Did anyone come across with this kind of issue?
December 15th, 2011 1:23pm

Hi Shil, We need more info on what is going on. What do you see in case it is not NULL? Is it always NULL in prod? Pictures?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2011 9:17pm

Hi Shil, My suggestion is to put the stored procedure in the SQL Server Agent Job, and then see if the value is null. And you say it is working fine when running the SQL job in staging environment, please alos verify the databases you are using in both SQL Servers have the same data. If the issue still exists, please supply more information about the issue, such as how do you design the package, and then we could help you better. Thanks, Eileen
December 21st, 2011 10:19am

Hi Shil, My suggestion is to put the stored procedure in the SQL Server Agent Job, and then see if the value is null. And you say it is working fine when running the SQL job in staging environment, please alos verify the databases you are using in both SQL Servers have the same data. If the issue still exists, please supply more information about the issue, such as how do you design the package, and then we could help you better. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
December 21st, 2011 6:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics