question

apple avatar image
apple asked

Uploading to Sharepoint

Hi! I have an SSIS package which loads reports to SharePoint. When run manually there is no issue but as scheduled job through SQL Agent it hangs Appreciate any suggestions. Thanks
ssissharepoint
6 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It hangs? As in the job never finishes? Are there any error messages?
1 Like 1 ·
Yes it hangs -- No error messages Thanks
0 Likes 0 ·
do you have any logging in the package to help identify where it's hanging? Might shed some light where to look.
0 Likes 0 ·
No this was an existing package in production and recently we started having issues -- I will add and see if I can get any details Thanks a lot
0 Likes 0 ·
It's a long shot but you can try it - check if there is a 32/64 bit mismatch. I had similar issue - package worked just fine from BIDS where it was executed in 32 bit env, but after deploying on server it executed in 64 bit env. Job never finished succesfully, often giving diffrent error messages. Solution was to execute package on server in 32 bit env(one checkbox at step properties).
0 Likes 0 ·
Show more comments

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.