October 1, 2009 at 7:46 pm
Oh! great minds,
I "made a SSIS Package" that works from development but not once scheduled. Hold! it sounds just like many posts, but it is different.
The SSIS has three steps:
1.Runs a .exe file that queries DB, and generates n .xls files from resultset and writes to .txt file the path a full name of these files (file's path & names vary every day)
2. Script Task reads file's names and builds a variable with them to set the attachment(s) to be sent out via mail.
3.Mail task to send files.
(there is another mail task to report failure of course)
Well, it all works just fine when triggered from development, but when scheduled, .exe runs, files are created, but won't write to .txt file (it does not report error or what so ever), therefore the script task can't build the variable (attachments) and mail task fails.
I just thought of another way to get around it, but it would be a petty to disassemble the SSIS.
Can you offer guidance?
Thank you so much for you time 🙂
Alex.
October 1, 2009 at 8:47 pm
Did you make sure that the path you are specifying in Dev environment and server environment do exist and are same. Also the account from which you run the SSIS package has appropriate access rights to all of the resources including directory where the file is being read or written.
Swarndeep
http://talksql.blogspot.com
October 2, 2009 at 6:11 pm
Hi,
Thanks for your idea; unfortunately for me, paths are the same and do exists. The account used to run the SSIS pack in the server has full privileges (it is the Domain’s Admin) we have also tried with lo local admin’s account as well (these do have full control over the directories, etc), but have been unsuccessful.
Since this is supposed to be already in production :p I have decided not to dwell on this issue any more and will re-write the SSIS to eliminate the need for this .txt control files. I just need to chop something here, sever a bit over there, add another Script step and saw the hold thing back together 🙂
Once again, thanks for your interest in my SSIS-tematic problem!
Best regards,
Alex.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply