Friday, March 9, 2012
DTS Package - How to prevent a 0 byte file?
I've created a DTS package -- that uses a query to export to a .txt file. My question is -- if the results of this query are zero (no results returned within the package ) -- how can I tell the package not to export a zero byte file. Any thoughts on that? Any help you could give would be greatly appreciated. Thanks!Do you mean that the file doesn't exist (which would cause an error) or that it's a 0 length file?|||the package is producing a file that is 0 length. what i'd like to be able to do is -- if the file produced is 0 in length -- i would like for it not to output a file at all...does that help?|||Create a ExecuteSQL task that computes the COUNT() on your returning query and assigns it to a global variable. Then, create an ActiveX task that checks that global variable and performs the export only if it is noy null...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment